Mapping of XML Schema and OData Entity Data Model (EDM) datatypes

Following is the mapping between XML Schema and OData EDM datatypes:

Table 1. XML Schema and OData EDM datatypes mapping
XML Schema datatypes OData EDM datatypes Remarks
string Edm.String
boolean Edm.Boolean
hexBinary Edm.Binary
base64Binary Edm.Binary
byte Edm.SByte
short Edm.Int16
int Edm.Int32
integer Edm.Int64
long Edm.Int64
float Edm.Single
double Edm.Double
decimal Edm.Decimal
unsignedInt Edm.Int64
unsignedShort Edm.Int32
unsignedByte Edm.Int16
date Edm.Date The format while mapping this data must be YYYY-MM-dd. For example, 2015-11-25
dateTime Edm.DateTimeOffset The format while mapping this data must be YYYY-MM-dd'T'HH:mm:ss. For example, 2015-11-25T20:15:45
time Edm.TimeOfDay The format while mapping this data must be HH:mm:ss. For example, 20:15:45
duration Edm.Duration The format while mapping this data must be PnYnMnDTnHnMnS. For example, PT1004199059S, PT130S, PT2M10S, P1DT2S
Note: Any other datatype will be treated as a string in App Connect.




Feedback | Notices


Timestamp icon Last updated: Tuesday, 27 September 2016


http://pic.dhe.ibm.com/infocenter/wci/v7r0m0/topic/com.ibm.wci.doc/OData_datatype_mapping.html