Getting currency value and symbol via REST API

tt-jtw
Kilo Expert

I have a currency field on a table called Balance (u_balance).   When I get the contents of a table record via the REST, the u_balance field returns a numeric value which is value in USD (our default system currency).

For example, when the field contains 94.99 Singapore Dollars, the REST API returns 75.14.   No currency code accompanies this data.

Is there anyway to get the currency in other display formats. Similar to the getCurrencyDisplayValue() or getCurrencyStriing() methods listed in this wiki article:

Scripting Currency and Price Fields - ServiceNow Wiki

1 ACCEPTED SOLUTION

David OBrien
Kilo Guru

According to the knowledge article listed below, currency fields are always handled in US dollars via the REST API.   See #17 on the KB listed below.



ServiceNow KB: Table API FAQs (KB0534905)


View solution in original post

5 REPLIES 5

Ben Collyer
Giga Guru

Depending on your ServiceNow version write a Scriptable REST API (Geneva) or a web service (the rest).   Then you can configure your system to return the currency field on u_balance in whatever format you like.