Groovy script to Add node in SAP CPI

Question

I was trying to add node using Groovy script but output is showing like input.

Input:

<?xml version='1.0' encoding='UTF-8'?>
  <Records>
     <Line>
     <Field1>ABC</Field1>
     <Field2>123</Field2>
     <Field3>XXX</Field3>
     <Field4>567890</Field4>
     </Line>
   </Records>

Code:

import com.sap.gateway.ip.core.customdev.util.Message;
import java.util.HashMap;``
import groovy.xml.XmlUtil;
import groovy.util.*;

def Message processData(Message message) {
//Body 
   def body = message.getBody(java.lang.String) as String;
   def root = new XmlParser().parseText(body);
   root.Line[0].appendNode("Field5", [:], "MyNewField");
   return message;
}  

Please help in creating new node using Groovy script.

Getting this error when XML path also:

No signature of method: groovy.util.NodeList.appendNode()

Answer 1

You can create a node like this so Field5 Node is added to each row inside data:

import com.sap.gateway.ip.core.customdev.util.Message;
import java.util.HashMap;
import groovy.xml.XmlUtil;
import groovy.util.*;

def Message processData(Message message) {
    def body = message.getBody(java.lang.String);
    def root = new XmlParser().parseText(body)
    root.data.row.each { row ->
        row.appendNode("Field5", "newfield")
    }
    message.setBody(XmlUtil.serialize(root));
    return message;
}

See the groovyide.com/cpi code.

Given the xml you provided on the link:

<?xml version="1.0" encoding="UTF-8"?>
<VqlQueryRestResult>
    <responseStatus>SUCCESS</responseStatus>
    <responseDetails>
        <limit>1000</limit>
        <offset>0</offset>
        <size>3</size>
        <total>3</total>
    </responseDetails>
    <data>
        <row>
            <Field1>ABC</Field1>
            <Field2>123</Field2>
            <Field3>XXX</Field3>
            <Field4>567890</Field4>
        </row>
        <row>
            <Field1>ABC</Field1>
            <Field2>123</Field2>
            <Field3>XXX</Field3>
            <Field4>567890</Field4>
        </row>
        <row>
            <Field1>ABC</Field1>
            <Field2>123</Field2>
            <Field3>XXX</Field3>
            <Field4>567890</Field4>
        </row>
    </data>
</VqlQueryRestResult>