Forum Discussion

babusr01's avatar
babusr01
Contributor
10 years ago
Solved

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
    10 years ago

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

  • nmrao's avatar
    nmrao
    10 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
Community Hero
10 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
10 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

  • babusr01's avatar
    babusr01
    Contributor
    10 years ago

    finally, i fixed the issue .

     

    thanks Rao for your help.

     

    Thanks & Regards,

    Babu

    • babusr01's avatar
      babusr01
      Contributor
      10 years ago

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

      • nmrao's avatar
        nmrao
        Community Hero
        10 years ago

        babusr01,

         

        If you see the solution, it is provided as per the request including desired output. May be, the solution should have been tried at least once to know if it working.

        If it did not work for after replacing println with log.info, then the reason is simple. There was "BM.with" leading to confusion whose child object are A, V, VCP etc., works with println though.

        Better solution would be to replace the closure with below code than what you came up with.

        def showBM = { BM, index ->
          log.info "Detail of BM node ${index}"
          log.info "A : ${BM.A}"
          log.info "V : ${BM.V}"
          log.info "VC : ${BM.VC}"
          log.info "VCP : ${BM.VCP}"
          log.info "W : ${BM.W}"
        }

         

        or Using BM.with

         

        def showLog = { log.info "${it.name()} : $it" }

         

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