topic Re: Rest Connector Row Limits in QlikView

Rest Connector Row Limits

tmumaw — Thu, 06 Sep 2018 10:25:08 GMT

Hi all,

I'm new to the rest connector (only used it for 2 days) and need a little help. I have everything setup and extracting data the only problem is it will only extract 5000 rows from my tables. Is there a way to ignore the limit?

Thanks

Thom

Re: Rest Connector Row Limits

stevedark — Thu, 06 Sep 2018 10:57:01 GMT

This limit is down to the API rather than the connector. Check with the API documentation.

There will most likely be a paging mechanism which you should be able to utilise using the REST connector.

You will most likely need to use WITH CONNECTION to send in the page size and page number to the query.

Hope that helps.

Steve

Re: Rest Connector Row Limits

tmumaw — Thu, 06 Sep 2018 11:07:15 GMT

Thanks Steve. I will check it out and let you know what I find.