Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Adobe Summit 2023 [19th to 23rd March, Las Vegas and Virtual] | Complete AEM Session & Lab list

Manipulate XML data with XMLData.parse & XMLData.applyXPath

Avatar

Level 2

Hi,

I'm calling a webservice that returns a string in XML format as follow:

<TemplateList><Template><ID>1</ID><Category> <Name>Garments</Name> <Product> <ID>6</ID><Description>Glove Cotton XL</Description><HDMSProductId>223963</HDMSProductId><LsId>223963</LsId><PopupMessage /><IsCovered>True</IsCovered><Price>0.88</Price></Product></Category></Template>/TemplateList>

I'm trying to drill down to retrieve data from this string using XMLData.parse & XMLData.applyXPath. However, I'm having a difficult time getting the data that I need.

Eg.

var tree = XMLData.parse(TextboxData.rawvalue, false);

var id = XMLData.applyXPath(tree, "TemplateList/Template");

var description = XMLData.applyXPath(tree, "TemplateList/Template/Category/Product/Description");

var templateItems = [];

for (var i=0; i<id.length; i++){

templateItems[i] = id.item(i).value + " | " + description.item(i).value;

TemplateList.addItem(templateItems[i]);

}

0 Replies