How to update tag value in external xml using groovy script?

Question

I am trying to update values of node &lt;tem:intA&gt; and &lt;tem:intB&gt; in the following xml using below groovy script code.&nbsp;&nbsp;I used below groovy script code to update the tag values. But I am getting an error "Java.lang.NullPointerException: Cannot invoke method getNodeValue() on null object error at line 36".&nbsp;&nbsp;Am I using the wrong xpath? I am not sure whats going wrong. Can someone please help me?&nbsp;

rupert_anderson · Answer

Hi,&nbsp;Ok, so if I may suggest the use of XMLSlurper, which is built into Groovy so requires no imports and is quote neat. Then if we put your XML snippet (similar typed in by me) into a file /work/SoapUI Forum/soapy.xml:&nbsp;&lt;?xml version="1.0" encoding="UTF-8"?&gt;&lt;soap:Envelope xmlns:soap="http://www.w3.org/2001/12/soap-envelope"&gt;&lt;soap:Header/&gt;&lt;soap:Body&gt;&lt;tem:Add xmlns:tem="http://tempuri.org"&gt;&lt;tem:intA&gt;5&lt;/tem:intA&gt;&lt;tem:intB&gt;7&lt;/tem:intB&gt;&lt;/tem:Add&gt;&lt;/soap:Body&gt;&lt;/soap:Envelope&gt;&nbsp;Then, the following Groovy script allows you to parse the XML from file, update the values of intA and intB and save the resulting XML back to the same file:&nbsp;import groovy.xml.XmlUtildef xmlFromFile = new File('/work/SoapUI Forum/soapy.xml')def envelopeNode = new XmlSlurper().parseText(xmlFromFile.getText())&nbsp;envelopeNode.Body.Add.intA=5envelopeNode.Body.Add.intB=7&nbsp;//Just to print it outXmlUtil xmlUtil = new XmlUtil()log.info xmlUtil.serialize(envelopeNode)&nbsp;//To update the file with updated XMLxmlUtil.serialize(envelopeNode, new FileWriter(xmlFromFile))&nbsp;Is this what you needed?&nbsp;Cheers,Rup

vikram_9669 · Answer

Thanks Rup!!&nbsp;This is what I was looking for. But how to parameterize both xpath and and node value. Lets say, I am taking this xpath (envelopeNode.Body.Add.intA) as a input parameter from excel sheet and then modifying the value to '20'.&nbsp;def sIntA=envelopeNode.Body.Add.intA&nbsp;&nbsp;&nbsp;&nbsp; // Lets say, this value is taken from excel sheet (I have a code to get the value from excel sheet)&nbsp;My aim is to get the Node's xpath from excel sheet, get the Node's value from excel sheet, update the xml with this node and save updated xml in a different folder.&nbsp;Please suggest.

rupert_anderson · Answer

Hi,&nbsp;Thats ok.&nbsp;I think I now get what you are after i.e. a way to pass the actual (XPath) query in as a String paramter, but before having a go at that, can I ask if you actually just want a way to parameterise and populate SOAP requests from your spreadsheet of values e.g. data-driven testing? If this is the case I can potentially explain&nbsp;an easier way to do this in SoapUI using your spreadsheet.&nbsp;Cheers,Rup

vikram_9669 · Answer

&nbsp;Yes Rup. I am actually looking for data driven testing. I am trying to use external xml stored on local disc. I will update the node values using xpath. After updating the xml, I will save it in different folder and at the end I will upload both request xml and response xml to the test case in ALM. It helps me keeping track of request and response used for specific test case.Please let me know if you have any easier way to do this.Really appreciate your help. Thanks!&nbsp;Cheers,Vikram&nbsp;&nbsp;

rupert_anderson · Answer

Hi Vikram,&nbsp;Ok, that sounds interesting. I don't know much about ALM, but hopefully we can sort something out.&nbsp;So a common pattern of data-driven testing in SoapUI can be:&nbsp;1. Read line of CSV data or potentially a soap request (using Groovy) in your case. You can do this in a Groovy TestStep. Say you have read the values in you can set them as properties on the context holder e.g.context["intA"]=2context["intB"]=3&nbsp;2. Setup a SOAP Request TestStep and use the properties from the context holder to parameterise the SOAP request. You can esily insert the values using whats called property expansions (see http://www.soapui.org/scripting---properties/property-expansion.html) e.g.&nbsp;&lt;?xml version="1.0" encoding="UTF-8"?&gt;&lt;soap:Envelope xmlns:soap="http://www.w3.org/2001/12/soap-envelope"&gt;&lt;soap:Header/&gt;&lt;soap:Body&gt;&lt;tem:Add xmlns:tem="http://tempuri.org"&gt;&lt;tem:intA&gt;${intA}&lt;/tem:intA&gt;&lt;tem:intB&gt;${intB}&lt;/tem:intB&gt;&lt;/tem:Add&gt;&lt;/soap:Body&gt;&lt;/soap:Envelope&gt;&nbsp;2a) You can also use the data values from the context to parameterise Assertions e.g. XPath Assertion (expected value) or Content or Script Assertions.&nbsp;3. Use another Groovy TestStep (there is also a Conditional Goto TestStep) to loop back to 1 if there are more rows of test data.&nbsp;Of course if you want to dump the SOAP request/response into a file, the thats easy enough to add with Groovy.&nbsp;Does this sound at all like what you wanted? It just sounded like it might be easier to work with data values e.g. CSV rather than having to manipulate XML with XPaths..&nbsp;If this is not really what you need, we can get back to the plan A and I'll have a go at adapting that Groovy script to use XPaths instead.&nbsp;Cheers,Rup&nbsp;&nbsp;

Forum Discussion

How to update tag value in external xml using groovy script?

Related Content

Running a external Selenium Python script from Grrovy script using SOAPUI

update object browser by script

Setup Script updates teststep property?

Class Loading - difference between bin/ext, Script Directory, and External Jar File

How to run SoapUI API commands in an external script

Recent Discussions

import wsdl adds bogus characters in incorrect places in requests?

log4j1.x vulnerability

SoapUI-5.6.0\lib\log4j-1.2.14.jar

SoupUI loop

xml to soap