michoel
01/24/2018, 10:45 PMfunction getItems() {
const columns = [
'internalid',
'itemid',
'salesdescription',
'baseprice',
'lastpurchaseprice',
'custitem_uom',
'upccode',
'quantityonhand',
'vendorcode',
'isinactive',
'custitem_mos_monthly_average',
];
const searchColumns = columns.map(column => new nlobjSearchColumn(column));
const search = nlapiCreateSearch('item', null, searchColumns);
const results = search.runSearch();
const items = [];
let slice = [];
let i = 0;
do {
slice = results.getResults(i, i + 1000);
slice.forEach(result => {
// convert nlobjSearchResult into simple js object
const item = {};
columns.forEach(column => (item[column] = result.getValue(column)));
items.push(item);
i++;
});
} while (slice.length >= 1000);
return items;
}