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";
