How to convert xml response to a CDT

You will need to manually parse the string and create a CDT using the type cast function. Example type!myCDT(fieldA: "fieldValue", fieldB: 1). You can use a combination of the search() and mid() functions or xpathsnippet(). It might look something like:

load(
    local!xmlResponse: rule!yourIntegration(),
    local!fieldA: xpathsnippet(\*Parsing Logic goes here*\),
    local!fieldB: xpathsnippet(\*Parsing Logic goes here*\),
    type!myCDT(fieldA: local!fieldA, fieldB: local!fieldB)
)

An alternative approach to that suggested by Josh would be to use the torecord() function: docs.appian.com/.../fnc_scripting_torecord.html

Hi Josh,
The response is not a pure XML.

I tried your option but was not successful.

It is within <soap:Envelope><soap:Body></ParentNode></ChildNode></soap:Body></soap:Envelope>

Could you please share an example.

Hi,
I tried this option as well but it did not convert XML to CDT even after doing 'type!{Namespace}CDT'()

Hi,
The response is not pure XML.

It is within <soap:Envelope><soap:Body></ParentNode></ChildNode></soap:Body></soap:Envelope>

Any pointers please.

Hi Josh,
This is a sample of my output.

<loc> and <data> elements are repeating.

"<soap:Envelope xmlns:soap="schemas.xmlsoap.org/.../">
<soap:Body>

<LL xmlns="schemas.xxx.com/.../">

<loc>

<Id>1234</Id>
<guid>g1</guid>
<dC>CC</dC>

<data>
<key>Creator</key>
<value>OK</value>
<type>STRING</type>
</data>

<data>
<key>DateCreated</key>
<value>06/21/2000</value>
<type>DATE</type>
</data>

<data>
<key>IsTrue</key>
<type>BOOLEAN</type>
<value>true</value>
</data>

</loc>

<loc>

<Id>1111</Id>
<guid>g2</guid>
<dC>CC1</dC>

<data>
<key>Creator</key>
<value>OK1</value>
<type>STRING</type>
</data>

<data>
<key>DateCreated</key>
<value>06/21/2008</value>
<type>DATE</type>
</data>

<data>
<key>IsTrue</key>
<type>BOOLEAN</type>
<value>true</value>
</data>

</loc>

</LL>

</soap:Body>
</soap:Envelope>"

Please provide your inputs.

You can use extract() function if your XML needs custom manipulation for CDT formation. You will need to build one expression that can extract field values and then map them to CDT fields. Parsing logic can look like this:

load(
  local!xml:extract(ri!xmlData,"<loc>","</loc>"),
  local!items:a!forEach(
    local!xml,
    extract(fv!item,"<data>","</data>")
  ),
  a!foreach(
    local!xml,
    {
   id:extract(fv!item,"<Id>","</Id>"),
   guid:extract(fv!item,"<guid>","</guid>"),
   dc:extract(fv!item,"<dC>","</dC>")
   })  
)

 

Similarly you can create logic to parse Nested Data tags and get their value.

Hope this helps.