Azure Custom SOAP connector SOAP to REST with Logic Apps error on Date

Question

I have an Azure Custom Connector to a SOAP API that is configured with SOAP to REST. One of the methods have datetime as input:

I am genereting the DateTime with the following expression:

formatDateTime(addDays(utcNow(), -1), 's')

With the following raw input from Logic Apps, I get datetime format exception

{
"method": "post",
"path": "/MethodWithDates",
"retryPolicy": {
    "type": "None"
},
"body": {
    "MethodWithDates": {
        "timefrom": "2019-03-18T15:59:03",
        "timeto": "2019-03-19T15:59:03"
    }
}

Errormessage from API:

The value '3/18/2019 3:59:03 PM' cannot be parsed as the type 'DateTime'.'

Notice how the datetime format has changed from raw output to recieved in the API. This leads me to believe the custom connector somehow changes the time format.

If I call the same endpoint with SOAP UI with the following SOAP request I get correct response. Notice the Datetime format is same as in RAW input from Logic app:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:tem="http://tempuri.org/">
   <soapenv:Header/>
   <soapenv:Body>
      <tem:MethodWithDates>
         <tem:timefrom>2019-03-18T15:13:31</tem:timefrom>
         <tem:timeto>2019-03-19T15:13:31</tem:timeto>
      </tem:MethodWithDates>
   </soapenv:Body>
</soapenv:Envelope>

Interestingly, this seems only to happen for the "s" format specifier, if I format the value in any other way it is passed through in the format I specify. I still get an error in the API as its a WCF API and it seems to require the "s" format.

Ketan Ketan · Accepted Answer · 2019-03-21T05:05:22

I can reproduce the same error when SOAP service has a Datetime input which I believe is not parsing correctly.

I am able to make this work by changing the input Datetime fields in Soap Service to string.

Non Working SOAP Service code:

public string GetDaysBetweenDates(DateTime timefrom, DateTime timeto)
{
  double value = (timeto - timefrom).TotalDays;
  return string.Format("Difference is: {0}", value);
}

Working WSDL Code

public string GetDaysBetweenDates(string timefrom, string timeto)
{
  DateTime fromdate = DateTime.Parse(timefrom);
  DateTime toDate = DateTime.Parse(timeto);
  double value = (fromdate - toDate).TotalDays;
  return string.Format("Difference is: {0}", value);
}

Azure Custom SOAP connector SOAP to REST with Logic Apps error on Date

2 Answers