How to get the particular XML node length?

Priya Shekar · ‎11-04-2015

Hi All,

Below is my XML,

"<activity soapenc:arrayType="n1:ActivityType[6]"><ActivityType xsi:type="n1:ActivityType"><activityDtTm xsi:type="n1:WSTimeStampGMTType"><day xsi:type="xsd:short">2</day><hour xsi:type="xsd:short">7</hour><minute xsi:type="xsd:short">41</minute><month xsi:type="xsd:short">11</month><second xsi:type="xsd:short">0</second><year xsi:type="xsd:short">2015</year></activityDtTm><activityName xsi:type="xsd:string">Add Comment</activityName><comment xsi:type="xsd:string">testing add comment</comment><commentAccess xsi:type="xsd:string">Customer</commentAccess><fromId xsi:type="xsd:string"/><resultingState xsi:type="xsd:string">OPEN</resultingState><resultingStatus xsi:type="xsd:string">TO BE WRKD</resultingStatus><reasonCode xsi:type="xsd:string"/><sequenceNum xsi:type="xsd:short">8</sequenceNum><toId xsi:type="xsd:string"/><isActivityPerformedByCustomer xsi:type="xsd:boolean">true</isActivityPerformedByCustomer></ActivityType><ActivityType xsi:type="n1:ActivityType"><activityDtTm xsi:type="n1:WSTimeStampGMTType"><day xsi:type="xsd:short">2</day><hour xsi:type="xsd:short">7</hour><minute xsi:type="xsd:short">40</minute><month xsi:type="xsd:short">11</month><second xsi:type="xsd:short">0</second><year xsi:type="xsd:short">2015</year></activityDtTm><activityName xsi:type="xsd:string">Modify Ticket</activityName><comment xsi:type="xsd:string"/><commentAccess xsi:type="xsd:string">None</commentAccess><fromId xsi:type="xsd:string"/><resultingState xsi:type="xsd:string">OPEN</resultingState><resultingStatus xsi:type="xsd:string">TO BE WRKD</resultingStatus><reasonCode xsi:type="xsd:string"/><sequenceNum xsi:type="xsd:short">7</sequenceNum><toId xsi:type="xsd:string"/><isActivityPerformedByCustomer xsi:type="xsd:boolean">false</isActivityPerformedByCustomer></ActivityType><ActivityType xsi:type="n1:ActivityType><activityDtTm xsi:type="n1:WSTimeStampGMTType"><day xsi:type="xsd:short">2</day><hour xsi:type="xsd:short">7</hour><minute xsi:type="xsd:short">40</minute><month xsi:type="xsd:short">11</month><second xsi:type="xsd:short">0</second><year xsi:type="xsd:short">2015</year></activityDtTm>"

I am using XMLDocument2 API, I need to get the "activityName" node length/count and then display the values present in it in a field.

Does anyone know how to get the Node length\count using XMLDocument2 API??

Thanks,

Priya

sergiu_panaite · ‎11-05-2015

Your XML is not complete, as jacebenson already mentioned, so I cannot do tests on it.

But, a way of parsing XML in javascript is by using the "match" function. So, taking as an example the following XML file from w3schools:

http://www.w3schools.com/xml/simple.xml

<breakfast_menu>

   <food>

       <name>Belgian Waffles</name>

       <price>$5.95</price>

       <description>Two of our famous Belgian Waffles with plenty of real maple syrup</description>

       <calories>650</calories>

   </food>

   <food>

       <name>Strawberry Belgian Waffles</name>

       <price>$7.95</price>

       <description>Light Belgian waffles covered with strawberries and whipped cream</description>

       <calories>900</calories>

   </food>

   <food>

       <name>Berry-Berry Belgian Waffles</name>

       <price>$8.95</price>

       <description>Light Belgian waffles covered with an assortment of fresh berries and whipped cream</description>

       <calories>900</calories>

   </food>

   <food>

       <name>French Toast</name>

       <price>$4.50</price>

       <description>Thick slices made from our homemade sourdough bread</description>

       <calories>600</calories>

   </food>

   <food>

       <name>Homestyle Breakfast</name>

       <price>$6.95</price>

       <description>Two eggs, bacon or sausage, toast, and our ever-popular hash browns</description>

       <calories>950</calories>

   </food>

</breakfast_menu>

I want to get:

- value of first occurrence of a particular tag (name in this example)

- all values of a particular tag (name in this example)

For javascript code example I will be using node.js environment. I am not going to use any extra libraries besides the file system library fs one which is included by default in node.js. The fastest way for me to parse the XML was via javascript match function, as you will see below.

Getting the value of first occurrence of a particular tag:

var fs = require('fs');

var file = fs.readFileSync('./simple.xml', 'utf8');

result = file.match(/<name>([^<]*)<\/name>/);

console.log(result[1]);

Saving the code into a js file and running it via node:

sergiu $ cat one_tag.js

var fs = require('fs');

var file = fs.readFileSync('./simple.xml', 'utf8');

result = file.match(/<name>([^<]*)<\/name>/);

console.log(result[1]);

sergiu $ node one_tag.js

Belgian Waffles

sergiu $

To get all values of a particular tag I just do a global match first and then iterate through result array and apply the match function one more time:

var fs = require('fs');

var file = fs.readFileSync('./simple.xml', 'utf8');

result = file.match(/<name>([^<]*)<\/name>/g);

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

   res = result[i].match(/<name>([^<]*)<\/name>/);

   console.log(res[1]);

}

Saving the code into a js file and running it via node:

sergiu $ cat all_tags.js

var fs = require('fs');

var file = fs.readFileSync('./simple.xml', 'utf8');

result = file.match(/<name>([^<]*)<\/name>/g);

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

   res = result[i].match(/<name>([^<]*)<\/name>/);

   console.log(res[1]);

}

sergiu $ node all_tags.js

Belgian Waffles

Strawberry Belgian Waffles

Berry-Berry Belgian Waffles

French Toast

Homestyle Breakfast

sergiu $

You can apply same principle directly using javascript in the instance to parse the XML payload.

Hope this helps.

Regards,

Sergiu

View solution in original post

Phonsie Hevey1 · ‎08-18-2020

Another way of doing this server side is using gs.getXMLText(string, XPATH expression)

var responseBody = response.getBody(); var status = response.getStatusCode(); var status_from_xml = gs.getXMLText(responseBody, "//status");

I think that's easier if you just need a few elements from the XML.

You can search for "Parse XML payloads" in the docs for more information.