This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hi everyone is there any other way to get some sublist field value  from a record apart from using record.load, save search or query?

you can render as a string that you can then parse

<@U5TF1GQ20> Thanks, But the scenario is like on invoice recd i need to load the item recd and get some value from sublist so I'm not getting how can i use render method here I will be very thankful if you can explain.

i think you mean get a value from an item sublist

in which case you use <https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_452452331542.html|render.transaction> and print it as html

which will be a string that you can parse to find your sublist values

<@U5TF1GQ20> I mean from inventory sublist of item record.

then the answer is to use N/search or N/query to find the data you are looking for

N/record may or may not have it depending on the features in the account

<@U5TF1GQ20> Thanks, actually someone asked same question and i have told him these 3 ways load, search and query but he said there is another way and i have searched the almost everywhere but didn't find any and i guess there is no other way. Thanks a lot.

N/https is the other option, though again exotic,

it usually doesnt have access to information that the other data sources dont

<@U5TF1GQ20> How N/https can be used here

<https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_159139347369.html|https.requestSuiteTalkRest(options)>

<@U5TF1GQ20> thank you, i will check this.

<@U5TF1GQ20> really exotic route with N/render. What was the use-case for that? Fast?

desperation, N/render has access to the apply sublist on customer payments

NFT still needs to load the record using Nersuites API, right?

of course, it's just suitescript, but kinder, gentler suitescript :slightly_smiling_face:

```
const inv = new Invoice(1234)
const found = _.find(inv.item, line =&gt; line.item == someitemid)
...etc.```

the only other illegal way I can think of is to JSON.stringify() the record then parse it back.

which I never do, because it's utterly undefined behavior