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
9 years ago
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.