Tools
Airtable
Read, create, and update Airtable
Integrates Airtable into the workflow. Can create, get, list, or update Airtable records. Can be used in trigger mode to trigger a workflow when an update is made to an Airtable table.
Read records from an Airtable table
| Parameter | Type | Required | Description |
|---|
baseId | string | Yes | ID of the Airtable base |
tableId | string | Yes | ID of the table |
maxRecords | number | No | Maximum number of records to return |
filterFormula | string | No | Formula to filter records (e.g., "({Field Name} = 'Value')") |
| Parameter | Type | Description |
|---|
records | json | Array of retrieved Airtable records |
metadata | json | Operation metadata including pagination offset and total records count |
Retrieve a single record from an Airtable table by its ID
| Parameter | Type | Required | Description |
|---|
baseId | string | Yes | ID of the Airtable base |
tableId | string | Yes | ID or name of the table |
recordId | string | Yes | ID of the record to retrieve |
| Parameter | Type | Description |
|---|
record | json | Retrieved Airtable record with id, createdTime, and fields |
metadata | json | Operation metadata including record count |
Write new records to an Airtable table
| Parameter | Type | Required | Description |
|---|
baseId | string | Yes | ID of the Airtable base |
tableId | string | Yes | ID or name of the table |
records | json | Yes | Array of records to create, each with a fields object |
| Parameter | Type | Description |
|---|
records | json | Array of created Airtable records |
metadata | json | Operation metadata |
Update an existing record in an Airtable table by ID
| Parameter | Type | Required | Description |
|---|
baseId | string | Yes | ID of the Airtable base |
tableId | string | Yes | ID or name of the table |
recordId | string | Yes | ID of the record to update |
fields | json | Yes | An object containing the field names and their new values |
| Parameter | Type | Description |
|---|
record | json | Updated Airtable record with id, createdTime, and fields |
metadata | json | Operation metadata including record count and updated field names |
Update multiple existing records in an Airtable table
| Parameter | Type | Required | Description |
|---|
baseId | string | Yes | ID of the Airtable base |
tableId | string | Yes | ID or name of the table |
records | json | Yes | Array of records to update, each with an id and a fields object |
| Parameter | Type | Description |
|---|
records | json | Array of updated Airtable records |
metadata | json | Operation metadata including record count and updated record IDs |
Trigger workflow from Airtable record changes like create, update, and delete events (requires Airtable credentials)
| Parameter | Type | Description |
|---|
payloads | array | The payloads of the Airtable changes |
latestPayload.timestamp | string | The timestamp of the Airtable change |
latestPayload.payloadFormat | object | The format of the Airtable change |
latestPayload.actionMetadata.source | string | The source of the Airtable change |
latestPayload.actionMetadata.sourceMetadata.pageId | string | The ID of the page that triggered the Airtable change |
latestPayload.actionMetadata.changedTablesById | object | The tables that were changed |
latestPayload.actionMetadata.baseTransactionNumber | number | The transaction number of the Airtable change |
airtableChanges | array | Changes made to the Airtable table |
- Category:
tools
- Type:
airtable