Forum Discussion

vikram_9669's avatar
vikram_9669
Occasional Contributor
11 years ago

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

I am trying to update values of node <tem:intA> and <tem:intB> in the following xml using below groovy script code.     I used below groovy script code to update the tag values. But I am getti...
amitavban's avatar
amitavban
New Contributor
8 years ago

Hi Rupert,

 

Yeah ,so I have an inhouse built(java-groovy) application which generates a SOAP response and I have to feed that response to a proprietory software .But before sending the response to the software I need to update few tag values as per the Excel received from third party.

For now I have manually updated the third party Excel column headers with XPATHs of the XML so that I can update the XMLs as per the values in the corresponding row.

My main problem is reading the column header and passing its value in place of 

Envelope.Body.CamCommand.CamAction.tCANOTIFICATIONS.pCASECIDUNDL

in the below code 

 

String fileContents = new File(FilePath).text
def xmlfromFile = new File(FilePath)
def Envelope = new XmlSlurper().parseText(xmlfromFile.getText())

Envelope.Body.CamCommand.CamAction.tCANOTIFICATIONS.pCASECIDUNDL = "NewData123"

XmlUtil xmlUtil = new XmlUtil()
println xmlUtil.serialize(Envelope)
xmlUtil.serialize(Envelope, new FileWriter(xmlfromFile))

Thanks,

Amitav