Is there a way to convert an XMLTYPE datatype in Oracle to text in Appian?

Question

Hi all, Is there a way to convert an XMLTYPE datatype in Oracle to text in Appian? Any inputs are highly appreciated!!!!!! 
 OriginalPostID-180647 
 OriginalPostID-180647

Robert Shankin · Accepted Answer

Hi Phanibabu - Are you looking to convert the entire contents of an XMLTYPE value, (including tags), or are you interested in obtaining certain values contained within the XMLTYPE? Either way, it's likely best to manage within Oracle the transformation from XMLTYPE to an Oracle data type available for use in an Appian XSD. See the list Oracle datatypes available for Appian XSDs here: forum.appian.com/.../Custom_Data_Types_from_XSD.html An XMLTYPE value cast as text could be very long. It wouldn't be ideal to regularly import all that data into process without a compelling reason. Further, you'd need to be certain that it would not exceed the size of your text column.

Ketan Patel · Answer

Hi Phani, You can create a view in oracle DB where you can convert xml column values using getStringVal() function and then query that view in Appian and map values to Appian object using torecord() function. I am not sure but you MAY directly use getStringVal() in query database smart service and map it to a text output. But as mentioned by Rob - keep an eye on your text column in Appian which will hold the converted value.