topic Re: REST Connector error using WITH CONNECTION and Pagination in Integration, Extension & APIs

REST Connector error using WITH CONNECTION and Pagination

jptneumann — Sun, 21 Jan 2018 21:53:58 GMT

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?

Re: REST Connector error using WITH CONNECTION and Pagination

petter — Tue, 23 Jan 2018 01:27:07 GMT

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.

Re: REST Connector error using WITH CONNECTION and Pagination

Anonymous — Tue, 23 Jan 2018 09:36:51 GMT

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-connection/Loading-paged-d…

Re: REST Connector error using WITH CONNECTION and Pagination

alis2063 — Thu, 18 Jul 2019 14:59:47 GMT

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"

)