European Number Formatting in the API

Users are able to change the formatting of Number data type columns with the “localization” settings within the Edit Column Properties option on a dataset.

This gives users the ability to choose the format to match their locale standard. For instance, they can set 1.000,00 for their numbers instead of the default of 1,000.00.

Screen_Shot_2017-04-04_at_1_14_33_PM.png

When you use the API, the number format will follow the web-standard format of no commas with a dot separating the integer and fractional portions. For example, the 1.000,00 above would be displayed as 1000.00 in the API.

Screen_Shot_2017-04-04_at_1_15_10_PM.png

Socrata follows best-practice web standards, such as the JSON specification (http://www.json.org/) and the XML specification (https://www.w3.org/TR/xmlschema-2/#double), in order to ensure that customer data is encoded in a way that will allow developers and other systems to easily consume and use data.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.