%JSONImport & TimeStamp
Hi.
Why is %TimeStamp property not correctly imported with %JSONImport method - it doesn't take into account the time zone?
Regards,
Matjaž
Comments
Time zone is an environment level variable. The intersystems data server response is at the application level, so likely returning gmt is correct. The application can adjust based on the environment (geolocation).
Isn't time format in JSON standardized?
Please consider providing an example?
from:
https://docs.jsonata.org/date-time#:~:text=JSON%20does%20not%20have%20a,%3A45%3A00.000Z%22%20%7D.png)
for ISO 8301
#1) your source has to be a %TimeStamp aka. ODBC format
#2) it requires a LogicalToXSD() transformation.
>
write ##class(%Library.TimeStamp).LogicalToXSD($ZDT($Now(),3,,4))
2022-08-27T22:54:48.8953Z
But there is no defined Standard.
I did some upgrade to newer version of IRIS and it looks like it working now as expected.
Tnx!
Regards,
Matjaž.