Hello,
Has anybody successfully implemented pagination in QlikSense for Airtables API?
I can successfully load 100 rows of airtable data and now need to setup pagination to load the rest of the records.
I've been in communication with Airtable and the pagination types in the Qlik connector will not seem to work for their api calls and will need to do a custom pagination type to pass an offset value.
"Pagination should be handled completely in the URL parameter (i.e. ?offset=someID).
Your first request might look something like this with your base's app id (appxxxxxxxxxxxxxx) and your table name.
https://api.airtable.com/v0/appxxxxxxxxxxxxxx/TableName
You'll get the first page of records (under the "records" key), but if there is another page, you'll also get an "offset" that would look something like this:
"offset": "itrxxxxxxxxxxxxxx/recxxxxxxxxxxxxxx"
To fetch the next page (in other words, the next 100 records), you'll include that offset as a query parameter.
For example: https://api.airtable.com/v0/appxxxxxxxxxxxxxx/TableName?offset=itrSJ1l4jlPyxEG6c%2Frecxxxxxxxxxxxxxx
"
In theory this will work fine, however QlikSense does not return the offset parameter in any data elements to make the next call. This parameter is not included either when checking the option Include HTTP response header.
Has anybody had success with Airtable's API or a similar pagination structure is QlikSense?
Also, is there any way to add to the response headers that get generated?
Thank you
