Forum Discussion

juraterfan's avatar
juraterfan
New Contributor
8 years ago

How to iterate through XML response with Groovy

I'm new to Groovy scripting and right now i'm trying to accomplish a task which requires me to capture multiple data from an xml and convert it to such as a txt file or an excel file. I'm stuck at th...
kondasamy's avatar
kondasamy
Regular Contributor
8 years ago

I suspect, you are iterating it in a wrong node position. Instead of this - 

for( item in holder.getNodeValues( "//document-description" ))

you should move up one level and should iterate as shown below,

for( item in holder.getNodeValues( "//available-document" ))

Again, for the change in number of occurrences of <document-group> , the getNodeValues() method is capable of returning a String array, where you can compute for to get comma separated values.

 

Thanks,

Kondasamy

  • juraterfan's avatar
    juraterfan
    New Contributor
    8 years ago

    Hello Kondasamy, 

     

    Thank you for your response, I get the idea that I can use holder.getNodeValues("//document-group") to retrieve all the document-group in the XML, but how would i go about retrieve just the <document-group> that are within the <available-document> ?  the reason is that I will have multiple <available-document> and the number of time it appears in the response will change, now the idea is to iterate through all the <available-document> in the XML and in each <available document> i would like to iterate through the XML and retrieve the  <document-group> that are in it. I wasnt having any solution on how would I go about nested iteration. 

     

    Thank you