I am trying to retrieve a value from a column called "TaskData" in a t

siddharths over 9 years ago

I am trying to retrieve a value from a column called "TaskData" in a table from the DB. The column is of type XML.We retrieve the data through a web service and not directly through a data store entity.
In the response structure CDT (XSD), this taskdata field is of type text.

when I make the service call the value does not seem to map to the text field even though its present in the DB. I am able to see the value in the response when I call via SOAP UI.

Any idea why an XML value does not get mapped to a text field? Will this work only if I make the field as a CDT matching the XML type?

Discussion posts and replies are publicly visible

0 Tom Ryan
Appian Employee
over 9 years ago

Since it works correctly in SOAP UI it seems more like a web service/WSDL issue rather than DB. Can you confirm that the Appian request is formatted the same way as the SOAP UI request? Do you see anything in the app server logs?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 siddharths over 9 years ago

The request are formatted the same way as SOAP UI and getting the response as well. Only problem is that one particular field (XML type in DB to text type in CDT) does not get mapped even though its there in the DB.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Tom Ryan
Appian Employee
over 9 years ago

Is it possible to query the db directly instead? Does this produce the same result?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel