Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
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.