Qlik Community

Ask a Question

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Rest Connector - Pagination using Next URL

I'm trying to get data from the DOAJ api (www.doaj.org) using the REST Connector. But I can't get the pagination right, I only get the first page. I'm using this request url: https://doaj.org/api/v1/search/journals/*?page=1&pageSize=100

At the end of the result from this request there is the "next" field so I'm assuming that Next URL is the pagination type to use but I don't know what to put in the "Next url field path". And do I also need to fill in the fields for "Query parameters" and "Query headers"?



1 Reply
Contributor III
Contributor III

You can use the custom option and use a loop to walk through the next pages:

Let total = Round(FieldValue('X-Total-Count',1)/100);

Let startAt = 1;

for startAt = 1 to total step

WITH CONNECTION(Url "https://doaj.org/api/v1/search/journals/page=$(startAt)");