I want to convert XML response into CDT format.

Question

I am having process model which scheduled to run after every hour and get XML response from external system and storing into text type pv. XML data in nested CDT format. Now, We want to read that XML file into Appian CDT. For reference i am giving below XML response. CAPTURE AAA BBB ABCD145891 515.0 GBP Could you please help me to achieve this task? Thanks for your support in advance.(Appian version 18.1)

Sachin · Accepted Answer

Hi vinodt376 , 
 As Sachin Raghav (sachinr981) said there are no straight forward way to do it but you can extract each value from the xml by using xpathsnippet and set it to cdt 
 Sample code can help you to achieve this 
 
 load(
 local!data: toxml(
 {
 paymentInfo: {
 {
 operationType: "CAPTURE",
 channelId: "AAA",
 paymentTypeCode: "BBB",
 referenceNumber: "ABCD145891",
 paymentAmount: "515.0",
 paymentCurrency: "GBP",
 paymentCardDetails: null
 }
 
 }
 },
 true(),
 "variable",
 null
 ),
/* you can skip foreach if you are not dealing with multiple elements
in case of single elements directly create type!cdt and xpathsnippet expression will be simply */
"/variable/*/item/operationType/text()"

 a!forEach(
 items: xpathsnippet(
 local!data,
 "/variable/*/*"
 ),
 expression: /* your cdt */
 {
 operationType: index(xpathsnippet(fv!item,"/item/operationType/text()"),1,null()),
 channelId:index(xpathsnippet(fv!item,"/item/channelId/text()"),1,null()),
 paymentTypeCode:index(xpathsnippet(fv!item,"/item/paymentTypeCode/text()"),1,null()),
 referenceNumber:index(xpathsnippet(fv!item,"/item/referenceNumber/text()"),1,null()),
 paymentAmount:index(xpathsnippet(fv!item,"/item/paymentAmount/text()"),1,null()),
 paymentCurrency:index(xpathsnippet(fv!item,"/item/paymentCurrency/text()"),1,null()),
 paymentCardDetails:index(xpathsnippet(fv!item,"/item/paymentCardDetails/text()"),1,null()),
 }
 )
 )

ravalik · Answer

Hi vinodt, 
 
As far as I know you can use torecord() function i.e,torecord(pv!nameXMLData,type) here type refers to type: (Any Type) Enter a variable (process variable or activity class) that has the same data type that you want the XML to be converted into.. 
On a note :The XML given for the xml parameter must be valid for the XSD that was used to create the target data type. 
 
Thanks, 
ravalik