Airtable
Read, create, and update Airtable
Integrates Airtable into the workflow. Can list bases, list tables (with schema), and create, get, list, or update records. Can also be used in trigger mode to trigger a workflow when an update is made to an Airtable table.
| Parameter | Type | Required | Description |
|---|
offset | string | No | No description |
| Parameter | Type | Description |
|---|
bases | array | Array of Airtable bases with id, name, and permissionLevel |
↳ id | string | Base ID (starts with "app") |
↳ name | string | Base name |
↳ permissionLevel | string | Permission level (none, read, comment, edit, create) |
metadata | json | Pagination and count metadata |
↳ offset | string | Offset for next page of results |
↳ totalBases | number | Number of bases returned |
| Parameter | Type | Required | Description |
|---|
baseId | string | Yes | Airtable base ID (starts with "app", e.g., "appXXXXXXXXXXXXXX") |
| Parameter | Type | Description |
|---|
tables | array | List of tables in the base with their schema |
↳ id | string | Table ID (starts with "tbl") |
↳ name | string | Table name |
↳ description | string | Table description |
↳ primaryFieldId | string | ID of the primary field |
↳ fields | array | List of fields in the table |
↳ id | string | Field ID (starts with "fld") |
↳ name | string | Field name |
↳ type | string | Field type (singleLineText, multilineText, number, checkbox, singleSelect, multipleSelects, date, dateTime, attachment, linkedRecord, etc.) |
↳ description | string | Field description |
↳ options | json | Field-specific options (choices, etc.) |
metadata | json | Base info and count metadata |
↳ baseId | string | The base ID queried |
↳ totalTables | number | Number of tables in the base |
| Parameter | Type | Required | Description |
|---|
baseId | string | Yes | Airtable base ID (starts with "app", e.g., "appXXXXXXXXXXXXXX") |
tableId | string | Yes | Table ID (starts with "tbl") or table name |
maxRecords | number | No | No description |
filterFormula | string | No | Formula to filter records (e.g., "({Field Name} = 'Value')") |
| Parameter | Type | Description |
|---|
records | array | Array of retrieved Airtable records |
↳ id | string | Record ID |
↳ createdTime | string | Record creation timestamp |
↳ fields | json | Record field values |
metadata | json | Operation metadata including pagination offset and total records count |
↳ offset | string | Pagination offset for next page |
↳ totalRecords | number | Number of records returned |
| Parameter | Type | Required | Description |
|---|
baseId | string | Yes | Airtable base ID (starts with "app", e.g., "appXXXXXXXXXXXXXX") |
tableId | string | Yes | Table ID (starts with "tbl") or table name |
recordId | string | Yes | Record ID to retrieve (starts with "rec", e.g., "recXXXXXXXXXXXXXX") |
| Parameter | Type | Description |
|---|
record | json | Retrieved Airtable record |
↳ id | string | Record ID |
↳ createdTime | string | Record creation timestamp |
↳ fields | json | Record field values |
metadata | json | Operation metadata |
↳ recordCount | number | Number of records returned (always 1) |
| Parameter | Type | Required | Description |
|---|
baseId | string | Yes | Airtable base ID (starts with "app", e.g., "appXXXXXXXXXXXXXX") |
tableId | string | Yes | Table ID (starts with "tbl") or table name |
records | json | Yes | No description |
fields | string | No | No description |
| Parameter | Type | Description |
|---|
records | array | Array of created Airtable records |
↳ id | string | Record ID |
↳ createdTime | string | Record creation timestamp |
↳ fields | json | Record field values |
metadata | json | Operation metadata |
↳ recordCount | number | Number of records created |
| Parameter | Type | Required | Description |
|---|
baseId | string | Yes | Airtable base ID (starts with "app", e.g., "appXXXXXXXXXXXXXX") |
tableId | string | Yes | Table ID (starts with "tbl") or table name |
recordId | string | Yes | Record ID to update (starts with "rec", e.g., "recXXXXXXXXXXXXXX") |
fields | json | Yes | No description |
| Parameter | Type | Description |
|---|
record | json | Updated Airtable record |
↳ id | string | Record ID |
↳ createdTime | string | Record creation timestamp |
↳ fields | json | Record field values |
metadata | json | Operation metadata |
↳ recordCount | number | Number of records updated (always 1) |
↳ updatedFields | array | List of field names that were updated |
| Parameter | Type | Required | Description |
|---|
baseId | string | Yes | Airtable base ID (starts with "app", e.g., "appXXXXXXXXXXXXXX") |
tableId | string | Yes | Table ID (starts with "tbl") or table name |
records | json | Yes | No description |
| Parameter | Type | Description |
|---|
records | array | Array of updated Airtable records |
↳ id | string | Record ID |
↳ createdTime | string | Record creation timestamp |
↳ fields | json | Record field values |
metadata | json | Operation metadata |
↳ recordCount | number | Number of records updated |
↳ updatedRecordIds | array | List of updated record IDs |
| Parameter | Type | Required | Description |
|---|
baseId | string | Yes | Airtable base ID (starts with "app", e.g., "appXXXXXXXXXXXXXX") |
| Parameter | Type | Description |
|---|
tables | json | Array of table schemas with fields and views |
metadata | json | Operation metadata including total tables count |
