Forum Discussion

radhika1's avatar
radhika1
Contributor
6 years ago

Count the number of tags

<ns0:esbEnvelope xmlns:ns0="http://moneygram.com/esb_v3"> <ns0:header> <ns0:messageGUID>00000164bdc7c9a7-1d58dec</ns0:messageGUID> <ns0:sessionGUID/> <ns0:routingContext> <ns1:serviceFuncti...
JHunt's avatar
JHunt
Community Hero

Try

 

//consumerProfile/emailAddress

instead of

//consumerProfile//emailAddress

When you use the double slash, it finds the consumerProfile/emailAddress and the consumerProfile/emailAddress/emailAddress.

 

radhika1's avatar
radhika1
Contributor
6 years ago

Thanks it worked but I need one more help.

 

I need to get the entire xml from the <phone number> tag to </phone number> as there are two occurences for them.

 

i used the below script.

def response = groovyUtils.getXmlHolder("Operation#Response");
response.namespaces["ns1"] = "http://moneygram.com/core/service/OrchestrateGetUCP1705";

for (int y=0;y<count;y++)
{
def i2 = response["//*/consumerProfile/phoneNumber["+y+"]"];

log.info i2;

}

 

i used the below as well and didnt work.

def g  = context.expand('${Operation#Response#//*//consumerProfile/phoneNumber["+y+"]}');

 

XML:

 

 

<phoneNumber>
<countryDialInNumber>1</countryDialInNumber>
<mobileFlag>true</mobileFlag>
<phoneNumber>5128797895</phoneNumber>
<startDate>2018-10-19T21:10:52-05:00</startDate>
<stronglyAuthenticated>false</stronglyAuthenticated>
<type>PRM</type>
<notificationPreference>
<method>SMS</method>
<optIn>false</optIn>
<preferredLanguage>en-US</preferredLanguage>
<startDate>2018-10-19T21:10:52-05:00</startDate>
<stronglyAuthenticated>false</stronglyAuthenticated>
<type>TXNN</type>
</notificationPreference>
<notificationPreference>
<method>SMS</method>
<optIn>true</optIn>
<preferredLanguage>en-US</preferredLanguage>
<startDate>2018-10-19T21:10:52-05:00</startDate>
<stronglyAuthenticated>false</stronglyAuthenticated>
<type>MKTN</type>
</notificationPreference>
</phoneNumber>
<phoneNumber>
<countryDialInNumber>1</countryDialInNumber>
<mobileFlag>true</mobileFlag>
<phoneNumber>6124045907</phoneNumber>
<startDate>2018-10-19T21:10:52-05:00</startDate>
<stronglyAuthenticated>false</stronglyAuthenticated>
<type>SEC</type>
<notificationPreference>
<method>SMS</method>
<optIn>false</optIn>
<preferredLanguage>en-US</preferredLanguage>
<startDate>2018-10-19T21:10:52-05:00</startDate>
<stronglyAuthenticated>false</stronglyAuthenticated>
<type>MKTN</type>
</notificationPreference>
<notificationPreference>
<method>SMS</method>
<optIn>false</optIn>
<preferredLanguage>en-US</preferredLanguage>
<startDate>2018-10-19T21:10:52-05:00</startDate>
<stronglyAuthenticated>false</stronglyAuthenticated>
<type>TXNN</type>
</notificationPreference>
</phoneNumber>

 

 

  • JHunt's avatar
    JHunt
    Community Hero
    6 years ago

    Do you need the actual XML for the Phone Numbers, or do you just need a way to iterate over them?

     

    I don't know how to get the XML, but you can iterate over them like this:

     

    def xml = '''<xml>
    <phoneNumber>
        <countryDialInNumber>1</countryDialInNumber>
        <mobileFlag>true</mobileFlag>
        <phoneNumber>5128797895</phoneNumber>
        <startDate>2018-10-19T21:10:52-05:00</startDate>
        <stronglyAuthenticated>false</stronglyAuthenticated>
        <type>PRM</type>
        <notificationPreference>
            <method>SMS</method>
            <optIn>false</optIn>
            <preferredLanguage>en-US</preferredLanguage>
            <startDate>2018-10-19T21:10:52-05:00</startDate>
            <stronglyAuthenticated>false</stronglyAuthenticated>
            <type>TXNN</type>
        </notificationPreference>
        <notificationPreference>
            <method>SMS</method>
            <optIn>true</optIn>
            <preferredLanguage>en-US</preferredLanguage>
            <startDate>2018-10-19T21:10:52-05:00</startDate>
            <stronglyAuthenticated>false</stronglyAuthenticated>
            <type>MKTN</type>
        </notificationPreference>
    </phoneNumber>
    <phoneNumber>
        <countryDialInNumber>1</countryDialInNumber>
        <mobileFlag>true</mobileFlag>
        <phoneNumber>6124045907</phoneNumber>
        <startDate>2018-10-19T21:10:52-05:00</startDate>
        <stronglyAuthenticated>false</stronglyAuthenticated>
        <type>SEC</type>
        <notificationPreference>
            <method>SMS</method>
            <optIn>false</optIn>
            <preferredLanguage>en-US</preferredLanguage>
            <startDate>2018-10-19T21:10:52-05:00</startDate>
            <stronglyAuthenticated>false</stronglyAuthenticated>
            <type>MKTN</type>
        </notificationPreference>
        <notificationPreference>
            <method>SMS</method>
            <optIn>false</optIn>
            <preferredLanguage>en-US</preferredLanguage>
            <startDate>2018-10-19T21:10:52-05:00</startDate>
            <stronglyAuthenticated>false</stronglyAuthenticated>
            <type>TXNN</type>
        </notificationPreference>
    </phoneNumber>
</xml>
'''

