Skip to content

Airtable

Node: airtable · Full type: n8n-nodes-base.airtable · Version: 2.2

Credentials

airtableTokenApi (alias: @airtable) / airtableOAuth2Api (alias: @airtable)

CREDENTIAL @airtable = airtableTokenApi "My Airtable"

Operations

Resource: base

getMany

Parameter Type Default Details
returnAll boolean true
limit number 100
options collection {} keys: permissionLevel

getSchema

Parameter Type Default Details
base resourceLocator {...} required; modes: list, url, id

Resource: record

create

Parameter Type Default Details
columns resourceMapper {...} required
options collection {} keys: typecast, ignoreFields, updateAllMatches

upsert

Parameter Type Default Details
columns resourceMapper {...} required
options collection {} keys: typecast, ignoreFields, updateAllMatches

deleteRecord

Parameter Type Default Details
id string "" required

get

Parameter Type Default Details
id string "" required
options collection {} keys: downloadFields
Parameter Type Default Details
filterByFormula string ""
returnAll boolean true
limit number 100
options collection {} keys: downloadFields, fields, view
sort fixedCollection {} groups: property

update

Parameter Type Default Details
columns resourceMapper {...} required
options collection {} keys: typecast, ignoreFields, updateAllMatches

Common Parameters

Parameter Type Default Details
authentication options "airtableTokenApi" airtableTokenApi, airtableOAuth2Api
base resourceLocator {...} required; modes: list, url, id
table resourceLocator {...} required; modes: list, url, id

Parameter Details

options children:

Parameter Type Default Details
typecast boolean false
ignoreFields string ""
updateAllMatches boolean false

sort children:

property group:

Parameter Type Default Details
field options ""
direction options "asc" asc, desc

Example

NODE "airtable" @airtable AS "Airtable" {
  resource: "base",
  operation: "get",
  id: {{ $json.id }}
}