Rest Connection Data Limitations

[BhanuPrakash]

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.

[DaveChannon · Accepted solution]

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-R... 

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).