How to get started with Airtable connector in Qlik Application Automation

[Mihai_David]

This article gives a basic overview of how to use the Airtable connector in Qlik Application Automation.

Content:

• Personal Access Token Generation
• Available Blocks
• Example Use Case

 

Personal Access Token Generation

1. Login to your Airtable account.
2. Click on your profile icon at the top right corner, to see a dropdown appear.
3. Click Developer hub
   
   
   
   
4. In the Developer Hub, click (a) Personal Access Token and then (b) Create New Token.
   
   
   
   
5. Set a name, set scopes, and access.  
   
   We suggest the usage of the following scopes at the least: 
   
   data.records:read
   data.records:write
   
   
   
   
6. Save to receive the token.
   
   
   
   
7. Update the automation connection by specifying this new personal access token as the API key.
   
   
   
   
   

Available Blocks

The available blocks in the Airtable connector are the following:

• List Table Records
• Get Table Record By Id
• Delete Table Record
• Update Table Record
• Create Table Record
• Replace Table Record
• List New And Updated Table Records incrementally
• Create Multiple Table Records
• Get Table Record By Field

 

Example Use Case

Let's go through a basic use case to retrieve all the records from a table:

1. Create a new Automation
2. Search for the Airtable connector using the left menu
   
   
   
   
3. Select the Airtable connector and use the 'Search for blocks' input to search for the 'List Table Records' block. After that, drag and drop the block into the automation and link it to the start block.
   
   
   
   
4. Go to the "Inputs" tab of the block's menu and fill in the required fields.
5. To retrieve the "App Id" visit https://airtable.com/api
   
   
   
   Click on one of your apps (bases). In my case I will click on Demo and the browser will navigate to the following URL: https://airtable.com/appd3BD8PlHWVY9Xp/api/docs#curl/introduction. You can find the "App Id" in this URL (for me it's "appd3BD8PlHWVY9Xp")
   
   
6. Once you've filled in the required fields you can run the automation.