Paginação JSON API REST

[thiago_chiarelo]

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;

@Clever_Anjos 

[Clever_Anjos · Accepted solution]

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

[marksouzacosta]

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