> ## Documentation Index
> Fetch the complete documentation index at: https://learn.workflow.dog/llms.txt
> Use this file to discover all available pages before exploring further.

# Get All Records

> List Airtable records with optional view, formula, and sorting.

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.             |

<Note>
  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.
</Note>

## Troubleshooting

<AccordionGroup>
  <Accordion title="Sorting has no effect">
    **Sort Direction** is sent only when **Sort Field** is also provided. Check
    that the field name exists in the table.
  </Accordion>
</AccordionGroup>