Question Re: How to implement multimapping in CPI in Technology Q&A

How to implement multimapping in CPI

Robert_d_Hoedt — Thu, 29 Jun 2023 11:39:55 GMT

Hi,

I would like to know what is the best way to implement multimapping in CPI.

My requirement is to map 1 message to 2 messages.

In the editor it looks like this

Senderside

........

</Message1>

and in the Receiverside

........

</Message1>

.........

<Messages>.

I created the mapping and tested it, For testing purposes i added the <messages><message1> tags to my message and the mapping worked.

For runtime i sent the message (without <messages><message1> tags ) and it failed.

I then looked for a solution and one suggestion was to add a Content Modifier to the iFlow for the message body:

<?xml version="1.0" encoding="UTF-8" standalone="no"?>

<ns3:Messages xmlns:ns3="http://sap.com/xi/XI/SplitAndMerge">

<ns3:Message1>

${in.body}

</ns3:Message1>

</ns3:Messages>

I added the content modifier and now my mapping works.

But now i have a problem that the result message looks like this:

........

</Message1>

.........

<Messages>.

How do get rid of all these tags?

And is this really the best solution to my mapping requirement? It seems to me a very clumsy way of doing a multimap. (compared to the way it was done in PO)

Regards

Robert

Re: How to implement multimapping in CPI

Sriprasadsbhat — Thu, 29 Jun 2023 11:48:19 GMT

Hello Robert ,

You can use content filter and trim these additional tags very easily.

Follow below to know more about content filter.

https://blogs.sap.com/2017/06/01/sap-cloud-platform-integration-content-filter-in-detail/

Regards,

Sriprasad S Bhat

Re: How to implement multimapping in CPI

Ryan-Crosby — Thu, 29 Jun 2023 11:55:20 GMT

That's the normal output structure of a multimapping in PI/PO - why would you remove the tags?

Re: How to implement multimapping in CPI

Robert_d_Hoedt — Thu, 29 Jun 2023 12:44:15 GMT

Hi Ryan,

These tags are not wanted by the receiver of the message

Robert

Re: How to implement multimapping in CPI

Ryan-Crosby — Thu, 29 Jun 2023 12:48:46 GMT

In such a case, then why use multimapping instead of using a single map?

Re: How to implement multimapping in CPI

Robert_d_Hoedt — Thu, 29 Jun 2023 12:57:31 GMT

Hi Sriprasad,

I read your blog but still no sure how to proceed.

The output of my message is

<ns3:Messages >

<ns3:Message1>

<ns2:SessionHeader >

<ns2:sessionId>xyz</ns2:sessionId>

</ns2:SessionHeader>

</ns3:Message1>

<ns3:Message2>

<ns2:setPurchaseOrderResult >

<ns2:assignmentId>1</ns2:assignmentId>

<ns2:success>true</ns2:success>

<ns2:message>message</ns2:message>

<ns2:purchaseOrderNr>123456789</ns2:purchaseOrderNr>

</ns2:setPurchaseOrderResult>

</ns3:Message2>

</ns3:Messages>

And what i need is like

<ns2:SessionHeader >

<ns2:sessionId>xyz</ns2:sessionId>

</ns2:SessionHeader>

<ns2:setPurchaseOrderResult >

<ns2:assignmentId>1</ns2:assignmentId>

<ns2:success>true</ns2:success>

<ns2:message>message</ns2:message>

<ns2:purchaseOrderNr>123456789</ns2:purchaseOrderNr>

</ns2:setPurchaseOrderResult>

Could you provide the correct XPATH to do that?

And i suppose it is NODE or NODELIST from the dropdown list?

Regards

Robert

Re: How to implement multimapping in CPI

Robert_d_Hoedt — Thu, 29 Jun 2023 14:13:53 GMT

Hi Ryan,

2023-06-29-16-02-45-window.png

I received a wsdl containing a few messages. I need to use 2 of them in the message that i send out my iflow.

So i selected one message on the left side and 2 messages on the right side of my mapping editor.

The editor automatically creates these extra tags (messages, message 1, message 2) for me.

(like i said: in PO this is of no consequence for the runtime), but apparently in CPI one must specifically add and remove the extra tags to make the mapping work.

If there is an easier way to do it all, i'm game, please let me know

Robert

Re: How to implement multimapping in CPI

Ryan-Crosby — Thu, 29 Jun 2023 14:16:49 GMT

Is the intent for the receiver to get a single message with one XML structure? If so, then I would adjust the WSDL to match the expected structure and adjust the mapping accordingly.

Re: How to implement multimapping in CPI

Robert_d_Hoedt — Mon, 03 Jul 2023 10:47:05 GMT

Hi Ryan,

It would be a lot easier that way, i agree.

But if we go that way than the receiving application needs to do some changes and so far they werent willing to do that.

Regards

Re: How to implement multimapping in CPI

Keylla_Lima — Mon, 10 Jul 2023 09:57:35 GMT

Hi Robert,

After the multimapping step you can also use a groovy script to remove that unwanted tags generated. Please see below:

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

import java.util.HashMap;

import java.io.*;

def Message processData(Message message) {

//get Body

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

//replaceMultimap tag

body = body.replaceAll('<ns2:Messages xmlns:ns2="http://sap.com/xi/XI/SplitAndMerge">', "");

body = body.replaceAll("</ns2:Messages>", "");

body = body.replaceAll("<ns2:Message1>", "");

body = body.replaceAll("</ns2:Message1>","");

body = body.replaceAll("<ns2:Message2>", "");

body = body.replaceAll("</ns2:Message2>","");

body = body.replaceAll("<ns2:Message3>", "");

body = body.replaceAll("</ns2:Message3>","");

//set body

message.setBody(body);

return message;

}

Re: How to implement multimapping in CPI

Robert_d_Hoedt — Mon, 17 Jul 2023 10:08:12 GMT

Hi Keylla,

I tried your script and it works fine.

I have another script to write in much the same way only there i have string that allready contains double quotes (" ") and now the replace command gets confused and throws an error.

I want to do this:

body.replaceAll("<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">",""> ;

But that command throws an error. Maybe this is because of the " " surrounding the namespace?

Or the :// in the namespace?

If there is a solution to this that would be helpfull

Robert

ps. I allready found my answer; in the command replaceAll you can either use single quotes or double quotes, and thereby escaping the other one.

Re: How to implement multimapping in CPI

Keylla_Lima — Mon, 17 Jul 2023 13:46:48 GMT

Hi Robert,

Please try with single quote for the snippet you want to replace that has url with double quotes:

body.replaceAll('<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">',""> ;

Re: How to implement multimapping in CPI

Robert_d_Hoedt — Mon, 17 Jul 2023 14:14:01 GMT

Hi Keylla,

Thx for your answer.

Incidentally i found the same somewhere else, but didnt see your answer yet.

Whichever way, thank you for helping me out.

Regards

Robert