Get record - Automate.ax

airtable.getRecord returns a record and the field values visible to the connected account.

Example

automations/get-airtable-record.automation.ts

import { automation, onDashboardRun } from "automate.ax"
import { airtable } from "automate.ax/airtable"

export default automation("Get an Airtable lead", () => {
  onDashboardRun({ title: "Get an Airtable lead" })
  airtable.getRecord({ baseId: "appCRM", table: "Leads", recordId: "rec123" })
})

Inputs

Input	Type	Required	Default	Description
`baseId`	`string`	Yes	None	Stable Airtable base ID.
`table`	`string`	Yes	None	Table name or stable table ID.
`recordId`	`string`	Yes	None	Stable Airtable record ID.
`returnFieldsByFieldId`	`boolean`	No	`false`	Key `fields` by stable field ID rather than field name.
Second argument: `{ account }`	`string \| IntegrationAccountReference<"airtable">`	No	Project default	Connected Airtable account.

Output

Returns an AirtableRecord with id: string, createdTime: Date, and fields: Record<string, JsonValue>. Keep id for update and delete actions. Airtable omits fields with empty values from many API responses, so don’t assume every table field is present.