search_records

search_records

Retrieve filtered records from Airtable using a formula, specifying base, table, and view. Include specific fields for precise data extraction.

Instructions

Search records using a formula filter

Input Schema

Name	Required	Description
`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"
}

Airtable OAuth MCP Server

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from Airtable OAuth MCP Server

Related Tools

MCP directory API