list_records
Retrieve and filter records from an Airtable table using view, formula, sorting, and field selection. Integrates with the Airtable OAuth MCP Server for secure data access.
Instructions
List records from a table with optional filtering
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 | No | Airtable formula for filtering | |
| sort | No | Sort configuration - array of {field: string, direction: 'asc'|'desc'} | |
| 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": {
"anyOf": [
{
"type": "string"
},
{
"type": "null"
}
],
"default": null,
"description": "Airtable formula for filtering",
"title": "Filter By Formula"
},
"sort": {
"anyOf": [
{
"items": {
"additionalProperties": {
"type": "string"
},
"type": "object"
},
"type": "array"
},
{
"type": "null"
}
],
"default": null,
"description": "Sort configuration - array of {field: string, direction: 'asc'|'desc'}",
"title": "Sort"
},
"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"
],
"type": "object"
}