Hi everyone, how to get more than 1000 records in suiteql and how to retrieve the next result set?

query.runSuiteQL(options) or Query.run() give you a maximum of 5000 results and return a query.ResultSet object If you need more than that, use query.runSuiteQLPaged(options) or Query.runPaged(), which have a maximum of 100,000 results. With these you instead iterate over the returned query.PagedData object

I believe this sample are for NS scripts, but how about for API call through SuiteQL?

It’s a mess https://timdietrich.me/blog/netsuite-suiteql-pagination/

sorry @jhayczee09, my bad. Forgot which channel I was in

we have a platform that can turn natural language into SuiteQL, and handle pagination very well (query all results automatically), let me know if you’re interested to try it out!