Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
gumstero
Contributor
Contributor

With connection loop for Rest Connector

Hi,

I've been trying to get this to work and searched and tried all solutions I've found in the forums.

I need to loop trough records for this connection:

CUSTOM CONNECT TO "Provider=QvRestConnector.exe;url=https://integration.upsales.com/api/v2/agreements?&token%2****&offset%2$(i)&limit%21000;timeout=30;m...";

The instruction I got was this to loop through the offset:

https://integration.upsales.com/api/v2/agreements?token={{token}}&offset=0&limit=1000

https://integration.upsales.com/api/v2/agreements?token={{token}}&offset=1000&limit=1000

I've tried the With Connection parameters but get errors all the time.

RestConnectorMasterTable:

SQL SELECT

"__KEY_root",

(SELECT

"__FK_data",

"__KEY_data",

(SELECT

"__FK_metadata_u0",

"__KEY_metadata",

(SELECT

"value" AS "value_u1",

"fieldId" AS "fieldId_u1",

"valueBoolean" AS "valueBoolean_u0",

"valueInteger" AS "valueInteger_u0",

"valueDouble" AS "valueDouble_u0",

"__FK_custom_u1"

FROM "custom" FK "__FK_custom_u1")

FROM "metadata" PK "__KEY_metadata" FK "__FK_metadata_u0")

FROM "data" PK "__KEY_data" FK "__FK_data")

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

0 Replies