topic Re: Qlikview Rest Connector in QlikView

Qlikview Rest Connector

prachisangewar — Wed, 25 Nov 2020 16:16:04 GMT

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 — Wed, 07 Jun 2017 19:24:26 GMT

Hi Prachi,

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

I've used the Pipedrive Rest API

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 — Tue, 13 Jun 2017 09:15:32 GMT

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 !