Hi - here's a very detailed answer. Lots of steps, but it should work.
1
You can parse it yourself using JavaScript in the Set Value element.
Cisco provides a package to import that contains a method named XpathUtil.eval(xml,xpath)
It takes 2 arguments, an XML string, and an XPath expression.
2
However before you can parse it, you'll need to remove all the colons from the markup tags.
That can also be done using JavaScript.
3
In the Soap WS element, select the checkbox next to Response, named Store full response
The return value will be in element data for the rest element {Data.Element.Rest_01.response_xml}
That variable name won't display in the substitution window, you'll have to key it in as response_xml.
You can log it to the Activity Log in the next element's General tab to ensure you've gotten it.
4 Now you must use JavaScript to remove the colons else it's not able to be parsed as XML.
If you haven't used the SetValue element yet, it creates a variable that's a LOCAL VARIABLE (not element or session data).
Using a SetValue element, go to its Settings tab. Right-click and select Add Variable.
Name: LocalXml
Value: {Data.Element.Rest_01.response_xml}.replace(/:/g,"")
That'll remove all the colons and save the result into the Local Variable named LocalXml
5 The variable {LocalVar.LocalXml} looks something like this. I recommend logging it to the Activity Log to be sure you've removed all the weird characters.
<aItemToOrder>
<aName>Item 1 Name</aName>
<apackage1Size>10</aPackage1Size>
<aProductCode>1111</aProductCode>
</aItemToOrder>
<aItemToOrder>
<aName>Item 2 Name</aName>
<apackage1Size>20</aPackage1Size>
<aProductCode>2222</aProductCode>
</aItemToOrder
****** I recommend you stop and test this now. View the Activity Log and be sure the LocalXml looks ok. Otherwise the next step may faile.
6 Now that you know the above worked, you can return to that Set Value element to add another variable to get the size aItemToOrder array.
In the Settings tab, right-click and select Add Variable
Name: LocalNumRows
Value: (it's all case sensitive)
importPackage(com.audium.server.cvpUtil)
var xml = {LocalVar.LocalXml}
var path = "count(//aItemToOrder)"
XpathUtil.eval(xml, path)
7
Now if you wanted to loop through all the array indices, you can use a Counter element.
8
Use a Decision element to check if ElementData Counter_01 count < LocalVariable LocalNumRows - return moreData
Otherwise: done
9
Connect the moreData path to another SetValue element to grab the data you need:
You'll be using an Xpath expression like this: //aItemToOrder[1]/aName (replacing 1 with a variable)
Create the following Local Variable:
Name: LocalItemName
Value:
importPackage(com.audium.server.cvpUtil)
var xml = {LocalVar.LocalXml}
var ctr = {Data.Element.Counter_01.count}
var path = "//aItemToOrder[" + ctr + "]/aName"
XpathUtil.eval(xml, path)
Name: LocalSize
Value:
importPackage(com.audium.server.cvpUtil)
var xml = {LocalVar.LocalXml}
var ctr = {Data.Element.Counter_01.count}
var path = "//aItemToOrder[" + ctr + "]/aPackage1Size"
XpathUtil.eval(xml, path)
10 then play this info to the caller and loop back to the counter element.
