Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Record Query Not Returning All Records
I am making a REST API query like this:
https://<whatever>.suitetalk.api.netsuite.com/services/rest/record/v1/invoice?q=createdDate ON_OR_AFTER "5/30/2025" AND tranDate ON_OR_AFTER "1/1/2025"&limit=1000&offset=0
I get back the first 1000 of 6535 records, and cycle through all of them (repeat the query with offset), but a specific invoice record I know exists (record id=13146402) is not being returned anywhere in the result set.
When I fetch that invoice directly, I can see:
"createdDate": "2025-06-06T14:54:00Z",
"tranDate": "2025-06-06",
So it definitely should have come in my record set!
What is going on? Am I missing something?