Airtable

Search…

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.