Paging with Qlik Rest Connector

climberdavid — Sat, 05 Dec 2015 23:36:40 GMT

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.

Re: Paging with Qlik Rest Connector

reddy-s — Tue, 22 Dec 2015 17:23:32 GMT

Hi David,

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

Re: Paging with Qlik Rest Connector

climberdavid — Tue, 22 Dec 2015 18:39:20 GMT

Thanks for the tip.

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

Sent from my iPhone

Re: Paging with Qlik Rest Connector

reddy-s — Tue, 22 Dec 2015 23:05:38 GMT

Hi David,

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

topic Re: Paging with Qlik Rest Connector in Connectivity & Data Prep

Paging with Qlik Rest Connector

Re: Paging with Qlik Rest Connector

Re: Paging with Qlik Rest Connector

Re: Paging with Qlik Rest Connector