abstra-docs
Search…
⌃K

Airtable

Airtable is a spreadsheet-database hybrid, with the features of a database but applied to a spreadsheet

Connecting to Airtable

In order to get data from Airtable, you should have the following information in hand
  • Base ID
  • API key

Getting base ID

Visit https://airtable.com/api, then you should see something like this
Airtable's API page
Select the base you want to connect, then copy the id from URL
Selecting the application in the Airtable's API
The base ID in the API URL

Generating an API key

You can generate API keys on your account page.
Generating a new API key

Making queries to your base

You can make queries by adding methods.

List Records

Adding a method for Airtable
After that, you can select the table you want to grab the data
Choosing a table
Now you can use this connector with Tables, Collections or Actions

Filtering

Sometimes, you want to filter which elements of Airtable you will want to use. For this, we have a filtering feature.
We will create another method for listing only completed tasks.
Creating a new task
Then we will add the filter property to this method
Adding a filter property
Now we can use Airtable's formula syntax
Filter by formula
Additionally, you can pass parameters to theses filters.
Passing parameters

Additional properties

Other properties you can define are:
  • Maximum number of records. Specify this to limit the number of records returned
  • List of fields to return: Specify which fields you want to query.
  • List of fields to sort: Specify fields and directions to order your query.
  • Include Record ID: A boolean value to decide if the record id should be included in the result fields

Create One Record

Here you can create one record on a table. There are 3 possible arguments:
  • table: Name of the table where you will be writing data to
  • fields: A JSON template (it supports named params like $params) to insert in the database
  • (optional) include Record Id: A boolean value to decide if the record id should be included in the result fields.

Create Many Records

Here you can create many records on a table. There are 3 possible arguments:
  • table: Name of the table where you will be writing data to
  • fields: A JSON template (it supports named params like $params) to insert in the database
  • (optional) include Record Id: A boolean value to decide if the record id should be included in the result fields

Update Record

Here you can create one record on a table. There are 3 possible arguments:
  • table: Name of the table where you will be updating data
  • fields: A JSON template (it supports named params like $params) to update in the database
  • (optional) include Record Id: A boolean value to decide if the record id should be included in the result fields.
During the use of this method the ID parameter will be prompted. This parameter is required by AirTable to update the specific record. In order to use this the user must have requested (or saved) the ID in a prior action. To get this ID you must toggle on the includeRecordId parameter in the method that retrieves the record data.
Last modified 11mo ago