# Search Records

> Perform Search Records through Airtable.

Source: [https://genhealth.ai/docs/workflows/integrations/airtable/airtable_search_records](https://genhealth.ai/docs/workflows/integrations/airtable/airtable_search_records)

Integration: [Airtable](https://genhealth.ai/docs/workflows/integrations/airtable.md)

- Handler: `airtable_search_records`

- Connection type: `airtable`

## Inputs

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

## Outputs

- `found` — Found
- `first_record_id` — First Record Id
- `first_record` — First Record
- `truncated` — Truncated
- `records` — Records
- `record_ids` — Record Ids
- `count` — Count
- `success` — Success
- `error` — Error
- `error_type` — Error Type
- `status_code` — Status 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

```json
{
  "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

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