ODATA Date Format

Error while processing the state                       
<b>Error Trace :</b>com.avankia.appmashups.engine.conversion.ConversionException: Error on upsert entity: Cannot convert the literal '02/13/2018' to the expected type 'Edm.DateTimeOffset'.    at com.avankia.appmashups.mscrm.adapter.MSCRMODataWriter.write(MSCRMODataWriter.java:190)    at com.avankia.appmashups.engine.conversion.ConversionProcessor$OutputGroup.processElement(ConversionProcessor.java:1607)    at com.avankia.appmashups.engine.conversion.ConversionProcessor.processState(ConversionProcessor.java:762)    at com.avankia.appmashups.engine.conversion.ConversionProcessor.execute(ConversionProcessor.java:603)    at com.avankia.appmashups.engine.conversion.ConversionProcessor.execute(ConversionProcessor.java:438)    at com.avankia.appmashups.engine.conversion.ConversionProcessor.execute(ConversionProcessor.java:195)    at com.avankia.appmashups.engine.conversion.ConversionProcessor.execute(ConversionProcessor.java:139)    at com.avankia.appmashups.quickbooks.QBWebConnectorSvcSoapImpl$QBConnectorAdapter.processPDL(QBWebConnectorSvcSoapImpl.java:286)    at com.avankia.appmashups.quickbooks.QBWebConnectorSvcSoapImpl$QBConnectorAdapter.run(QBWebConnectorSvcSoapImpl.java:238)    at java.lang.Thread.run(Thread.java:745)

Solution:

The Odata date format in the mapping doesn’t support MM/dd/yyyy format we have to use yyyy-MM-dd instead.

Example from the mapping

datedelivered-DATE(VALUE("TxnDate"),"yyyy-MM-dd","MM/dd/yyyy")

Should be changed to

datedelivered-DATE(VALUE("TxnDate"),"yyyy-MM-dd","yyyy-MM-dd")