topic Re: Qlik REST API load more than one page in App Development

Qlik REST API load more than one page

montero_ro — Thu, 05 Jan 2023 12:50:11 GMT

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!

Re: Qlik REST API load more than one page

Qlik_Eric_Thomas — Thu, 05 Jan 2023 15:09:03 GMT

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-REST-connection/Pagination-scenarios.htm

Re: Qlik REST API load more than one page

montero_ro — Mon, 16 Jan 2023 17:24:11 GMT

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.