0 Replies Latest reply on Feb 10, 2015 1:28 PM by lc_newbee

    Manipulate XML data with XMLData.parse & XMLData.applyXPath

    lc_newbee Level 1



      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>/Template List>


      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.



      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;