topic Re: Rest API Pagination - Next Link Tagged in "Link" as rel="next" in Integration, Extension & APIs

Rest API Pagination - Next Link Tagged in "Link" as rel="next"

prisma_elmu — Mon, 30 Oct 2023 14:52:24 GMT

Hello Qlik Community,

i try to get all the pages of an api request to "https://api.hrworks.de/v2/persons/master-data"

When doing so, the API endpoint will give back the following:

I cannot find the right type of pagination, to automatically get the next page Link. i already tried multiple things, but nothing seems to work.

Its very similar (but not the same) to this request "https://community.qlik.com/t5/Connectivity-Data-Prep/Qlik-Rest-Connector-Pagination-How-to-handle-multiple-values-in/td-p/1699918" which seems to be abandoned.

Its also very similar to that Request "https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-define-pagination-in-the-Qlik-rest-connector/td-p/1189451".

"link":< https://domain.freshdesk.com/api/v2/tickets?filter=all_tickets&page=2>;rel="next"

Is there any way to use the Qlik Sense pagination?

===

I did already build a custom Loop (Quick and dirty), which does work, by parsing the response (Link) and making the next request with the next url (by using WITH CONNECTION() ) - but i want to do it in a better / more efficient way by using qlik sense pagination.

I know, the code is not the best, i dont want to get a better code at this point.

Thanks in advance.

Re: Rest API Pagination - Next Link Tagged in "Link" as rel="next"

Dave_Channon — Thu, 23 Nov 2023 15:38:49 GMT

Hi @prisma_elmu

In furture you might have more engagement on a topic like this in the app dev forum, but looking at your example, because of the formatting of the response I think you're already using the most appropriate method.

The native connector pagination requires a clean field or attribute from which to retrieve the next url or page number. You'd be using custom from the start, which means you went down the correct path with what you built!

Re: Rest API Pagination - Next Link Tagged in "Link" as rel="next"

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