Mapping of XML Schema and OData Entity Data Model (EDM) datatypes
Following is the mapping between XML Schema and OData EDM datatypes:
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.