How to get a list of internal id in netsuite

Question

Is there a proper way to get a list of all internal id in a Netsuite Record?

var record = nlapiLoadRecord('customer', 1249);
var string = JSON.stringify(record);
nlapiLogExecution('DEBUG', 'string ', string );

I can get most of the id using json string but i am looking for a proper way. It prints all the data including internal id. Is there any Api or any other way ?

score 9 · Answer 1 · answered Sep 13 '17 at 01:27

I actually developed a Chrome extension that displays this information in a convenient pop-up.

I ran into the same issue of nlobjRecord not stringifying properly, and what I ended up doing was manually requesting and parsing the same AJAX page NS uses internally when you call nlapiLoadRecord()

  var id = nlapiGetRecordId();
  var type = nlapiGetRecordType();
  var url = '/app/common/scripting/nlapihandler.nl';
  var payload = '<nlapiRequest type="nlapiLoadRecord" id="' + id + '" recordType="' + type + '"/>';

  var response = nlapiRequestURL(url, payload);
  nlapiLogExecution('debug', response.getBody());

You can have a look at the full source code on GitHub

https://github.com/michoelchaikin/netsuite-field-explorer/

score 5 · Accepted Answer · answered Sep 12 '17 at 15:04

The getAllFields() function will return an array of all field names, standard and custom, for a given record.

var customer = nlapiLoadRecord('customer', 5069);
var fields = customer.getAllFields();

fields.forEach(function(field) {
  nlapiLogExecution('debug', field);
})

How to get a list of internal id in netsuite

2 Answers2