How can I increase the limit in the API? I need 5000 rows per request, but when I try to increase the limit, I'm getting this error. "o:errorDetails": [ { "detail": "The specified query parameter 'limit' is out of bounds. Provide value between 1 and 1000.", "o:errorQueryParam": "limit", "o:errorCode": "INVALID_PARAMETER" } suiteql

AI generated answer (using internal Slack threads):

The error message you're seeing is indicating that the 'limit' parameter for the SuiteQL/SuiteAPI query is out of bounds. The maximum limit for a single request is 1000 rows. If you need to retrieve more than 1000 rows, you will need to implement pagination in your API calls. In SuiteScript, you can use the

runPaged()

method to retrieve results that exceed the normal limit of

query.run()

. Here is a link to the NetSuite documentation that explains how to use this method: https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_1510780277.html#Query.runPaged(). For SuiteAPI, you can use the 'offset' parameter in conjunction with the 'limit' parameter to paginate through your results. Here is a link to the NetSuite documentation that explains how to use these parameters: https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_156414087576.html#Collection-Paging. Please note that you will need to make multiple API calls to retrieve all your data if it exceeds the maximum limit of 1000 rows per request. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******