Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
prachisangewar
Creator
Creator

Qlikview Rest Connector

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!

2 Replies
felipedl
Partner - Specialist III
Partner - Specialist III

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
Creator
Creator
Author

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 !