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.

nmrao's avatar
nmrao
Champion Level 3
And mention which data you wanted to extract.
babusr01's avatar
babusr01
Contributor
9 years ago

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.