This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

The SQL works fine without these parameters, and I am sure there are more than 100K records.

<https://timdietrich.me/blog/netsuite-suiteql-pagination/|https://timdietrich.me/blog/netsuite-suiteql-pagination/>

Try paginating yourself with ROWNUM instead

If I understand correctly there are different limits for total number of records available via SuiteQL depending on whether you license SuiteAnayltics Connect or not

DIY pagination via ROWNUM should get around that

You may get better results if you expose the data via restlet instead of directly via REST Web Services

Thanks, I didn't know about ROWNUM, will give it a try.