Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
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 !