List Records
list_recordsRetrieve records from an Airtable table using filters, sorting, and field selection to extract the data you need.
Instructions
List records from a table
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sort | No | A list of sort objects that specifies how the records will be ordered | |
| view | No | The name or ID of a view in the table | |
| baseId | Yes | The ID of the base | |
| fields | No | An array of field names or IDs to include in the response. Omit this to return all fields, which is usually what you want. Only set it if the table has many fields and you don't need most of them, AND you already know the exact field names or IDs (e.g. from describe_table) - guessing them will silently return the wrong data. | |
| tableId | Yes | The ID or name of the table | |
| maxRecords | No | The maximum total number of records that will be returned | |
| filterByFormula | No | A formula used to filter records |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| records | Yes |