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?

Beginner Asked on October 22, 2019 in Saved Searches.
Add Comment
4 Answer(s)
Best answer

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.

Beginner Answered on October 23, 2019.

I forgot about &xml=T, thanks. I think that will meet our needs for now.

on October 24, 2019.
Add Comment

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.

Rookie Answered on October 28, 2019.

That is frigging awesome! Thanks man! just downloaded and already using.

on October 29, 2019.
Add Comment

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.

 

Beginner Answered on October 22, 2019.

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.

on October 24, 2019.
Add Comment

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: https://system.netsuite.com/core/media/media.nl?id=51416823&c=NLCORP&h=c7cecd8e1180e6076aca&_xt=.pdf

 

https://developers.suitecommerce.com/get-started-with-suitescript-models-and-service-controllers-for-suitecommerce-advanced

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].app.netsuite.com/javascript/NLAPI.jsp?NS_VER=2019.2.0&minver=71&JSP_VER=1&locale=en_US:4606
    nlapiLoadRecord https://[deleted].app.netsuite.com/javascript/NLAPI.jsp?NS_VER=2019.2.0&minver=71&JSP_VER=1&locale=en_US:2265
    <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].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.

on October 29, 2019.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor