I've created a datawindow and using RestClient.retrieve(dw,URL) to fetch data from our API. Works great.
However, there is a small issue regarding datetime and strings.
This is the string in the JSON responsebody containing the datetime: "messageTime": "2021-12-14T08:11:28.7511998+00:00"
And I would like to format it into date + time, "2021-12-14 08:11:28".
Or event better, norwegian format: "14.12.2021 08:11:28" (dd.mm.yyyy hh:mm:ss)
The column in the datawindow has to be string(40) to get the values in the retrieve.
If I change it to datetime, it's missing.
And I only have "[general]" in the format section in the datawindow painter.
The value is blank if I change it to something else.
Is there some sort of format that can help me here, or another workaroud?
Maritech Systems AS