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

Select the base you want to connect, then copy the id from URL

Generating an API key

You can generate API keys on your account page.

Making queries to your base

You can make queries by adding methods.

After that, you can select the table you want to grab the data

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.

Then we will add the filter property to this method

Now we can use Airtable's formula syntax​

Additionally, you can pass parameters to theses filters.

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.