Rest Connector Row Limits

[tmumaw]

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

[stevedark · Accepted solution]

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

[tmumaw]

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