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