Skip to Content
Technical Articles
Author's profile photo naveen kumar171
naveen kumar171
March 12, 2020 1 minute read

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

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

Assigned Tags

      3 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Daniel Graversen
      Daniel Graversen

      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.

       

      Author's profile photo Sahaj Shetty
      Sahaj Shetty

      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>

      Author's profile photo Akshay Bakliwal
      Akshay Bakliwal

      @ 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%20Payload

      Output Payload

       

      - Thanks,

      Akshay Bakliwal