Query records
query_recordsFind records in a table. Use filter (structured, fast) and/or formula (an Airtable formula such as AND({Status} = "Done", {Hours} > 5), slower). With view, the view's own filters and sorts apply and filter narrows them. Returns total and nextOffset for paging.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sort | No | ||
| view | No | View name or id | |
| limit | No | Default 50 | |
| table | Yes | Table name or id | |
| baseId | Yes | ||
| fields | No | Only return these fields (names or ids) | |
| filter | No | Structured filter, evaluated as SQL in the database (fast) | |
| offset | No | ||
| formula | No |