Airtable

Work with Airtable bases, tables, and records.

Create record

Create a new record in an Airtable table.

Parameters

Parameter	Type	Required	Description
`base_id`	string	Yes	The Airtable base to use.
`table_name`	string	Yes	The table to use.
`fields`	object	Yes	The value to set for each field in the table.

Response

{
  "createdTime": "2024-01-15T10:30:00Z",
  "fields": {
    "Email": "john@example.com",
    "Name": "John Smith",
    "Status": "Active"
  },
  "id": "rec9K3L2mN4P5Q6R"
}

Delete record

Delete a record from an Airtable table.

Parameters

Parameter	Type	Required	Description
`base_id`	string	Yes	The Airtable base to use.
`table_name`	string	Yes	The table to use.
`record_id`	string	Yes	The record to use.

Response

{
  "deleted": true
}

Get record

Retrieve a single record by ID.

Parameters

Parameter	Type	Required	Description
`base_id`	string	Yes	The Airtable base to use.
`table_name`	string	Yes	The table to use.
`record_id`	string	Yes	The record to use.

Response

{
  "createdTime": "2024-01-15T10:30:00Z",
  "fields": {
    "Email": "john@example.com",
    "Name": "John Smith",
    "Status": "Active"
  },
  "id": "rec9K3L2mN4P5Q6R"
}

List bases

Retrieve all accessible Airtable bases.

Response

{
  "bases": [
    {
      "id": "appaBc123DeFg456",
      "name": "Marketing Campaigns",
      "permissionLevel": "create"
    }
  ]
}

List records

Retrieve records from an Airtable table.

Parameters

Parameter	Type	Required	Description
`base_id`	string	Yes	The Airtable base to use.
`table_name`	string	Yes	The table to use.
`max_records`	number	No	Maximum number of records to return.
`filter_formula`	string	No	An Airtable filter formula that limits which records are returned, for example {Status} = 'Active'.

Response

{
  "records": [
    {
      "createdTime": "2024-01-15T10:30:00Z",
      "fields": {
        "Email": "john@example.com",
        "Name": "John Smith",
        "Status": "Active"
      },
      "id": "rec9K3L2mN4P5Q6R"
    }
  ]
}

List tables in a base

Fetch all tables for a specific Airtable base.

Parameters

Parameter	Type	Required	Description
`base_id`	string	Yes	The Airtable base to use.

Response

{
  "tables": [
    {
      "id": "tblXyz789AbC123",
      "name": "Contacts",
      "primaryFieldId": "fldPqR456StU789"
    }
  ]
}

Update record

Update fields on an existing Airtable record.

Parameters

Parameter	Type	Required	Description
`base_id`	string	Yes	The Airtable base to use.
`table_name`	string	Yes	The table to use.
`record_id`	string	Yes	The record to use.
`fields`	object	Yes	The value to set for each field in the table.

Response

{
  "createdTime": "2024-01-15T10:30:00Z",
  "fields": {
    "Email": "john@example.com",
    "Name": "John Smith",
    "Status": "Inactive"
  },
  "id": "rec9K3L2mN4P5Q6R"
}

Airtable

On this page