While this can be done in XML parsing too, I would convert this to JSON using xml2json object (search for xml2json in the object explorer). Try it, it will be very simple with that. Just make sure you identifiy an array element and non-array elements (square brackets [ ] for array elements and curly braces { } for single property/value in the object.
Example xml object:
<CATALOG>
<CD>
<TITLE>Empire Burlesque</TITLE>
<ARTIST>Bob Dylan</ARTIST>
<COUNTRY>USA</COUNTRY>
<COMPANY>Columbia</COMPANY>
<PRICE>10.90</PRICE>
<YEAR>1985</YEAR>
</CD>
<CD>
<TITLE>Hide your heart</TITLE>
<ARTIST>Bonnie Tyler</ARTIST>
<COUNTRY>UK</COUNTRY>
<COMPANY>CBS Records</COMPANY>
<PRICE>9.90</PRICE>
<YEAR>1988</YEAR>
</CD>
</CATALOG>
{
"CATALOG": {
"CD": [
{
"TITLE": "Empire Burlesque",
"ARTIST": "Bob Dylan",
"COUNTRY": "USA",
"COMPANY": "Columbia",
"PRICE": "10.90",
"YEAR": "1985"
},
{
"TITLE": "Hide your heart",
"ARTIST": "Bonnie Tyler",
"COUNTRY": "UK",
"COMPANY": "CBS Records",
"PRICE": "9.90",
"YEAR": "1988"
}
]
}
}
//input object - myXMlObject (above sample xml object vaules are assumed)
var jsonObj = xml2json(myXMlObject) // This wil be your "CATALOG" object
System.log(jsonObj.CD) // This will give the "CD" child object consisting of 2 array elements
System.log(jsonObj.CD[0]) // This wil be the first Array element object in the CDs.
System.log(jsonObj.CD[0].TITLE // This will print "Empire Burlesque"
Note that object property names are case sensitive.
