How to preserve trailing zeros in JSON output when using Vantage?


Trailing zeros after the decimal are getting removed during the export to JSON.
How to preserve trailing zeros during export to JSON when using Vantage?


The issue itself is related to the specifics of the trailing zeros handling in the JSON for the number type. This is expected behavior. The decimal field value is converted to the JSON number data type. This type trims trailing zeros by default.

If it is necessary to preserve the trailing zeros, then in JSON the number should be represented as a string. Therefore, please try selecting Text as the Field Type in order to obtain the expected result:

The following screenshot indicates the obtained output for each of the field types:

Have more questions? Submit a request



Please sign in to leave a comment.