With connection loop for Rest Connector

Anonymous — Sun, 03 Jun 2018 19:17:37 GMT

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;method=GET;autoDetectResponseType=true;keyGenerationStrategy=0;authSchema=basic;skipServerCertificateValidation=false;useCertificate=No;certificateStoreLocation=CurrentUser;certificateStoreName=My;PaginationType=None;allowResponseHeaders=false;allowHttpsOnly=false;XUserId=******;XPassword=*******;";

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

Re: With connection loop for Rest Connector

marksouzacosta — Sat, 15 Jun 2024 22:13:06 GMT

As an addition to this topic, I'm excited to share my latest tutorial on integrating Asana with Qlik Cloud using REST APIs!

In this step-by-step guide, you'll learn:
- How to use Asana REST APIs with Postman
- Creating REST Data Connections in Qlik Cloud
- Extracting data from Asana and saving as Parquet files
- Enhancing connections with custom parameters and pagination

Check out the full video on YouTube:
Integrate Asana with Qlik Cloud Using REST APIs: A Step-by-Step Guide
https://youtu.be/lFwar30BNkQ?si=UZoM_x9L5amdJSnf

Regards,

Mark Costa

topic Re: With connection loop for Rest Connector in QlikView

With connection loop for Rest Connector

Re: With connection loop for Rest Connector