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

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.