Qlik Community

Qlik Sense Integration, Extensions, & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

jptneumann
New Contributor II

REST Connector error using WITH CONNECTION and Pagination

I'm trying to access an API, using REST Connector, including 'WITH CONNECTION (URL "https: // ...")' after SELECT. I need to do pagination. This way I configure the 'pagination type = NextUrl'. Also use the 'Next Url Field Path' parameter.


****************

LIB CONNECT TO 'MyConnection';


RestConnectorMasterTable:

SQL SELECT

"__KEY_root",

(SELECT

"field1",

"field2",

"__FK_data"

FROM "data" FK "__FK_data")

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

WITH CONNECTION(URL "https://....");

***************


When I run Script, I get the following message:


"Connector reply error: You cannot use the selected pagination type and the 'WITH CONNECTION' statement at the same time. Please set 'Pagination type' to None on the connection dialog."


How do I use pagination using WITH CONNECTION?

1 Solution

Accepted Solutions
MVP
MVP

Re: REST Connector error using WITH CONNECTION and Pagination

If you use WITH CONNECTION you will have to do the pagination yourself. Pagination Type is so that the connector do the pagination for you automatically.

Manual pagination means that you will have to loop and change whatever parameters you need to get the pagination to work with the help of modifying something within the WITH CONNECTION part.

2 Replies
MVP
MVP

Re: REST Connector error using WITH CONNECTION and Pagination

If you use WITH CONNECTION you will have to do the pagination yourself. Pagination Type is so that the connector do the pagination for you automatically.

Manual pagination means that you will have to loop and change whatever parameters you need to get the pagination to work with the help of modifying something within the WITH CONNECTION part.

sandeep_roy
Contributor

Re: REST Connector error using WITH CONNECTION and Pagination