Airtable

Airtable is a popular cloud-based relational database and spreadsheet platform that combines the simplicity of a spreadsheet with the complexity of a traditional database. It allows users to create and organize structured data in a user-friendly interface, making it useful for various tasks such as project management, content planning, and data collection.

Set up your Back end on Airtable

Create an account on Airtable and create your base according to your need.

In order to connect your base to ILLA Cloud, navigate to the developer hub.

In Personal Access Token page, click Create new Token.

This will open configuration options for the PAT that you are creating.

First name the PAT, then choose the scopes you'd like this PAT to have access to. Finally, choose what level of access this PAT will have.

Click the create token button, we now have a PAT ready to connect.

Create Airtable in ILLA Cloud

There are two ways to create a resource in Illa after signing into your Illa account.

• Create in Resources

Sign in to your Illa account, select **Resources** at the top of the page, and click **Create New** button.

Select Airtable from the database list.

Connect to the database with the required parameters described in Connection Settings below. In this case, fill in the Personal Access Token we copied from Airtable and paste it into Access Token in the configuration.

Click Save Resources to ****create a resource.

The ready Airtable will display as shown.

• Create in Builder

Sign in to your Illa account, create a project in Illa Builder on the **App** page, and navigate to the Action List at the bottom of the page. Click **new**, then select Airtable from the database list. Then, connect to the database with the required parameters described in Connection Settings below.

Click **Test Connection** to see if we can successfully connect to the database. If yes, click Save Resources, else, double check the hostname, port, username, and password is correct.

Connection Settings

Here we need to provide information for connecting to the Airtable API.

Properties	Required	Description
Name	required	The name for resource when creating actions in the ILLA.
Access token	required	a piece of information that grants a third-party application or service permission to access your Airtable account's data and perform actions on your behalf

Create Actions

We have created an Airtable resource, we can add the action by selecting Airtable from the action list and choosing the Create action button.

Now we have added the Airtable API as an action to our building page.

Configure Airtable

Properties	Description
Base ID	a unique identifier for your Airtable database. You can get the base ID from your base URL. It is usually a string starting with "app".
Table name	specifies the specific table within the chosen base that you want to interact with
Action Type	what type of operation your integration will perform on the specified table
Transformer	transforming data into the style you like using JavaScript

List Records

retrieves a list of records from a specified table in Airtable

Input

Properties	Required	Description
View	optional	organize and display records based on specific criteria
Fields	optional	Fields refer to the columns within your Airtable table
Filter by formula	optional	define a formula that filters the records you want to retrieve or interact with
Sort	optional	the order in which records are presented or retrieved
Max records	optional	limits the number of records your integration fetches or interacts with in a single request
Page size	optional	often used in scenarios where data needs to be retrieved in multiple batches (pages)
Offset	optional	specifies the starting point for retrieving records in a specific page
Cell format	optional	how data is displayed within a specific field
Time zone	optional	ensures that date and time calculations and presentations are accurate and consistent
User location	optional	tailor the integration output based on the user's geographical location or preferences

Get Record

fetches a specific record from a table by providing the unique record ID

Input

Properties	Required	Description
Record ID	required	a unique identifier assigned to each individual record

Create Records

add new records to a table in Airtable

Input

Properties	Required	Description
Records	required	a part of the API payload that you provide when you want to add new records to a specific table

Update Record

modify the values of fields within a single record

Input

Properties	Required	Description
Record ID	required	a unique identifier assigned to each individual record
Records	required	a part of the API payload that you provide when you want to add new records to a specific table

Update Multiple Records

modify fields in multiple records at once

Input

Properties	Required	Description
Records	required	a part of the API payload that you provide when you want to add new records to a specific table

Delete Record

delete a specific record from a table by providing its record ID

Input

Properties	Required	Description
Record ID	required	a unique identifier assigned to each individual record

Delete Multiple Records

delete a specific record from a table by providing its record ID

Input