List Records

List records

GET/{baseId}/{tableIdOrName}

Use it in a workflow

Add a step and choose the Airtable connector.
Pick the List Records action (under Records).
Fill in the fields below, then reference the result from later steps as {{listRecords.response.data}}.

baseIdstringrequired

The Airtable base ID (starts with "app").

tableIdOrNamestringrequired

The table ID (starts with "tbl") or the table's name.

fields[]array<string>

Only return these fields (by name or field ID). Omit to return all fields.

filterByFormulastring

An Airtable formula used to filter records, e.g. "{Status}='Done'".

maxRecordsinteger

The maximum total number of records to return across all pages.

pageSizeinteger

Number of records per page (max 100).

sort[]array<string>

Sort field/direction pairs, e.g. "field=Name" and "direction=asc" as repeated params.

viewstring

The name or ID of a view; filters/sorts/fields from the view apply unless overridden.

cellFormatstring

Format for cell values. Defaults to "json".

One ofjsonstring

timeZonestring

userLocalestring

offsetstring

Pagination cursor returned by a previous listRecords response, to fetch the next page.

returnFieldsByFieldIdboolean

If true, keys in the returned "fields" object are field IDs rather than field names.

Returns 200 with an object. Read it in later steps with {{listRecords.response.data.<field>}}.

recordsarray<object>

idstring

createdTimestring (date-time)

fieldsobject

offsetstring

Present if there are more records; pass as the "offset" query param to fetch the next page.

json

{
  "records": [
    {
      "id": "string",
      "createdTime": "2025-01-01T00:00:00Z",
      "fields": {}
    }
  ],
  "offset": "string"
}

Need more? See the Airtable guide for connection setup and behaviour shared by every action.

Was this page helpful?