I am calling a SOAP service using integration objects; then using xmltojson() plug-in function and a!fromJson() function to retrieve the data in dictionary style.
I am storing this data into a CDT and when doing so, the date fields are NULL even though the web service is returning data. The problem is I need to transform the XSD DATETIME fields into an Appian DATE object. In the figure below you can see the format in which I get the data from SOAP web service. How do I transform an XSD DATETIME into an Appian DATE object?
Discussion posts and replies are publicly visible
Which Appian version are you working with? This is the default ISO date time format. Appian since version 19.3 will automatically parse it via a!fromJson()
We are still on 18.4 but it is good to know that in 19.3 Appian is doing it automatically. Thanks Stefan.