Forum Discussion

evoks's avatar
evoks
Occasional Contributor
8 years ago

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

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> ...
  • rupert_anderson's avatar
    rupert_anderson
    8 years ago

    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's avatar
evoks
Occasional Contributor

Nobody could help me ? 

rupert_anderson's avatar
rupert_anderson
Valued Contributor
8 years ago

Hi,

 

Is this what you want? (have refactored it slightly):

 

 

def response='''
<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>
'''

def slurperResponse = new XmlSlurper().parseText(response)
slurperResponse.Body.ResponseElement.Info.each{
	log.info it.Data.Site
	log.info it.OtherData.Code
	log.info it.OtherData.Time
	log.info it.OtherData.SecondCode
	log.info it.OtherData.Number
}

You can hopefully just replace response with your WebServiceResponse.

 

Regards,

Rupert

 

  • evoks's avatar
    evoks
    Occasional Contributor
    8 years ago

    You're right, but if I have another parsing response, node names will change. So, I am not able to know node names.

     

     

    I have to provide a code which is parsing node names and values associated without know them.

    • nmrao's avatar
      nmrao
      Champion Level 3
      8 years ago

      evoks,

       

      Please if the below script is helpful. 

      Note that changed node names in the sample xml used for the sake of your comment.

       

      https://github.com/nmrao/groovyScripts/blob/master/xml/GetDataUsingChildren.groovy

       

      Output would be:

       

      [[Site1:OneValue, Code1:01234, Time1:2017-05-28, SecondCode1:ThirdValue, Number1:000], [Site2:OneValue, Code2:56789, Time2:2017-07-30, SecondCode2:ThirdValue, Number2:111]]

       

       

      • evoks's avatar
        evoks
        Occasional Contributor
        8 years ago

        Hi nmrao, 

         

        Thanks for your answer, It's almost that !!

         

        The problem is that I should not mention the " it.name()=='Info' ". I'll have other WebServices Response to parse, and node names will change, I can't adapt script on each response.

         

        But many thanks for your answer, I'll try to get a result by using your code !

    • nmrao's avatar
      nmrao
      Champion Level 3
      8 years ago
      Can you provide the changed sample, so that would help understand the problem better.
    • rupert_anderson's avatar
      rupert_anderson
      Valued Contributor
      8 years ago

      Hi,

       

      OK, maybe it would help if you say what you actually want to achieve... I had wrongly assumed that you had a structured SOAP response and you wanted to use assertions to maybe check node values etc, but it sounds like you would like a universal way to parse and display arbitrary SOAP responses, is that right?

       

      Thanks,

      Rupert 

      • evoks's avatar
        evoks
        Occasional Contributor
        8 years ago

        rupert_anderson that's right, I should not mention any node name in script. I know that I have to use de .children() method but I don't know exactly how to use it ...