Get All Records

The Get All Records action reads records from an Airtable table, follows offset pagination, and returns each record’s fields. A view, formula, and single-field sort can narrow or order the result.

Inputs

Input	Type	Required	Description
Third-party account	Airtable account	Yes	Account with record-read access.
Base ID	String	Yes	Airtable base ID.
Table Name or ID	String	Yes	Table name or ID.
View Name or ID	String	No	Limit records to an Airtable view.
Filter Formula	String	No	Airtable formula that records must satisfy.
Sort Field	String	No	Field used to order results.
Sort Direction	`asc` or `desc`	No	Sort direction. Defaults to `asc`; used with Sort Field.

View and formula filters are combined by Airtable when both are supplied. Test formulas in Airtable before placing them in a workflow.

Outputs

Output	Type	Description
Records	List of objects	Field objects for the returned records.
Count	Number	Number of returned records.

The action requests at most 1,000 records and returns field objects without their Airtable record IDs. Use a dedicated ID field when downstream work must retain an identifier.

Troubleshooting

Sorting has no effect

Sort Direction is sent only when Sort Field is also provided. Check that the field name exists in the table.

Update RecordMerge into or replace one Airtable record.

Overview

Fundamentals

Web, Files & Data

AI

Scraping & Rendering

Google Workspace

Email, CRM & Scheduling

Databases & Tables

Microsoft

Inputs

Outputs

Troubleshooting

​Inputs

​Outputs

​Troubleshooting

Inputs

Outputs

Troubleshooting