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
Hi,
You can store the xsd datetime which you are getting from the SOAP service as text value. Change the type of the datetime field to text in your cdt.
Once it is stored as text, you can convert it to required format in Appian or use it as it is.
If you donot want to store the value as text, you can convert the value to Appian readable format before saving the value to the cdt.
You can use a combination of split and todatetime functions to achieve this(convert the datetime to Appian format)