- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-01-2016 01:44 PM
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
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-15-2016 08:29 AM
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)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-15-2016 07:43 PM
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.