Web API
Records

Get record

gethttps://api.airtable.com/v0/{baseId}/{tableIdOrName}/{recordId}

Retrieve a single record. Any "empty" fields (e.g. "", [], or false) in the record will not be returned.

Note If we can't locate the record on a given table, the request will fallback to a base wide search and will still return the record if the Record ID is valid and the record is located within the same base.

Requirements

AuthenticationPersonal access token, OAuth integration
Scopedata.records:read
User role

Base read-only

Billing plansAll plans

Path parameters

baseId
string
tableIdOrName
string
recordId
string

Query parameters

cellFormat
optional<"json" | "string">

The format that should be used for cell values. Supported values are:

  • json: cells will be formatted as JSON, depending on the field type.
  • string: cells will be formatted as user-facing strings, regardless of the field type. The timeZone and userLocale parameters are required when using string as the cellFormat.

Note: You should not rely on the format of these strings, as it is subject to change.

The default is json.

returnFieldsByFieldId
optional<boolean>

An optional boolean value that lets you return field objects where the key is the field id.

This defaults to false, which returns field objects where the key is the field name.

Response format

id
string

Record ID

createdTime
string

A date timestamp in the ISO format, eg:"2018-01-01T00:00:00.000Z"

fields
object

Cell values are keyed by either field name or field ID (conditioned on returnFieldsByFieldId).

See Cell Values for more information on cell value response types.

key: stringCell value