Flatten To JSON Function

[bego777]

Hi all,

I need send JSON string via HTTP. I used Flatten To JSON Function but if I have input type: double (named resistance) and value e.g. 0.0035 function return this string: {"resistance":0.0035000000000000000729}   Why it is? How can I correct this to get string {"resistance":0.0035} ?

Thank you

[santo_13]

Welcome to a floating-point world where fractional numbers are stored as an approximation and not precisely.

0.0035 could be approximated as 0.0035000000000000000729 in the IEEE floating-point format.

https://en.wikipedia.org/wiki/Floating-point_error_mitigation

[bego777]

Understand. But do you have any idea how to do it to get string {"resistance":0.0035} ? 😞

[drjdpowell]

If you use JSONtext to do the conversion you will get 0.0035.  The inbuilt JSON functions are designed to preserve floating-point values, rather than decimal numbers that humans work with.  

[bego777]

Thank you. JSONtext works as I expected. 😉