new XmlSlurper().parseText(xml)
.'phoneNumber'
.each { 
	log.info "Phone number: ${it.phoneNumber}"
	log.info "Type: ${it.type}"
}

    I don't know how to do it with XmlHolder, so this uses XmlSlurper instead.

    • radhika1's avatar
      radhika1
      Contributor
      6 years ago

      Hi,

       

      Actually my intention is to read the respone from <phonenumber> to </phone number> for the two occurences and write to a text file instead of using it as a string and storing like how u did .Please assit 

      • Alex99's avatar
        Alex99
        Contributor
        6 years ago

        Given that your response looks something like this:

         

         

        ...
    <phoneNumber>
        <countryDialInNumber>1</countryDialInNumber>
        <mobileFlag>true</mobileFlag>
        <phoneNumber>5128797895</phoneNumber>
        <startDate>2018-10-19T21:10:52-05:00</startDate>
        <stronglyAuthenticated>false</stronglyAuthenticated>
    ...
...

         

        and that you want the value for the phone number, in the above example 5128797895, than you can use a variation of jhunter's solution, here you go:

         

         

        def xml = '''<xml>
    <phoneNumber>
        <countryDialInNumber>1</countryDialInNumber>
        <mobileFlag>true</mobileFlag>
        <phoneNumber>5128797895</phoneNumber>
        <startDate>2018-10-19T21:10:52-05:00</startDate>
        <stronglyAuthenticated>false</stronglyAuthenticated>
        <type>PRM</type>
        <notificationPreference>
            <method>SMS</method>
            <optIn>false</optIn>
            <preferredLanguage>en-US</preferredLanguage>
            <startDate>2018-10-19T21:10:52-05:00</startDate>
            <stronglyAuthenticated>false</stronglyAuthenticated>
            <type>TXNN</type>
        </notificationPreference>
        <notificationPreference>
            <method>SMS</method>
            <optIn>true</optIn>
            <preferredLanguage>en-US</preferredLanguage>
            <startDate>2018-10-19T21:10:52-05:00</startDate>
            <stronglyAuthenticated>false</stronglyAuthenticated>
            <type>MKTN</type>
        </notificationPreference>
    </phoneNumber>
    <phoneNumber>
        <countryDialInNumber>1</countryDialInNumber>
        <mobileFlag>true</mobileFlag>
        <phoneNumber>6124045907</phoneNumber>
        <startDate>2018-10-19T21:10:52-05:00</startDate>
        <stronglyAuthenticated>false</stronglyAuthenticated>
        <type>SEC</type>
        <notificationPreference>
            <method>SMS</method>
            <optIn>false</optIn>
            <preferredLanguage>en-US</preferredLanguage>
            <startDate>2018-10-19T21:10:52-05:00</startDate>
            <stronglyAuthenticated>false</stronglyAuthenticated>
            <type>MKTN</type>
        </notificationPreference>
        <notificationPreference>
            <method>SMS</method>
            <optIn>false</optIn>
            <preferredLanguage>en-US</preferredLanguage>
            <startDate>2018-10-19T21:10:52-05:00</startDate>
            <stronglyAuthenticated>false</stronglyAuthenticated>
            <type>TXNN</type>
        </notificationPreference>
    </phoneNumber>
</xml>
'''


new XmlSlurper().parseText(xml).'**'.findAll {
	it.name() == 'phoneNumber' && !it.childNodes()
}.each {
	log.info it //this will output the phone numbers only!
}

         

        The result will look like this:

         

         

        Mon Oct 29 18:55:19 CET 2018:INFO:5128797895
Mon Oct 29 18:55:19 CET 2018:INFO:6124045907

         

         

        To write the results into a file, edit the below code to your desired destination and format:

         

         

        def file = new File("<your filepath and filename here, e.g. c:/output.txt>")

new XmlSlurper().parseText(xml).'**'.findAll {
	it.name() == 'phoneNumber' && !it.childNodes()
}.each {
	log.info it //this will output the phone numbers only!
        file << it // see also here: http://mrhaki.blogspot.com/2009/08/groovy-goodness-working-with-files.html
}