Decimals turn to ,00

[vmakela]

Hello!

I’m trying to get JSON data from this site:
https://sheets.googleapis.com/v4/spreadsheets/171CenVi372GHlqrbpifrUxVvmojUfnkOK1We4Ya_Xoo/values/Tuottohistoria!A:G?majorDimension=COLUMNS&key=AIzaSyDi4CWD6wiZuYXvoCbnIgwfCK_6Vz07xac

Path to date: $.values[0][1]
Date format: d.M.yyyy
Path to close: $.values[3][1]

Everything else works fine but price value shows 138,00 as the real value is 138,75. It automatically turns decimals into ,00.

Does anyone know what’s causing this?

[Rafa]

Problem is that numbers are provided as text with the wrong decimal sign. JSON expect a dot instead of comma and everything beyond this character is truncated.

[vmakela]

Thanks for answer. I have to take them from somewhere else.