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

I'm using the REST API to get Datasets. *Is there a way to define and get aliases in the field names?*

Renaming the columns in the UI gives you the custom name in the UI but in the API response the Dataset has the internal names of the fields.

The first problem comes when joining tables, because getting the department full name, subsidiary full name, etc all gets dumped as `fullname`, `fullname_2`, `fullname_3`, etc.

The second problem with this arises when adding new fields to the Dataset because the API response orders the fields alphabetically. So the previous `fullname_2` is now `fullname_3`, etc.

I tried with *formulas*: In the UI the formula shows the custom name, in the API response it shows as `formula_1` :sadblob:

Would love to know if there's a way around this.

I'm having to dig through a bunch of custentity1, custbody27, custcol17, etc fields that were put in improperly before I was at my company. Would love to get Display names.