I'm trying to pull some inventory positions via Su...
# suiteql
k
I'm trying to pull some inventory positions via SuiteQL. The docs here say that I can pull 100,000 results: https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_157909186990.html#:~:text=Using%20SuiteQL%20queries%2C%20you%20can,number%20of%20results%20is%20unlimited.
Copy code
Using SuiteQL queries, you can return a maximum of 100,000 results if the SuiteAnalytics Connect feature is disabled. If the feature is enabled, the number of results is unlimited.
However, if I pass a limit of anything over 1,000 then it errors at me:
The specified query parameter 'limit' is out of bounds. Provide value between 1 and 1000.
Am I misreading the docs, or do I have something configured incorrectly?
w
You can only retrieve 1000 results per call. Get 1000 and then get another 1000…
Call1: limit 1000, offset: 0 Call2: limit 1000, offset: 1000 (or something similar)
k
gotcha. that was my hunch, but I wanted to make sure I wasnt missing anything.
thanks!