Hi all, I have a restlet that needs to export a saved search that has results over the 4000 results limit for a script, what are my options for retrieving all of the results?

4000 is just a limitation of

each

I think. https://system.netsuite.com/app/help/helpcenter.nl?fid=section_4486596158.html

implement a paging mechanism or walk though all the pages yourself and return the result

For massive result sizes, I'm a fan of the saved search task.

You may try this:

var getAllResults = function(s) {
                var results = s.run();
                var searchResults = [];
                var searchid = 0;
                do {
                        var resultslice = results.getRange({start: searchid, end: searchid + 1000});
                        resultslice.forEach(function (slice) {
                                    searchResults.push(slice);
                                    searchid++;
                            }
                        );
                } while (resultslice.length >= 1000);
                return searchResults;
        }

Usage:

var searchtran = search.create({type:'invoice'});
var search_result = getAllResults(searchtran);

use runpaged like this:

var searchResultSet = orderListSearch.runPaged({pageSize: 1000})
				if(searchResultSet){
					runSearchFlag = true
				}
			

				for( var y=0; y < (searchResultSet.pageRanges.length > 2 ? 2:searchResultSet.pageRanges.length); y++ )

Then fetch the result using fetch() like this:

var result = searchResultSet.fetch(y);