Airtable Records

Airtable Records

Certified

Tasks that read and write Airtable records: list rows with filters, views, and pagination, fetch a record by ID, create single or batched records with optional typecasting, patch updates, and deletes.

Use API key authentication and choose fetch/store outputs depending on whether you want data in-flow or stored.

How to use the Airtable plugin

Read and write records in Airtable from Kestra flows.

Authentication

Set apiKey to your Airtable personal access token. Store it in a secret and apply it globally with plugin defaults.

Tasks

All tasks require baseId and tableId to identify the target table.

records.List returns records from a table — filter with filterByFormula, scope columns with fields, cap results with maxRecords, or target a specific view. Set enableAutoPagination: true to fetch all pages automatically. Control result handling with fetchType (default FETCH).

records.Create creates one or more records — pass a single record via fields (a map of column name to value) or a batch via records (a list of field maps). Set typecast: true to let Airtable coerce string values to the appropriate field type.

records.Get retrieves a single record by recordId. Scope returned columns with fields. Set failOnMissing: true to error if any requested fields are absent from the record.

records.Update updates a record by recordId — pass new values via fields.

records.Delete removes a record by recordId.

Create automations with Airtable Records Plugin