```function getItems() { const columns = [ '...
# suitescript
m
Copy code
function 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;
}
👍 1