search_records
Search Airtable records by applying a formula filter to retrieve data from specific bases, tables, and views. Use fields parameter to include only relevant data in results.
Instructions
Search records using a formula filter
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| base_id | Yes | The Airtable base ID | |
| fields | No | Specific fields to include (field name or array of field names) | |
| filter_by_formula | Yes | Airtable formula for filtering | |
| table_id | Yes | The table ID or name | |
| view | No | View name or ID |
Input Schema (JSON Schema)
{
"properties": {
"base_id": {
"description": "The Airtable base ID",
"title": "Base Id",
"type": "string"
},
"fields": {
"anyOf": [
{
"type": "string"
},
{
"items": {
"type": "string"
},
"type": "array"
},
{
"type": "null"
}
],
"default": null,
"description": "Specific fields to include (field name or array of field names)",
"title": "Fields"
},
"filter_by_formula": {
"description": "Airtable formula for filtering",
"title": "Filter By Formula",
"type": "string"
},
"table_id": {
"description": "The table ID or name",
"title": "Table Id",
"type": "string"
},
"view": {
"anyOf": [
{
"type": "string"
},
{
"type": "null"
}
],
"default": null,
"description": "View name or ID",
"title": "View"
}
},
"required": [
"base_id",
"table_id",
"filter_by_formula"
],
"type": "object"
}