Skip to content
For LLMsView as Markdown·

Airtable

Create, read, update, and delete records in Airtable bases.

DetailValue
CategoryProductivity
Base URLhttps://api.airtable.com/v0
AuthenticationBearer Token
Endpoints5
Connector keyairtable

Using Airtable in a workflow

  1. Go to Connections and click New Connection.
  2. Pick Airtable from the marketplace.
  3. Enter your credentials (see Authentication above for what's expected).
  4. In a workflow, drop an API Call node and select this connection.
  5. Pick the operation you need from the Operation dropdown — the full list is below.

Available endpoints

EndpointSummary
GET /{baseId}/{tableIdOrName}List records in a table
POST /{baseId}/{tableIdOrName}Create records
PATCH /{baseId}/{tableIdOrName}Update records
DELETE /{baseId}/{tableIdOrName}Delete records
GET /meta/basesList all bases

Each endpoint is documented in full below. Use the outline on the right to jump to one.

GET /{baseId}/{tableIdOrName}

List records in a table

DetailValue
Operation IDdata.listRecords
MethodGET
Path/{baseId}/{tableIdOrName}

Parameters

NameLocationTypeRequired
baseIdpathstringYes
tableIdOrNamepathstringYes
maxRecordsqueryintegerNo
viewquerystringNo

Using this endpoint in a workflow

  1. Add an API Call node to your workflow.
  2. Pick your Airtable connection from the Connection dropdown.
  3. In the Operation dropdown, select data.listRecords.
  4. Fill in the parameter fields that appear. Use {{...}} to reference upstream values.

Required fields are marked — fill them or the call will fail at runtime.

What it returns

The API Call node writes the response to the workflow context:

{
  status: 200,
  success: true,
  data: { ...response body from the API... },
  latencyMs: 142
}

Reference response fields downstream as {{nodeId.data.path}}. The exact response shape is documented on the upstream Airtable API reference.

POST /{baseId}/{tableIdOrName}

Create records

DetailValue
Operation IDdata.createRecords
MethodPOST
Path/{baseId}/{tableIdOrName}

Parameters

NameLocationTypeRequired
baseIdpathstringYes
tableIdOrNamepathstringYes

Request Body

FieldType
recordsarray

Using this endpoint in a workflow

  1. Add an API Call node to your workflow.
  2. Pick your Airtable connection from the Connection dropdown.
  3. In the Operation dropdown, select data.createRecords.
  4. Fill in the parameter fields that appear. Use {{...}} to reference upstream values.

Required fields are marked — fill them or the call will fail at runtime.

What it returns

The API Call node writes the response to the workflow context:

{
  status: 200,
  success: true,
  data: { ...response body from the API... },
  latencyMs: 142
}

Reference response fields downstream as {{nodeId.data.path}}. The exact response shape is documented on the upstream Airtable API reference.

PATCH /{baseId}/{tableIdOrName}

Update records

DetailValue
Operation IDdata.updateRecords
MethodPATCH
Path/{baseId}/{tableIdOrName}

Parameters

NameLocationTypeRequired
baseIdpathstringYes
tableIdOrNamepathstringYes

Request Body

FieldType
recordsarray

Using this endpoint in a workflow

  1. Add an API Call node to your workflow.
  2. Pick your Airtable connection from the Connection dropdown.
  3. In the Operation dropdown, select data.updateRecords.
  4. Fill in the parameter fields that appear. Use {{...}} to reference upstream values.

Required fields are marked — fill them or the call will fail at runtime.

What it returns

The API Call node writes the response to the workflow context:

{
  status: 200,
  success: true,
  data: { ...response body from the API... },
  latencyMs: 142
}

Reference response fields downstream as {{nodeId.data.path}}. The exact response shape is documented on the upstream Airtable API reference.

DELETE /{baseId}/{tableIdOrName}

Delete records

DetailValue
Operation IDdata.deleteRecords
MethodDELETE
Path/{baseId}/{tableIdOrName}

Parameters

NameLocationTypeRequired
baseIdpathstringYes
tableIdOrNamepathstringYes
records[]querystringYes

Using this endpoint in a workflow

  1. Add an API Call node to your workflow.
  2. Pick your Airtable connection from the Connection dropdown.
  3. In the Operation dropdown, select data.deleteRecords.
  4. Fill in the parameter fields that appear. Use {{...}} to reference upstream values.

Required fields are marked — fill them or the call will fail at runtime.

What it returns

The API Call node writes the response to the workflow context:

{
  status: 200,
  success: true,
  data: { ...response body from the API... },
  latencyMs: 142
}

Reference response fields downstream as {{nodeId.data.path}}. The exact response shape is documented on the upstream Airtable API reference.

GET /meta/bases

List all bases

DetailValue
Operation IDdata.listBases
MethodGET
Path/meta/bases

Parameters

No parameters.

Using this endpoint in a workflow

  1. Add an API Call node to your workflow.
  2. Pick your Airtable connection from the Connection dropdown.
  3. In the Operation dropdown, select data.listBases.
  4. Fill in the parameter fields that appear. Use {{...}} to reference upstream values.

What it returns

The API Call node writes the response to the workflow context:

{
  status: 200,
  success: true,
  data: { ...response body from the API... },
  latencyMs: 142
}

Reference response fields downstream as {{nodeId.data.path}}. The exact response shape is documented on the upstream Airtable API reference.