This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hi all, I'm writing a RESTlet that executes a search of invoices and then retrieve those invoices' header fields and line items fields as json. However, it keeps running into error "SSS_USAGE_LIMIT_EXCEEDED". What is another approach to get the data? Thanks so much.

<@U5TF1GQ20> i'm already implementing paging. But it's still taking too long :disappointed:

keep in mind i meant <https://en.wikipedia.org/wiki/Pagination|Pagination> not <https://system.netsuite.com/app/help/helpcenter.nl?fid=section_4486596158.html|Search.runPaged>

```     function searchForEachResult(mySearch, callback) {
         var pagedData;
         var page;
         pagedData = mySearch.runPaged({
             pageSize: 1000
         });
         pagedData.pageRanges.forEach(function (pageRange) {
             page = pagedData.fetch({
                 index: pageRange.index
             });
             page.data.forEach(function (result) {
                 callback(result);
             });
         });
     };```

pagination would be returning 1 page at a time from your restlet

and implementing a mechanism for the request to specify which page it wants returned

do you happen to have an example? I haven't tried it before

as in you needed help returning one page at a time?

or implementing a parameter for which page to return?

i'd like help returning one page at a time please

make `searchForEachResult` use fetch once

dont loop through the pagedData.pageRanges array