Forum Discussion

babusr01's avatar
babusr01
Contributor
9 years ago

how to get node values using Xml Parser

Hi , Team    I am trying to read the node values , but getting empty values.   From my SOAP service response i need to read node values.   I got list nodes and each node i need get the values ...
  • babusr01's avatar
    babusr01
    9 years ago

    log.info BM.children().find( {it.name() == "A"})?.text();

  • nmrao's avatar
    nmrao
    9 years ago

    Even more elegant and precise one would be:

     

    //Closure to show the BM node details
def showBM = { BM, index ->
  log.info "Detail of BM node ${index}"
      //Print of log - either one
      //BM.children().each { println "${it.name()} : $it" }
  BM.children().each { log.info "${it.name()} : $it" }
}

    Of course, rest of the script is same.

babusr01's avatar
babusr01
Contributor

Hi

 

Please find the response, i want to read the values from BM section it have 3 collection and also same from TP.

 

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
<ns2:GDR xmlns:ns2="URL" xmlns:ns3="URL">
<PAM>
<TP>
<A>MSFT</A>
<V>9316.84</V>
<VC>-177.12</VC>
<VCP>-1.87</VCP>
<W>3.5</W>
</TP>
<TP>
<A>AAPL</A>
<V>8517.75</V>
<VC>567.75</VC>
<VCP>7.14</VCP>
<W>3.2</W>
</TP>
<TP>
<A>GOOG</A>
<V>6942.69</V>
<VC>20.88</VC>
<VCP>0.3</VCP>
<W>2.61</W>
</TP>
<BM>
<A>MCK</A>
<V>824.00</V>
<VC>-91.15</VC>
<VCP>-9.96</VCP>
<W>0.3</W>
</BM>
<BM>
<A>OXY</A>
<V>5005.50</V>
<VC>-521.14</VC>
<VCP>-9.43</VCP>
<W>1.88</W>
</BM>
<BM>
<A>FANG</A>
<V>1678.65</V>
<VC>-154.85</VC>
<VCP>-8.45</VCP>
<W>0.63</W>
</BM>
</PAM>
</ns2:GDR>
</soap:Body>
</soap:Envelope>

nmrao's avatar
nmrao
Champion Level 3
9 years ago
What is the issue in the code that you posted? That is already showing the data correctly.
Do you want to do any further processing after getting BM collection?
  • babusr01's avatar
    babusr01
    Contributor
    9 years ago

    Hi ,

     

    Thanks for quick reply.

    Yes I got it into def BM = root.'**'.findAll{it.name()=='BM'}

     

    after i am doing below step and didnt get any value

     

    BM.each { log.info "${BM.A.text()} ${BM.V.text()}"};

     

    I need to read each element value in BM. 

     

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

      Thank you for the information.

       

      Hope this is what you are looking for, click the link to quickly execute and see the output

       

      http://groovyconsole.appspot.com/script/5167211400396800

       

       

       

       

      //Closure to show the BM node details
      def showBM = { BM, index ->
      println "Detail of BM node ${index}"
       BM.with {
       println "A : ${A}"
       println "V : ${V}"
       println "VC : ${VC}"
       println "VCP : ${VCP}"
       println "W : ${W}"
       }
      }

      def xml = '''<?xml version="1.0" encoding="UTF-8"?>
      <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
       <soap:Body>
       <ns2:GDR xmlns:ns2="URL" xmlns:ns3="URL">
       <PAM>
       <TP>
       <A>MSFT</A>
       <V>9316.84</V>
       <VC>-177.12</VC>
       <VCP>-1.87</VCP>
       <W>3.5</W>
       </TP>
       <TP>
       <A>AAPL</A>
       <V>8517.75</V>
       <VC>567.75</VC>
       <VCP>7.14</VCP>
       <W>3.2</W>
       </TP>
       <TP>
       <A>GOOG</A>
       <V>6942.69</V>
       <VC>20.88</VC>
       <VCP>0.3</VCP>
       <W>2.61</W>
       </TP>
       <BM>
       <A>MCK</A>
       <V>824.00</V>
       <VC>-91.15</VC>
       <VCP>-9.96</VCP>
       <W>0.3</W>
       </BM>
       <BM>
       <A>OXY</A>
       <V>5005.50</V>
       <VC>-521.14</VC>
       <VCP>-9.43</VCP>
       <W>1.88</W>
       </BM>
       <BM>
       <A>FANG</A>
       <V>1678.65</V>
       <VC>-154.85</VC>
       <VCP>-8.45</VCP>
       <W>0.63</W>
       </BM>
       </PAM>
       </ns2:GDR>
       </soap:Body>
      </soap:Envelope>'''
      def envelope = new XmlSlurper().parseText(xml)
      def bms = envelope.'**'.findAll {it.name() == 'BM'}
      println "Size of the BM list is ${bms.size()}"
      bms.eachWithIndex { BM, id -> showBM(BM, id+1) }

      Note: if you want to see the output in soapui, then you need to replace "println" with "log.info". Other wise, it will be shown in soapui.log file.

       

      • babusr01's avatar
        babusr01
        Contributor
        9 years ago

        Thanks Rao,

         

        still i am getting below Error, when I am running in SOAPUI

         

        groovy.lang.MissingMethodException: No signature of method: groovy.util.slurpersupport.NodeChildren.info() is applicable for argument types: (org.codehaus.groovy.runtime.GStringImpl) values: [A : MCK] Possible solutions: find(), any(), find(groovy.lang.Closure), find(groovy.lang.Closure), is(java.lang.Object), any(groovy.lang.Closure) error at line: 84