query_records
Read records from an Airtable table view with resolved field values, including lookups. Search across all fields using client-side text matching, even on lookup fields.
Instructions
Read records from an Airtable table view. Returns resolved field values including lookup fields. Supports optional client-side text search across all field values — unlike the REST API filterByFormula approach, this search works correctly on lookup fields. Fetch up to 1000 records per call.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| appId | Yes | The Airtable base/application ID | |
| tableId | Yes | The table ID (e.g. "tblXXX") | |
| viewId | Yes | The view ID (e.g. "viwXXX") — determines row order and visible fields | |
| columnIds | No | Optional: specific field IDs to fetch. Omit to fetch all fields. | |
| limit | No | Maximum number of records to fetch before filtering (1–1000). Default: 100. Increase if search returns too few results. | |
| search | No | Optional case-insensitive substring to match against any field value. Works on lookup fields, formula fields, and multi-select arrays. Applied after fetching — increase limit if you need to search more records. | |
| debug | No | When true, include raw Airtable response in output for diagnostics |