API Pagination

Anonymous — Wed, 31 Oct 2018 11:50:46 GMT

Hi,

I'm having trouble setting up Qlik Sense Desktop to pull data in from our ticket system Freshdesk due to issues with pagination.

API call in the following structure:

https://domain.freshdesk.com/api/v2/tickets?page=x

There's also a URL returned in the response header in the following structure:

Link: <https://domain.freshdesk.com/api/v2/tickets?page=x>; rel="next"

What are the correct settings for pagination in the data connection? Is URL possible, or does it have to be custom script?

An important point: there's nothing in the headers that refers to total responses from the query, so if the API call actually returns 50,000 tickets I wouldn't know and I'd just have to loop through until I hit a page that has a JSON string length of < x. This is exactly what I do in a custom c# app that parses the JSON and loads an SQL server but I'm looking at Qlik as a solution that negates the need for a data warehouse.

Thanks all

Re: API Pagination

Jannas — Fri, 19 Jul 2019 06:21:08 GMT

Just want to know if you had any success?

Also struggling with the exact same issue.

Regards

Re: API Pagination

imartinez — Thu, 05 Mar 2020 10:56:28 GMT

Hi, we hace same problem 😞

topic Re: API Pagination in Connectivity & Data Prep

API Pagination

Re: API Pagination

Re: API Pagination