Groovy script get certain tag(s) from response xml

Question

Hi,&nbsp;I am rather new to groovy scripting and have a question. I have a xml request that gives a certain response:&lt;soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"&gt;&nbsp;&nbsp; &lt;SOAP-ENV:Header xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"/&gt;&nbsp;&nbsp; &lt;soap:Body&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;ns2:MT_GetValidationRanges_response xmlns:ns2="http://www.eandis.be/CAPTATIE/MF881/SPI893"&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;GetValidationRangesResponse&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;EANs&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;EAN&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;EANNumber&gt;541448860004900201&lt;/EANNumber&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;MeteringDevices&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;MeteringDevice&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;Id&gt;7100627867&lt;/Id&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;SerialNumber&gt;23598095&lt;/SerialNumber&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;DeviceLabel&gt;1&lt;/DeviceLabel&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;Indexes&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;Index&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;RegisterIdentifier&gt;TH&lt;/RegisterIdentifier&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;RegisterSequence&gt;1&lt;/RegisterSequence&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;PrevalidationMin&gt;6674&lt;/PrevalidationMin&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;PrevalidationMax&gt;7954&lt;/PrevalidationMax&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;PrevalidationDigits&gt;8&lt;/PrevalidationDigits&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;PrevalidationDecimals&gt;3&lt;/PrevalidationDecimals&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/Index&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/Indexes&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/MeteringDevice&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/MeteringDevices&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/EAN&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/EANs&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/GetValidationRangesResponse&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;Status&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;Code&gt;0&lt;/Code&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;Description&gt;OK&lt;/Description&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/Status&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/ns2:MT_GetValidationRanges_response&gt;&nbsp;&nbsp; &lt;/soap:Body&gt;&lt;/soap:Envelope&gt;&nbsp;&nbsp;From this reponse I would like to get the value of &lt;PrevalidationMin&gt; and write this to a csv file.I already found the following code online&nbsp;def oGroovyUtils = new com.eviware.soapui.support.GroovyUtils( context )def oResponseHolder = oGroovyUtils.getXmlHolder("Single GetValidationRanges" + "#Response")oResponseHolder.getNodeValue( "PrevalidationMin")&nbsp;But still need some code. I cant find the last part. Can someone help me please ?&nbsp;Thanks&nbsp;&nbsp;

nmrao · Accepted Answer

Try the below script.
&nbsp;
import com.eviware.soapui.support.XmlHolder
def xml = new XmlHolder(context.response)
def preValidationMinValue = xml.getNodeValue("//*:PrevalidationMin")
new File('c:/temp/myfile.csv').write(preValidationMinValue)
Note that, you may have to change/tune the xpath if you have multiple EAN elements to get the right value.

rupert_anderson · Answer

Hi,
&nbsp;
Assuming you are happy with capturing the value from the response e.g. using the code you had:
&nbsp;
def &nbsp;prevalidationMinValue =&nbsp;oResponseHolder.getNodeValue( "PrevalidationMin")
&nbsp;
And this gives you the value you want, then to write the file you can just do something like:&nbsp;
&nbsp;
new File('/Users/test/yourfile.csv').write(prevalidationMinValue)
&nbsp;
Is this what you needed?
&nbsp;
Cheers,
Rupert

rebbelx · Answer

Rupert,&nbsp;Thanks for your reply. I have tried your code and it gives me an error:&nbsp;ERROR:groovy.lang.MissingPropertyException: No such property: prevalidati​onMinValue for class: Script29

rebbelx · Answer

Rupert,&nbsp;Thanks for your reply. However I still get an error when trying to create the file. I get a NullPointerException.&nbsp;When I writenew File('/yourfile.csv').write("Test") the script creates a new file with the string Test in it.&nbsp;When I writenew File('/yourfile.csv').write(PrevalidationMin) I get the NullPointerException

nmrao · Answer

Are you using unix operating system and trying to save on the root directory?Any way provide the valid file path(absolute) separated by '/'  even on  windows platfrom.

rebbelx · Answer

I am using windows..Dont really see the problem. If I can create a file with a string in it and this work, the same should work with the PrevalidationMin value in it. But that gives the NullPointerException. Dont really understand why the file path wouldnt work in the 2nd example...

Forum Discussion

Groovy script get certain tag(s) from response xml

9 Replies

Related Content

Parse a JSON Response Using Groovy

Groovy script for dynamic response in Readyapi

How to Parse a JSON Response Using Groovy (Examples!)

Compare JSON & JDBC response using groovy

Compare 2 JSON responses in soapUIPRO/Groovy

Recent Discussions

Encrypt passwords and master password?

SOAP Request works in SoapUI, but not in C# code

clone TestSuite fails when there are more project with the same name

Will SOAP UI 5.6.1 work with JDK 8

How to configure Swagger in Paas to use it in Oracle APEX instance.