List records - Automate.ax

airtable.listRecords returns matching records across all Airtable result pages.

Example

automations/list-open-leads.automation.ts

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

export default automation("List open Airtable leads", () => {
  onDashboardRun({ title: "List open Airtable leads" })

  airtable.listRecords({
    baseId: "appCRM",
    table: "Leads",
    fields: ["Name", "Value", "Status"],
    filterByFormula: "{Status} = 'Open'",
    sort: [{ field: "Value", direction: "desc" }],
    maxRecords: 100,
  })
})

Inputs

Input	Type	Required	Default	Description
`baseId`	`string`	Yes	None	Stable Airtable base ID.
`table`	`string`	Yes	None	Table name or stable ID.
`fields`	`string[]`	No	All visible fields	Field names or IDs to return.
`filterByFormula`	`string`	No	None	Airtable formula that each record must satisfy.
`view`	`string`	No	None	View name or ID used to constrain and initially order records.
`sort`	`{ field: string; direction?: "asc" \| "desc" }[]`	No	None	Ordered sort rules. Each direction defaults to `"asc"`.
`pageSize`	`number`	No	`100`	Records requested per provider page, from 1 through 100.
`maxRecords`	`number`	No	No limit	Maximum records returned across all pages.
`returnFieldsByFieldId`	`boolean`	No	`false`	Key fields by stable ID instead of name.
Second argument: `{ account }`	`string \| IntegrationAccountReference<"airtable">`	No	Project default	Connected Airtable account.

Output

Returns { records: AirtableRecord[]; count: number }. Each record contains id, createdTime, and fields. When both view and filterByFormula are present, Airtable applies both. A sort supplied here overrides the view’s ordering. Invalid formulas and unknown field names fail with Airtable’s provider error.