Qlik REST API load more than one page

[montero_ro]

Hello veryone!

Im trying to load pagitanted data from one API. I tried using Power BI en it allows me to load page 1 and page 2 of data. Page 1 has 10.000 records, whereas page 2 has around 2000 rows of data. However, in Qlik I only get the 10.000, and I cannot get the data from page 2.

Power BI Test

Qlik records

Does anyone know how I can get page 1 and 2 data from the same API?

Thanks a lot!

[Qlik_Eric_Thomas · Accepted solution]

Hello, 

The Qlik REST connector requires you to specify how pagination occurs. You can use this resource for some examples: https://help.qlik.com/en-US/connectors/Subsystems/REST_connector_help/Content/Connectors_REST/Create...

[montero_ro]

Hello @Qlik_Eric_Thomas ,

I just added pageno=2 like this

Once I did that, I could fetch the missing data I needed.

Thanks! and have a nice day.