REST API Pagination

[prees959]

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

[kaushiknsolanki]

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

[prees959]

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

[kaushiknsolanki]

Hi,

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

Offset

Next Page

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

[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