topic Paginação JSON API REST in Brasil

Paginação JSON API REST

thiago_chiarelo — Wed, 24 Jun 2020 20:20:27 GMT

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

Re: Paginação JSON API REST

Clever_Anjos — Wed, 24 Jun 2020 22:16:56 GMT

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=$(VariaveldoSeuLoop)" 
);

Re: Paginação JSON API REST

marksouzacosta — Sat, 15 Jun 2024 22:12:47 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