Hi, with soap api is there a way to include value of custom fields directly rather than getting the internal id?

Without internal id you can not post any value in the field

I don't wanna post a value, I wanna fetch the value of the custom field actually. For example for boolean fields value is returned as false or true but for

platformCore:SearchColumnSelectCustomField

value is returned in the following format:

searchValue: {
  "$attributes": {
    "internalId": "2",
    "typeId": "333"
  }
}

if you dont want to do another lookup to get the text, then create a text field that uses a formula to default to the field you want to get

I thought formula columns are not returned as result of saved searches through soap api, am I wrong?

Thats why i said to make a field

Don't have much context on Netsuite, do you mean to create a new custom field which uses a formula on another custom field and convert it into a text value?

Yes

Hmm interesting, I will check that out but is there no way to specify from soap api to return the value of the custom field inside saved search similar to UI?

not that i know of, i believe the expectation is to do another search or use getSelectValue

👍