query_records
Retrieve records from an Airtable table view, returning resolved lookup values. Use optional text search that works on any field, including lookups.
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 |