💥 This was written for a very specific issue relating to Currency. Only columns referenced as custom lists have an automatic member-name lookup. Anything else would fall into possibly needing this solution.💥

When using the web services within Netsuite (the SuiteTalk API) and executing a saved search, the API does not always send back the user-friendly values as normally seen when exporting to a CSV within Netsuite. The OneCloud BizApp takes these internalIds and attempts to find the user-friendly name to produce in the report, but there are some objects such as Currency that we do not retrieve the user-friendly values for. For both performance reasons and technical limitations with the APIdo not do this for Currency and other similar objects.

Solution

The common approach that most OneCloud users take is to pull the report, and in a separate Command retrieve a list of lookup items to then map to the report. This example uses the Get All Records Command to retrieve the record type "currency". This produces a list of all of the currencies.

With the output of the Get All Records obtained, it will need to be converted to a CSV via the Convert JSON->CSV Command under the Tabular Transformation BizApp.

Once the output is in CSV format you can then use it as mapping via one of the following products:

Did this answer your question?