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