RE: Export Fields & Field IDs related to a Record


I would like to create a list of all Fields relating to a record (e.g., Projects). I can do this with a Saved Search by adding all the fields. However, in addition to the fields I would also like to include each Field’s internal ID. Can this be done with a Saved Search?

Do you have a solution in mind?

Des Beginner Asked on October 22, 2019 in Saved Searches.
Add Comment
5 Answers

Have you tried to load the record in the console/dev tools and get all the IDs in there as well?

nlapiLoadRecord(‘record’, id#)

Beginner Answered on October 23, 2019.

I’m not familiar with the console/dev tools. Could you walk me through how to do this?

on October 24, 2019.

Absolutely! so NetSuite runs plain javascript in the backend and a lot of the records, fields and information in netsuite can be invoked through an API using internal IDs. This can also be used to manipulate fields on records. SSP 1.0 and 2.0 use these a lot. For Example to Load a Record, let’s say a Sales Order in the console you’d write something like this: nlapiLoadRecord(‘salesorder’, interalid#); That would load the sales order record and would allow you to see all the fields associated to that same record. After that you can run commands like nlapiGetFieldValue() which gets values or set values by nlapiSetFieldValue() Check this out for more information:

on October 24, 2019.

Thanks for the detailed response. I get the idea but I think I’m still stuck on “console”. Is that the browser’s console? – I did some googling and that’s what I’m assuming you mean by console. So I typed “nlapiLoadRecord(‘project’,29757);” (w/o “) into the web console and got back an error: [object Object] NLAPI.jsp:4606:15

    nsapiCheckType https://[deleted]
    nlapiLoadRecord https://[deleted]
    <anonymous> debugger eval code:1
on October 27, 2019.

Sorry. Also called Developer Tools. look at aghari’s reply below as well. Chrome ext works like a charm

on October 29, 2019.

If you are looking for to load a project with that function the type  parameter should be ‘job’ as anthe list of parameter values is at: https://[deleted]

Open Chrome Dev Tools (Ctrl+Shift+I) while logged in  and in the Console enter:

nlapiLoadRecord('job', '<IID>').fieldnames.forEach((e)=>{ console.log(e); });

Which will dump all of the fieldnames to the console.

on October 29, 2019.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.