topic Pagination Restful Api in QlikView

Pagination Restful Api

Wed, 25 Nov 2020 16:16:04 GMT

Hi everyone

i have an question about the pagination in the restful connector!

I can't pagination and i dont know why

source:

Paginated Responses - Eventbrite Developer Center‌

data structure

	"object_count",
	"page_number",
	"page_size",
	"page_count",
	"__FK_pagination"
	FROM "pagination"

there is also link to next url but that still not work and i dont know why

should i take offset? or next url?

Maybe someone can help me

Thanks

Re: Pagination Restful Api

Anonymous — Fri, 07 Apr 2017 15:31:50 GMT

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)");

Re: Pagination Restful Api

mstoler — Fri, 14 Apr 2017 18:03:03 GMT

Hello,

I have used the custom pagination with a Rest API.

What I did was create a loop and loop through the records. I keep track of when I am on the last call because the fields returned on the last call are different.

Michael

Re: Pagination Restful Api

negovista — Thu, 19 Jul 2018 16:21:39 GMT

This was very useful.. thx

Re: Pagination Restful Api

Anonymous — Fri, 20 Dec 2019 21:09:47 GMT

Velthuisf hi

I´m trying to create a Rest Api Connection to qlik sense business but I have not been able to insert a variable into the url so I can set up a loop and get all the data.

The original url is: https://api.repsly.com/v3/export/clients/{lastTimestamp}

To get the first set of data you have to change the previos url into https://api.repsly.com/v3/export/clients/0

I´m trying to change the 0 for a variable so I can change the variable for different values, make different request and get all the data.

The problem comes when I´m creating the connection, I add https://api.repsly.com/v3/export/clients/$(Variable) the connection do not works.

and when i tried to use this part of the code from your example

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

Any ideas?

Re: Pagination Restful Api

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

Re: Pagination Restful Api

CHAY-92 — Thu, 10 Oct 2024 19:56:03 GMT

Hello Michael

I am trying to use custom pagination but I don't know how to loop

Here are my attributes start as startindex and page_len as number of records and I have a endpoint TotalCount.Could you pls help me on this.Thanks in Advance 🙏