Depending on the precision, the value needs to be formatted differently.
With precision: 2023-11-25T00:00:00.000Z
Without precision: 2023-11-25T00:00:00Z
With precision is for CDS Type Timestamp and without for DateTime. Timestamp is with precision and DateTime without
The current Spreadsheet Importer Parser does not differentiale between those types.
TODO:
Differentiate between Precision available and not available. Check if this property is already available in the parser and if not how to make it available.
May check if precision is also important for numbers. Currently precision is not used (more)
In SAP CAP >=8 is a new validation implemented that checks DateTime Format, see https://cap.cloud.sap/docs/releases/jun24#new-input-validation
The Edm Type
DateTimeOffsetcan be implemented with and without precisionDepending on the precision, the value needs to be formatted differently. With precision:
2023-11-25T00:00:00.000ZWithout precision:2023-11-25T00:00:00ZWith precision is for CDS Type
Timestampand without forDateTime.Timestampis with precision andDateTimewithout The current Spreadsheet Importer Parser does not differentiale between those types.TODO: Differentiate between Precision available and not available. Check if this property is already available in the parser and if not how to make it available. May check if precision is also important for numbers. Currently precision is not used (more)
https://github.com/spreadsheetimporter/ui5-cc-spreadsheetimporter/blob/0a9b015d67261884a018f71d06776c4567f8dbe5/packages/ui5-cc-spreadsheetimporter/src/controller/Parser.ts#L48-L63