Forum Discussion

Mis3's avatar
Mis3
Frequent Contributor
3 years ago
Solved

if multiple attributes in a XML response, how to separate them in log.info?

I am working on yet another Groovy script to send the same testStep to an external source with different properties (read from a CSV file). I like to improve on the log report.    Below are a sampl...
  • nmrao's avatar
    nmrao
    3 years ago

    Mis3 

     

    I believe that we have to first understand  how things work rather than saying "did not work".

     

    Each solution would depend on the data.

     

    You can try this excerpt

    Note, this is not full script

     

     

     

    def xml = new XmlSlurper().parseText(xmlResponse)
def getData = { childElement, parentElement = null ->
	if (parentElement) {
		xml.'**'.findAll {it.name() == parentElement}."$childElement"*.text()
	} else {
		xml.'**'.findAll {it.name() == childElement}*.text()
	}
}
def list = ["Seq=${i}", data[0], "Status=${getData('errorCode')}", getData('fullName'), getData('networkId'), getData('code', 'service'), getData('value', 'avp')]
log.info list.flatten().join(' ')

     

     

     

    log.info => this statement any ways  shows the data time. You don't have to explicit add the date time again.

     

    EDIT:

    Haved edited the script based on your latest reply. Please the script one more time and try.

Mis3's avatar
Mis3
Frequent Contributor

I did copy some codes from the previous project (with FlowID).  I tried various forms of  findAll, collectMany but it did not work.

Below is the last one I tried.  While there was no longer syntax error, it outputs nothing more than the errorCode of the API.  I hope to output all the Service,code and avp.code separated by space or comma.

 

....

def xmlResponse = tStep.getPropertyValue("Response")
// def holder = groovyUtils.getXmlHolder(xmlResponse)
def xml = new XmlSlurper().parseText(xmlResponse)

line = ["Seq=${i}", data[0], "Status=${xml.Body.GetSubscriberResponse.errorCode}" ]
line << xml.'**'.findAll {it.name() == 'GetSubscriberResponse.subscriber.service'}.collectMany{ "${it.children()[0].@code.text()}" }
log.info line.flatten().join(' ')

...

 

Log.info:

Mon Jul 12 11:25:45 EDT 2021:INFO:Seq=0 14313140097 Status=0

---------------------------------------------------------------------------------------------------------------------------------------------

XML response:

 

<se:Envelope xmlns:se="http://schemas.xmlsoap.org/soap/envelope/">
<se:Body>
<GetSubscriberResponse xmlns="http://broadhop.com/unifiedapi/soap/types">
<errorCode>0</errorCode>
<errorMessage>Request completed successfully</errorMessage>
<subscriber>
<id>00950000b11e343960ebbaa8</id>
<name>
<fullName>John-Pierre</fullName>
</name>
<credential>
<networkId>14313140097</networkId>
<type>MSISDN</type>
</credential>
<service>
<code>DATA</code>
<enabled>true</enabled>
</service>
<service>
<code>ROAMING</code>
<enabled>true</enabled>
</service>
<service>
<code>VoLTE</code>
<enabled>true</enabled>
</service>
<service>
<code>SOS</code>
<enabled>true</enabled>
</service>
<status>ACTIVE</status>
<billingInfo/>
<avp>
<code>profileKey</code>
<value>NORMAL</value>
</avp>
<avp>
<code>profileKey1</code>
<value>XM200</value>
</avp>
<avp>
<code>profileKey1</code>
<value>XM201</value>
</avp>
<version>1</version>
</subscriber>
</GetSubscriberResponse>
</se:Body>
</se:Envelope>

 

--------------------------------------------------------------------------------------------------------------------------------------------------

 

nmrao's avatar
nmrao
Champion Level 3
3 years ago

Mis3 

 

I believe that we have to first understand  how things work rather than saying "did not work".

 

Each solution would depend on the data.

 

You can try this excerpt

Note, this is not full script

 

 

 

def xml = new XmlSlurper().parseText(xmlResponse)
def getData = { childElement, parentElement = null ->
	if (parentElement) {
		xml.'**'.findAll {it.name() == parentElement}."$childElement"*.text()
	} else {
		xml.'**'.findAll {it.name() == childElement}*.text()
	}
}
def list = ["Seq=${i}", data[0], "Status=${getData('errorCode')}", getData('fullName'), getData('networkId'), getData('code', 'service'), getData('value', 'avp')]
log.info list.flatten().join(' ')

 

 

 

log.info => this statement any ways  shows the data time. You don't have to explicit add the date time again.

 

EDIT:

Haved edited the script based on your latest reply. Please the script one more time and try.