Converting an XML Response to Appian values

Question

In integration if the response is in xml format, how to convert it to appian value and save in a record type

Stefan Helzle · Accepted Answer

The documentation already includes small examples. And then, you will have to learn the xPath basics. In the past, I used these tutorials 
 www.w3schools.com/.../xpath_intro.asp

Mathieu Drouin · Answer

You could try using: XML Parser 
 Otherwise, you just parse the XML manually and create your Record Type.

Mathieu Drouin · Answer

Here is a quick example: a!localVariables( local!xml: ri!xml, local!device: extract(local!xml, "", ""), local!brand: extract(local!xml, "", ""), local!price: extract(local!xml, "", ""), { device: local!device, brand: local!brand, price: local!price } )

Stefan Helzle · Answer

If the data object is not too large, I use xpathsnippet() to fetch individual values, when mapping to my internal record type.

David Jimenez · Answer

YOu can find smart services in market that convert xml to json. 
 
 XML Parser 
 community.appian.com/.../xml-and-json-conversion

Converting an XML Response to Appian values

Top Replies