Skip to main content
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
climberdavid
Partner - Contributor II
Partner - Contributor II

Paging with Qlik Rest Connector

Hi,

I´m trying out the new REST connector from Qlik.

The connector works great, but I´m currently struggling with getting paging working correctly.

I´m using "NextURL" to get the next "Sheet" and i works great until i hit the last page.

The API is returning "N/A" if there is no more pages to fetch and my load script will then try to fetch something like https://api..../N/A.

This will result in a failing load since that webpage don´t exist.

Is there anyone else who had a similar issue and managed to solve it?

It would be nice to simple create an if statement but I´m not sure how that would look.

I reduced the amount of fields to make the script to make it easy to understand. (I tried both in Sense av QlikView, but it´s the same connector so the issue is the same.

LIB CONNECT TO 'TestRestAPI'

RestConnectorMasterTable:

SQL SELECT

  "PrevPageURI",

  "NextPageURI",

  "__KEY_root"

FROM JSON (wrap on) "root" PK "__KEY_root";

I also tried with both XML and JSON but the problem is the same.

Thank you.

3 Replies
reddy-s
Master II
Master II

Hi David,

Try using Set ErrorMode = 0; to avoid throwing an error

climberdavid
Partner - Contributor II
Partner - Contributor II
Author

Thanks for the tip.

Should this be done in some config file for the connector or in the load script?

Sent from my iPhone

reddy-s
Master II
Master II

Hi David,

Add it in the load script along with the other environment variables.