Get Record

TOOL

Slug

AIRTABLE_GET_RECORD

Version

20261013_00

Toolkit

airtable

Retrieves a specific record from an Airtable table by its record ID. Requires a known, valid record ID obtained from listing records or another API call - this tool cannot search or list records. Use the list records tool to find record IDs. Empty field values are not returned in…

baseIdrequired

STRING

ID of the Airtable base.

recordIdrequired

STRING

ID of the record to retrieve. Must be a real record ID obtained from listing records or another API call. Format: starts with 'rec' followed by exactly 14 alphanumeric characters (e.g., 'rec4YsVV8cU6V4EiT'). This tool retrieves a single specific record - to list or search multiple records, use the list records tool instead.

timeZone

STRING

Time zone for formatting dates when cellFormat='string'. Required when cellFormat='string'. Uses IANA time zone format (e.g., 'America/New_York', 'Europe/London', 'UTC').

cellFormat

STRING

Controls cell value formatting: 'json' for native types, 'string' for all values as strings. When 'string', timeZone and userLocale are required.

Options: json, string

Default: "json"

userLocale

STRING

User locale for formatting dates when cellFormat='string'. Required when cellFormat='string'. Uses BCP 47 language tag format (e.g., 'en-us', 'en-gb', 'de-de').

tableIdOrNamerequired

STRING

ID or name of the table.

returnFieldsByFieldId

BOOLEAN

If true, field keys in the response are field IDs; otherwise, field names.

Default: false