---
title: getRecord() function
description: >
  The `getRecord()` function extracts a record from a table given its index.
  If the index is out of bounds, the function errors.
aliases:
  - /influxdb/v2.0/reference/flux/functions/built-in/transformations/stream-table/getrecord/
  - /influxdb/v2.0/reference/flux/stdlib/built-in/transformations/stream-table/getrecord/
  - /influxdb/cloud/reference/flux/stdlib/built-in/transformations/stream-table/getrecord/
menu:
  flux_0_x_ref:
    name: getRecord
    parent: universe
weight: 102
flux/v0.x/tags: [dynamic queries]
related:
  - /{{< latest "influxdb" >}}/query-data/flux/scalar-values/
introduced: 0.29.0
---

The `getRecord()` function extracts a record from a table given the record's index.
If the index is out of bounds, the function errors.

```js
getRecord(idx: 0)
```

{{% note %}}
#### Use tableFind() to extract a single table
`getRecord()` requires a single table as input.
Use [`tableFind()`](/flux/v0.x/stdlib/universe/tablefind/)
to extract a single table from a stream of tables.
{{% /note %}}

## Parameters

### idx {data-type="int"}
Index of the record to extract.

### table {data-type="table"}
Input table.
Default is piped-forward data ([`<-`](/flux/v0.x/spec/expressions/#pipe-expressions)).

## Example
{{% flux/sample-example-intro %}}

```js
import "sampledata"

sampledata.int()
    |> tableFind(fn: (key) => key.tag == "t1")
    |> getRecord(idx: 0)
    
// Returns {_time: 2021-01-01T00:00:00.000000000Z, _value: -2, tag: t1}
```