Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Olá,
Estou com dificuldades em integrar uma API e realizar a paginação:
Exemplo API: https://api.movidesk.com/public/v1/tickets?token=XXXXXXXXXX&$select=id&$top=200&$skip=0
&$skip = (Sempre será alterado, conforme a leitura[0 - 200 - 400 - 800 ... ])
LIB CONNECT TO 'REST';
RestConnectorMasterTable:
SQL SELECT
"id"
FROM JSON (wrap on) "root";
[root]:
LOAD [id]
RESIDENT RestConnectorMasterTable;
DROP TABLE RestConnectorMasterTable;
Voce precisa usar o With Connection() para trocar a URL da sua API dentro de um "loop" (for/while)
RestConnectorMasterTable:
SQL SELECT
"id"
FROM JSON (wrap on) "root"
WITH CONNECTION (
URL "https://api.movidesk.com/public/v1/tickets?token=XXXXXXXXXX&$select=id&$top=200&$skip=$(VariaveldoSe..."
);
Voce precisa usar o With Connection() para trocar a URL da sua API dentro de um "loop" (for/while)
RestConnectorMasterTable:
SQL SELECT
"id"
FROM JSON (wrap on) "root"
WITH CONNECTION (
URL "https://api.movidesk.com/public/v1/tickets?token=XXXXXXXXXX&$select=id&$top=200&$skip=$(VariaveldoSe..."
);
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