I made an odata service with Olingo2/JPA and spring-boot based on this GitHub repository.
The problem is olingo does not return the date/time or timestamp columns in a correct format as defined in Odata standard (or maybe Microsoft standard). I mean my front-end library (i.e. OpenUI5) expects some value like <d:ValidFrom>/Date(1579075200000)/</d:ValidFrom>
for Edm.DateTime
column but what olingo returns is <d:ValidFrom>2020-01-15T08:00:00</d:ValidFrom>
which is not accepted by OpenUI5!
What is your suggestion?
1- Is there a way that I force Olingo to return data/time or timestamp in the format that Microsoft defined or not? (i.e. /Date(timestamp)/
)
2- Is there a way that OpenUI5 accept the date\time in a format like yyyy-MM-ddTHH:mm:ss
?
As I discussed with @Marc in the comments, olingo
in XML
format returns the data\time
or timestamp
columns in the format of yyyy-MM-ddTHH:mm:ss
:
as soon as we request the output in the JSON
format by passing ?$format=json
in the URL, the data\time
values will be return in the format of timestamp, while the value is enclosed by /Date()
string to show it is a data/time
value. (This standard is defined by Microsoft!)
In UI5
if you are going to store the data for feeding to your mock server it is needed to store the data in JSON
file and obviously the date\time
values must be stored like /Date(timestamp)
.