Export Fields & Field IDs related to a Record
Hi,
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?
You can get a list of the field IDs by appending &xml=T to the end of the URL when viewing a record and it will show the field IDs that are displayed on that form in the XML output.
I forgot about &xml=T, thanks. I think that will meet our needs for now.
I know that this has been answered, but there is another way to view this information that is more legible in my opinion.
Using “&xml=T” gives you everything in terms of tags and can be a little difficult to read for some.
There is a chrome extension called: Netsuite Field Explorer. This does the exact same thing as “&xml=T” but is more legible.
Simply click the extension and a page will open listing all field internal ids and the current value of each field.
That is frigging awesome! Thanks man! just downloaded and already using.
I don’t think you can pull field ID in to a search.
Potential solution would be a little different for standard and custom fields, so you’d have to then merge the results.
- For standard fields, you could use the Records Browser: https://system.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2019_2/script/record/account.html
- For custom fields, you could use the Custom Entity Fields page and export a list from there.
Thanks Jenny, that’s a great suggestion. I think I can use this in combination with Brad’s response to find what we’re looking for.
Have you tried to load the record in the console/dev tools and get all the IDs in there as well?
nlapiLoadRecord(‘record’, id#)
I’m not familiar with the console/dev tools. Could you walk me through how to do this?
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: https://system.netsuite.com/core/media/media.nl?id=51416823&c=NLCORP&h=c7cecd8e1180e6076aca&_xt=.pdf
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:
Sorry. Also called Developer Tools. look at aghari’s reply below as well. Chrome ext works like a charm
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].app.netsuite.com/app/help/helpcenter.nl?fid=chapter_N3170023.html&whence=
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.
Hello , above mentioned answers are correct, though would like to add that we can take field extract from chrome plugin too
Hope this is helpful
https://chrome.google.com/webstore/detail/netsuite-field-explorer/cekalaapeajnlhphgdpmngmollojdfnd
