Skip to main content

Airtable Component

Manage items (records) in an Airtable Base

Component key: airtable

Description#

Airtable is a spreadsheet-database hybrid, with the features of a database but applied to a spreadsheet. This component allows you to list, create, delete, and update records in an Airtable Base.

Information about Airtable can be found on their documentation site.

Authorization Notes#

The Airtable component uses an API key for authentication. You can obtain an API key by following the Airtable Support Guide.

Airtable Connections#

Airtable API Key and Base#

InputKeyNotesExample

API Key

string
/ Required
apiKeyProvide a valid API Key from your Airtable account settings.examplekeyexcbgRihs5Ks03

Airtable Base Id

string
/ Required
baseAn Airtable base contains all of the information you need for a particular project or collection.exampleappb6qsu0jb4GAHtB

Actions#

Create Record#

Create a new record in the given table | key: createRecord

InputKeyNotesExample

Connection

connection
/ Required
airtableConnectionAccess keys provide programmatic access to access resources in AWS. See https://docs.aws.amazon.com/IAM/latest/UserGuide/id_credentials_access-keys.html.

Record Fields

string
/ Required
Key Value List
recordFieldsA record is the base equivalent of a row in a spreadsheet.

Table Name

string
/ Required
tableNameProvide the name of the table you would like to access.myExampleTable

Output Example Payload#

{  "data": [    {      "id": "ExampleRecordId",      "fields": {        "RecordKey": "RecordValue"      },      "createdTime": "2021-08-06T00:00:00.000Z"    }  ]}

Delete Records#

Delete one or many records inside of the given table | key: deleteRecord

InputKeyNotesExample

Connection

connection
/ Required
airtableConnectionAccess keys provide programmatic access to access resources in AWS. See https://docs.aws.amazon.com/IAM/latest/UserGuide/id_credentials_access-keys.html.

Record Ids

string
/ Required
Value List
recordsIn each field, place a key value pair (JavaScript Object) that resembles a table record.

Table Name

string
/ Required
tableNameProvide the name of the table you would like to access.myExampleTable

Output Example Payload#

{  "data": [    0  ]}

Get Record#

Retrieve a record by id from the given table | key: getRecord

InputKeyNotesExample

Connection

connection
/ Required
airtableConnectionAccess keys provide programmatic access to access resources in AWS. See https://docs.aws.amazon.com/IAM/latest/UserGuide/id_credentials_access-keys.html.

Record Id

string
/ Required
recordWithin Airtable, each record has a unique identifier known as a Record ID. If you are familiar with Entity-Relationship Diagrams or ERDs, then the record id would be the primary key.rec6r4kNmGDk5D52F

Table Name

string
/ Required
tableNameProvide the name of the table you would like to access.myExampleTable

Output Example Payload#

{  "data": {    "id": "ExampleRecordId",    "fields": {      "RecordKey": "RecordValue"    },    "createdTime": "2021-08-06T00:00:00.000Z"  }}

List Records#

List all records inside of the given table | key: listRecords

InputKeyNotesExample

Connection

connection
/ Required
airtableConnectionAccess keys provide programmatic access to access resources in AWS. See https://docs.aws.amazon.com/IAM/latest/UserGuide/id_credentials_access-keys.html.

Max Records

data
maxRecordsProvide a number of elements you would like to be returned.6

Table Name

string
/ Required
tableNameProvide the name of the table you would like to access.myExampleTable

Output Example Payload#

{  "data": [    {      "id": "ExampleRecordId",      "fields": {        "RecordKey": "RecordValue"      },      "createdTime": "2021-08-06T00:00:00.000Z"    }  ]}

Update Record#

Update a record's content inside a given table | key: updateRecord

InputKeyNotesExample

Connection

connection
/ Required
airtableConnectionAccess keys provide programmatic access to access resources in AWS. See https://docs.aws.amazon.com/IAM/latest/UserGuide/id_credentials_access-keys.html.

Record Id

string
/ Required
recordWithin Airtable, each record has a unique identifier known as a Record ID. If you are familiar with Entity-Relationship Diagrams or ERDs, then the record id would be the primary key.rec6r4kNmGDk5D52F

Record Fields

string
/ Required
Key Value List
recordFieldsA record is the base equivalent of a row in a spreadsheet.

Table Name

string
/ Required
tableNameProvide the name of the table you would like to access.myExampleTable

Output Example Payload#

{  "data": [    {      "id": "ExampleRecordId",      "fields": {        "RecordKey": "RecordValue"      },      "createdTime": "2021-08-06T00:00:00.000Z"    }  ]}