REST Connector error using WITH CONNECTION and Pagination

[jptneumann]

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?

[petter · Accepted solution]

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.

[Anonymous]

Hi Jean ,

Please follow the link to guide you in detail.

https://help.qlik.com/en-US/connectors/Subsystems/REST_connector_help/Content/1.0/Create-REST-connec...

[alis2063]

Can we add table  fields in "with connection" body so in Email body it should be reflect as below



ID Amount

23,10000



with connection (
QUERY "to" "v@gmail.com "
,QUERY "message" "Total Sales greater than >20000 for $(vID)"
//,QUERY "subject" "$(vID)"
,QUERY "fromName" "NoReply"
,QUERY "fromEmail" "v@hotmail.com"




)