Qlikview Rest Connector

[prachisangewar]

Hi Experts,

I am trying to explore the Rest Connector in Qlikview.

I am reading data from a web API through Rest.

The issue I am facing is, I am not able to read all records in the table of the API.

e.g. IF the table has 200 records, Qlik reads only around 50-60 records and throws an error "Custom Read Failed".

Please advise if I need to modify any properties in the connection or any script changes.

Thanks!

[felipedl]

Hi Prachi,

Depends on the Rest API your using and how it treats the pagination process.

I've used the Pipedrive Rest API

https://developers.pipedrive.com/docs/api/v1/#/

and they give in the return message if there's more pages to it, so I simply loop until there's no more pages,.

Can you share which API your using?

Regards,

Felipe.

[prachisangewar]

Hi Felip,

I am using a dot net web api. This API is reading data from SQL Server and then converting data to stram of JSON.

Please advise if I should change the API or any settings change would do?

Thanks a ton !