Airtable integration

Search Records

Perform Search Records through Airtable.

View as Markdown

airtable_search_records

readairtable

Inputs

base_id
expressionrequired
Base Id
Required literal value or workflow expression.
table
expressionrequired
Table
Required literal value or workflow expression.
match_fields
json
Match Fields
Optional JSON value.
filter_formula
textarea
Filter Formula
Optional text value.
view
text
View
Optional text value.
sort_field
text
Sort Field
Optional text value.
sort_direction
select
Sort Direction
Optional selected identifier or value.
Default: "asc"
Options: Ascending ("asc"), Descending ("desc")
return_fields
text
Return Fields
Optional text value.
max_records
number
Max Records
Optional numeric value.
Default: 100

Outputs

foundFound
first_record_idFirst Record Id
first_recordFirst Record
truncatedTruncated
recordsRecords
record_idsRecord Ids
countCount
successSuccess
errorError
error_typeError Type
status_codeStatus Code

Output schema completeness: best_effort_declared

Safety

External effect: read
Confirmation recommended: No
Retry safe: Yes
Dry run supported: No

Schemas

These schemas are first-pass authoring guidance. Runtime validation remains authoritative.

Input schema

{
  "type": "object",
  "required": [
    "base_id",
    "table"
  ],
  "properties": {
    "view": {
      "type": "string",
      "description": "Optional text value.",
      "x-workflow-field-type": "text"
    },
    "table": {
      "description": "Required literal value or workflow expression.",
      "x-workflow-field-type": "expression"
    },
    "base_id": {
      "description": "Required literal value or workflow expression.",
      "x-workflow-field-type": "expression"
    },
    "sort_field": {
      "type": "string",
      "description": "Optional text value.",
      "x-workflow-field-type": "text"
    },
    "max_records": {
      "type": "number",
      "default": 100,
      "description": "Optional numeric value.",
      "x-workflow-field-type": "number"
    },
    "match_fields": {
      "description": "Optional JSON value.",
      "x-workflow-field-type": "json"
    },
    "return_fields": {
      "type": "string",
      "description": "Optional text value.",
      "x-workflow-field-type": "text"
    },
    "filter_formula": {
      "type": "string",
      "description": "Optional text value.",
      "x-workflow-field-type": "textarea"
    },
    "sort_direction": {
      "enum": [
        "asc",
        "desc"
      ],
      "type": "string",
      "default": "asc",
      "description": "Optional selected identifier or value.",
      "x-workflow-field-type": "select"
    }
  },
  "additionalProperties": false
}

Output schema

{
  "type": "object",
  "properties": {
    "count": {},
    "error": {},
    "found": {},
    "records": {},
    "success": {},
    "truncated": {},
    "error_type": {},
    "record_ids": {},
    "status_code": {},
    "first_record": {},
    "first_record_id": {}
  },
  "additionalProperties": true
}

View all Airtable actions