Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

How to get started with Airtable connector in Qlik Application Automation

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Mihai_David
Support
Support

How to get started with Airtable connector in Qlik Application Automation

Last Update:

Jan 9, 2024 4:58:43 AM

Updated By:

Sonja_Bauernfeind

Created date:

Sep 9, 2021 5:56:05 AM

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

Content:

 

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

    airtable dev hub.png

  4. In the Developer Hub, click (a) Personal Access Token and then (b) Create New Token.

    personal access token.png

  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

    set scope name and access.png

  6. Save to receive the token.

    token created.png

  7. Update the automation connection by specifying this new personal access token as the API key.

    use the personal key as an API key.png

    connection is linked.png

 

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

    airtable connection.png

  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.

    list table records.png

  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

    air table rest api.png

    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.
Tags (1)
Labels (2)
Version history
Last update:
‎2024-01-09 04:58 AM
Updated by: