Airtable REST API connection to QlikSense

[Bhanuka_Kirinde]

Goal: To connect the database on Airtable to QlikSense via the REST API and retrieve more that 100 records using pagination.

Problem: Unable to retrieve more than 100 records at a time using the REST API Airtbale provides.

We use Airtable to manage our databases and there is a need to visualize our data through Qlik. Airtable provides a REST API and Qlik provides a data source connector. Even though we are able to connect to the database via the REST API the main issue arises when we have to retrieve all records in the database. This has to do with the Airtable pagination.

Airtable only allows 100 records to be retrieved and if more needs to be retrieved pagination needs to be used. Airtable provides a pagination type of offset however doesn’t provide additional details.

The two ways we’ve been trying to approach this issue is through the.

1. List item

The Qlik data engine

2. Using the Qlik connection tool

The issue that’s been run in to constantly with this approach is that it says the ‘total fields path isn’t mentioned’

The connection works however the following error is displayed

[Bill_French]

Bhanuka_Kirinde:

Unable to retrieve more than 100 records at a time using the REST API Airtbale provides.

This is not the problem. The pagination works well and I’m guessing since I started reading your post, at least seven such API calls of mine extracted more than 20,000 rows from Airtable through the REST API.

Bhanuka_Kirinde:

Airtable provides a pagination type of offset however doesn’t provide additional details.

Your issue is with the Qlik configuration of the connection tool to establish a working integration. The API docs are all you need, and if still stuck, this might help …

Receive more than 100 records API

I have written a little vue.js app. I need it to access more than 100 records in my table though. How do I do that? Here is my code.var app = new Vue({ el: ‘#app’, data: { items: [] }, mounted: function(){ this.loadItems(); }, methods: { loadItems: function(){ // Init variables var self = this var app_id = "XXXXXXXXXXXXXXXX"; var app_key = "XXXXXXXXXXXXXXX"; this.items = [] axios.get( …