Update records - Automate.ax

airtable.updateRecords updates records in one table, sending up to 10 per Airtable request. It returns their new values.

Example

automations/update-airtable-records.automation.ts

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

export default automation("Close Airtable tasks", () => {
  onDashboardRun({ title: "Close Airtable tasks" })
  airtable.updateRecords({
    baseId: "appOperations",
    table: "Tasks",
    records: [
      { id: "recOne", fields: { Status: "Done" } },
      { id: "recTwo", fields: { Status: "Done" } },
    ],
  })
})

Inputs

Input	Type	Required	Default	Description
`baseId`	`string`	Yes	None	Stable Airtable base ID.
`table`	`string`	Yes	None	Table name or stable ID.
`records`	`{ id: string; fields: Record<string, JsonValue> }[]`	Yes	None	One or more record updates.
`mode`	`"merge" \| "replace"`	No	`"merge"`	Strategy applied to every record.
`typecast`	`boolean`	No	`false`	Ask Airtable to coerce string values.
`returnFieldsByFieldId`	`boolean`	No	`false`	Key returned fields by stable IDs.
Second argument: `{ account }`	`string \| IntegrationAccountReference<"airtable">`	No	Project default	Connected Airtable account.

Output

Returns the updated AirtableRecord[] in provider batch order.

Replace mode can clear omitted writable fields. Batches are not transactional: a later failure does not roll back earlier updates.