Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
nlapiLoadSearch error with more than 4000 results
So I started out using nlapiSearchRecord, which has a 1000 limit per execution. I had the usual loop to check for the result set being of size 1000, to indicate there might be more records. This worked, but wasn't fast enough.
Then I found out about nlapiLoadSearch with a 4000 limit per execution. This seemed like my best bet, and would let me reduce my query executions by 3/4.
However, because of the types of reports my company needs, we often have a search with more than 4000 results. So I tried the same kind of a loop, so that after 4000 records, I would request another 4000. This doesn't seem to work with nlapiLoadSearch. I get this error:
Tagged:
0