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

The Vantage issue of trailing zeros after the decimal getting removed during the export to JSON is actually expected behavior. The decimal field value is converted to the JSON number data type, which trims trailing zeros by default.

If it is necessary to preserve the trailing zeros, in JSON the number should be represented as a string. To do this, select Text as the Field Type.

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

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request