Rest Connection Data Limitations

BhanuPrakash — Wed, 14 Dec 2022 14:39:12 GMT

Hi,

We have successfully created the rest API connection and able to pull only 100 thousand records through rest API in qliksense. We are getting "HTTP protocol error" , when trying to pull more than 100 thousand records in qliksense. Please find the attached screenshot regarding the error. Is there any restrictions or limitations in qliksense while requesting through rest API?

Thanks,

Bhanu.

Re: Rest Connection Data Limitations

Dave_Channon — Thu, 15 Dec 2022 14:02:48 GMT

Hi @BhanuPrakash you probably want to post this in the connectivity board for more visibility: https://community.qlik.com/t5/Connectivity-Data-Prep/bd-p/qlik-sense-data-connectivity

However, I use the REST connector very regularly and typically recommend that you paginate your results to protect against things like session drops/ errors/ etc. I see you've got an offset value in that screenshot, so you could use `WITH CONNECTION` to do this - some examples are on the docs page here https://help.qlik.com/en-US/connectors/Subsystems/REST_connector_help/Content/Connectors_REST/Load-REST-data/Load-data.htm

Last thought - you may also have not returned the whole structure of the data on a dataset that large, especially if your query has a preload symbol count too low (default is 50K).

topic Rest Connection Data Limitations in Integration, Extension & APIs

Rest Connection Data Limitations

Re: Rest Connection Data Limitations