topic REST API Pagination in QlikView

REST API Pagination

prees959 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have been given accesss to an API - the problem is that it only brings back 30 records at a time. Is there a simple way to loop or paginate through all the records?

Thanks,

Phil

Re: REST API Pagination

kaushiknsolanki — Thu, 24 Aug 2017 06:34:01 GMT

Dear Phil,

Rest API has an option of pagination. So as per your web service you can define a pagination.

Link below has sample code.

Using pagination with selected REST sources ‒ Qlik Connectors

Regards,

Kaushik Solanki

Re: REST API Pagination

prees959 — Mon, 04 Sep 2017 11:28:24 GMT

Hi Kaushik,

Thanks for the link to the documentation. I have been told by the developers of the service to :

....

yes there is pagination and it defaults to 100 per page.
You can use "limit" and "offset" query params to override it.
"limit" is the number or records per page. "offset" is the page that you're on.

But I am still unsure of the best way to set up the REST connector. If you can advise in any way I would be very grateful,

Phil

Re: REST API Pagination

kaushiknsolanki — Mon, 04 Sep 2017 16:58:44 GMT

Hi,

Mostly it is the source which supports either type of pagination from one given below.

Offset

Next URL

Next token

So depending on which source you are connecting and the option which it support, you can configure that in REST connector.

Regards,

Kaushik Solanki

Re: REST API Pagination

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