Groovy script to extract the repeated/particular XML node where the XML has dynamic parent node - SAP CPI

[former_member608567]

Hi,

I tried to extract the repeated occurrence of an XML child node from the input, so I blogged and couldn't found the one which suits my requirement. Hence I am writing this blog to make the use/modify of the script based on the requirement of yours.

My requirement:

Below is the input structure, where I need to extract and concatenate the message node from each dynamic parent node.

Input XML structure

<fields>

<body.secondary_contact>

<message>secondary_contact is required</message>

<value>

</value>

</body.secondary_contact>

<body.secondary_contact_number>

<message>secondary_contact_number is required</message>

<value>

</value>

</body.secondary_contact_number>

<body.workstream_prefix>

<message>workstream_prefix must be a number string</message>

<value>

</value>

</body.workstream_prefix>

</fields>



Ouput - secondary_contact is required,secondary_contact_number is required,workstream_prefix must be a number string

 

Groovy script:

import com.sap.gateway.ip.core.customdev.util.Message;

import java.util.HashMap;

import java.util.*;

def Message processData(Message message)

{

    def body = message.getBody(java.lang.String) as String;

    def root = new XmlParser().parseText(body);

    def i=0;

    def errors="";

    def allmessage=[];

        root.'**'.findAll { it.name() == 'message'}.each { a ->allmessage << a.text()};

    int len = allmessage.size();

    while(i<allmessage.size())

    {

        errors=errors+","+allmessage[i];

        i++;

    }

        errors=errors.substring(1);

     def messageLog = messageLogFactory.getMessageLog(message);

       if(messageLog != null){

        messageLog.setStringProperty("Logging#1", "Printing Payload As Attachment")

        messageLog.addAttachmentAsString("only_message:", len + "message - "+errors, "text/plain");

     }

     message.setBody(errors);

    return message;

}

 

Using the above script, I fulfilled my requirements. Hope I will get some suggestions to achieve this in another way.

Appreciating the responses.

Thank you,

Naveen

[DG]

Hi

There is always multiply options to solve a goal.

You could probably also perform this with XSLT, if you just wanted to extract the payloads. Thought it cannot place it into a MPL payload.

I assume you can also append to the Error in the each loop, so you dont need to concatenate the strings after.

 

[former_member713697]

Can you recommend a script that can be used in the message mapping of CPI to concatenate recurring fields from an error response like the one below if I want to concatenate the messages tags.

<?xml version="1.0" encoding="utf-8"?>
<error
xmlns="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">
<code>SY/530</code>
<message xml:lang="en">An exception was raised.</message>
<innererror>
<application>
<component_id>MM-IV-GF</component_id>
<service_namespace>/SAP/</service_namespace>
<service_id>ZXXXXXXXXXXXXXXXX</service_id>
<service_version>0001</service_version>
</application>
<transactionid>XXXXXXXXXXXX</transactionid>
<timestamp/>
<Error_Resolution>
<SAP_Transaction/>
<SAP_Note>See SAP Note 1797736 for error analysis (https://service.sap.com/sap/support/notes/1797736)</SAP_Note>
</Error_Resolution>
<errordetails>
<errordetail>
<code>ZPTP_MESSAGES/020</code>
<message>Material Number received on invoice payload from XXXXX does not match</message>
<propertyref/>
<severity>error</severity>
<target/>
<transition>false</transition>
</errordetail>
<errordetail>
<code>ZPTP_MESSAGES/021</code>
<message>with material on SAP PO 450000XXXXX item 00010</message>
<propertyref/>
<severity>error</severity>
<target/>
<transition>false</transition>
</errordetail>
<errordetail>
<code>/IWBEP/CX_MGW_BUSI_EXCEPTION</code>
<message>An exception was raised</message>
<propertyref/>
<severity>error</severity>
<target/>
<transition>false</transition>
</errordetail>
</errordetails>
</innererror>
</error>

[former_member774597]

@ Sahaj Shetty,

You can use the below Script for your input payload:

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

import com.sap.gateway.ip.core.customdev.util.Message;

import java.util.HashMap;
import java.util.*;
def Message processData(Message message)
{
def body = message.getBody(java.lang.String) as String;
def root = new XmlParser().parseText(body);
def i=0;
def errors="";
def allmessage=[];
root.'**'.findAll { it.name() == 'message'}.each { a ->allmessage << a.text()};
int len = allmessage.size();
while(i<3)
{
errors=errors+","+allmessage[i=1,i=2];
i++;
}
errors=errors.substring(1);
errors = errors.replaceAll("\\[","").replaceAll("\\]","");
def messageLog = messageLogFactory.getMessageLog(message);
if(messageLog != null){
messageLog.setStringProperty("Logging1", "Printing Payload As Attachment");
messageLog.addAttachmentAsString("only_message:", len + "message – "+errors, "text/plain");
}
message.setBody(errors);
return message;
}

Output Payload

- Thanks,

Akshay Bakliwal