GroovyScript: Parse SOAP Response and get node names and node values

[evoks]

Hi all,

I have a SOAP response like this : 

<S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/">
   <S:Header>
      <MessageID xmlns="http://www.w3.org">uuid: ...</MessageID>
   </S:Header>
   <S:Body>
      <ns3:ResponseElement xmlns:ns2="http://www.example.com/services/common/example/xsd" xmlns:ns3="http://www.example.com/example/xsd">
         <Info>
            <Data>
               <Site>OneValue</Site>
            </Data>
            <OtherData>
               <Code>01234</Code>
               <Time>2017-05-28</Time>
               <SecondCode>ThirdValue</SecondCode>
               <Number>000</Number>
            </OtherData>
         </Info>
         <Info>
            <Data>
               <Site>OneValue</Site>
            </Data>
            <OtherData>
               <Code>56789</Code>
               <Time>2017-07-30</Time>
               <SecondCode>ThirdValue</SecondCode>
               <Number>111</Number>
            </OtherData>
         </Info>
      </ns3:ResponseElement>
   </S:Body>
</S:Envelope>

And I succeed to get some datas with this code :

def WebServiceResponse = context.expand( '${#[MyWebService]#Response#declare namespace SOAP-ENV=\'http://schemas.xmlsoap.org/soap/envelope/\'; //SOAP-ENV:Body[1]}' )
def ParsingResult = new XmlSlurper().parseText(WebServiceResponse)
def Collection = ParsingResult.'**'.collectEntries {!it.childNodes()?[it.name(), it.text()]:[:]}

for(int i = 0;i<8;i++) {
log.info (Collection.collect()[i].toString())
}

My output : 

Tue Jun 06 13:23:00 CEST 2017:INFO: Site=OneValue
Tue Jun 06 13:23:00 CEST 2017:INFO: Code=56789
Tue Jun 06 13:23:00 CEST 2017:INFO: Time=2017-07-30
Tue Jun 06 13:23:00 CEST 2017:INFO: SecondCode=ThirdValue
Tue Jun 06 13:23:00 CEST 2017:INFO: Number=111

But I cannot iterate in the first node "Info" and get its node values. I only get the second part. I want this output :

Site=OneValue
Code=01234
Time=2017-05-28
SecondCode=ThirdValue
Number=000

Site=OneValue
Code=56789
Time=2017-07-30
SecondCode=ThirdValue
Number=111

Could you help me to get a solution for this problem ? 

Many thanks in advance.

[rupert_anderson · Accepted solution]

Hi,

Ok, no problem. Although I think you can surely assume that given that it's a SOAP response we can start at the Body element - would that be OK?

If so, here is a recursive alternative:

def results=[]

def printNode
printNode = { output,node ->         
    node.children().each{ printNode(results,it) }
    if (node.children().size()==0) output << node.name()+'='+node.text() //Exlude parent elements
}

slurperResponse.'**'.findAll { it.name() == 'Body' }.each { printNode(results,it) }

results.each{
	log.info it
}

This should:

• Iterate over all child elements (not attributes, could add that)
• Only print the child element names and values (not the parent ones, to get those remove the if statement that excludes them) 

Is this what you need?

Regards,

Rup

[evoks]

@rupert_anderson, THIS IS EXACTLY WHAT I NEEDED !!

Many thanks ... I can now close this topic, I think it will be helpfull for other people.

Anthony.

[rupert_anderson]

Hi,

No problem, happy to help! 🙂

Does this also help with your other post? 

https://community.smartbear.com/t5/SoapUI-Open-Source/GroovyScript-Getting-node-name-sub-node-names-...

It looked related.. if not, let me know if I can help with this.

Thanks,

Rup

[evoks]

@rupert_anderson It is.

I put this link on the other related topic 🙂 you could close it.

BR,

Anthony