Airtable integration

Airtable is a relational database that is accessible to many users due to its similarities to spreadsheets.

Setup

When adding an Airtable integration, you’ll need to grant Plasmic access to your Airtable base.

Data queries

OperationDescriptionResult in $steps
Fetch row by IDFetches a row from a table given its ID.SingleRowResult
Fetch rows by IDsFetches rows from a table given their IDs..ManyRowsResult
Query for rowsQueries rows from a table. Results can be filtered, sorted, and paginated.ManyRowsResult

Backend operations

OperationDescriptionResult in $steps
Create rowCreates a row on a table.SingleRowResult
Create rowsCreates rows on a table.ManyRowsResult
Update rowUpdates a row on a table given its ID.SingleRowResult
Delete rowDeletes a row on a table given its ID.SingleRowResult
Delete rowsDeletes rows on a table given their IDs.ManyRowsResult

Result types

SingleRowResult

Copy
{
"data": { "ID": 1, "Name": "User 1" },
"schema": {
"id": "Users",
"fields": [
{ "id": "ID", "type": "number", "readOnly": false },
{ "id": "Name", "type": "string", "readOnly": false }
]
}
}

For users familiar with TypeScript, you can view the most up-to-date schema here.

ManyRowsResult

Copy
{
"data": [
{ "ID": 1, "Name": "User 1" },
{ "ID": 2, "Name": "User 2" }
],
"schema": {
"id": "Users",
"fields": [
{ "id": "ID", "type": "number", "readOnly": false },
{ "id": "Name", "type": "string", "readOnly": false }
]
},
"paginate": {
"pageSize": 20,
"pageIndex": 0
}
}

The paginate field is only set if the data query was paginated.

For users familiar with TypeScript, you can view the most up-to-date schema here.

Was this page helpful?

Have feedback on this page? Let us know on our forum.