Airtable
Airtable is a spreadsheet-database hybrid, with the features of a database but applied to a spreadsheet
In order to get data from Airtable, you should have the following information in hand
- Base ID
- API key
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 a new API key
You can make queries by adding methods.
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
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
Filter by formula
Additionally, you can pass parameters to theses filters.
Passing parameters
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
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.
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
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