Why Does My Query Stop at 100,000 Rows?
When running queries through NetSuite's REST API, NetSuite enforces a maximum result set of 100,000 rows when SuiteAnalytics Connect is not enabled.
This is a NetSuite platform limitation, not a limitation of ExtendInsights or the AI Query Generator.
Once the limit is reached, NetSuite stops returning additional records. In most cases, no error message is displayed, so your query may appear successful even though only part of the data is returned.
How can I retrieve more than 100,000 rows?
Option 1: Split your query into smaller batches (Recommended)
Modify your query to retrieve smaller data sets, such as by:
Date range (monthly or quarterly)
Subsidiary
Transaction type
Other logical filters
For example, instead of querying an entire year's worth of transactions, run separate queries for each quarter or month.
Option 2: Enable SuiteAnalytics Connect
If your NetSuite account includes SuiteAnalytics Connect, this 100,000-row REST API limitation does not apply.
SuiteAnalytics Connect is a paid NetSuite add-on that supports much larger query result sets.
If you frequently need to retrieve more than 100,000 rows, contact your NetSuite account representative to determine whether SuiteAnalytics Connect is available for your account.
Frequently Asked Questions
🔵 Is this a limitation of ExtendInsights?
No. The limit is enforced by NetSuite's REST API and applies regardless of the application or integration submitting the SuiteQL query.
🔵 Why didn't I receive an error?
NetSuite typically stops returning additional records after 100,000 rows without displaying an error, making the returned data appear complete when it is actually truncated.
Notes
The 100,000-row limit applies only when querying through NetSuite's REST API without SuiteAnalytics Connect.
If your query appears to stop unexpectedly or returns fewer records than expected, this limit is the most likely cause.
SuiteAnalytics Connect licensing, availability, and pricing vary by NetSuite edition. Please consult your NetSuite representative for the latest information.
Need Help?
Search the Help Center first: cloudextend.io/support
Still need assistance?
💬 Use in-app chat (bottom-right of our apps and on our support site)
✉️ Email cloudextend-support@celigo.com