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.