Skip to Content

Introduction:

Recently came across multiple SCN threads looking for how to deal with dynamic value mapping in SAP CPI,so this is how you can achieve the same with small example.

Scenario:

We will use POSTMAN HTTP client to push some message and get the transformed output using value mapping api ( after value mapping performed ).

Creation of Integration Artifact:

Create an IFlow having below steps as described.

Step 1:

Create a HTTP Sender Communication Channel

Step 2:

Add mapping step following below.

Input and Output Structure:

Mapping Overview of field containing value mapping:

Create a custom function to call the ValueMappingApi Mapping Java API[ Mapping API ] which internally calls the Value Mapping project and gets the required output.

Creation of Custom Function:

Custom Function Script:

Copy paste the below code in Window opened in #4 of Custom function creation.

import com.sap.it.api.mapping.*;
import com.sap.it.api.ITApiFactory;
import com.sap.it.api.ITApi;
import com.sap.it.api.mapping.ValueMappingApi;

/*Add MappingContext parameter to read or set headers and properties
def String customFunc1(String P1,String P2,MappingContext context) {
         String value1 = context.getHeader(P1);
         String value2 = context.getProperty(P2);
         return value1+value2;
}

Add Output parameter to assign the output value.
def void custFunc2(String[] is,String[] ps, Output output, MappingContext context) {
        String value1 = context.getHeader(is[0]);
        String value2 = context.getProperty(ps[0]);
        output.addValue(value1);
        output.addValue(value2);
}*/


def String dynamicValueMap(String sAgency, String sSchema, String tAgency, String tSchema, String key){

def service = ITApiFactory.getApi(ValueMappingApi.class, null);

if( service != null) {

String val= service.getMappedValue(sAgency, sSchema, key, tAgency, tSchema);
if ( val.equals("") || val ==null )
{
    return "default"
}
else
    return val
}

return null;

}

Step 3:

Add intermediate step ( optional ) Write if you want to check the transformed output ( although you get it as response in POSTMAN ).

Step 4:

Save and Deploy your IFlow.

Creation of Value Mapping Artifact:

Create value mapping which can be referred dynamically in your script based on the input you have sent.

My value mapping looks like ( simple one:) )

Save and deploy it.Now we are good to go with our testing.

Testing with some successful transformation screenshots:

Further Enhancements:

  • Even further enhancements can be done to this scenario instead of passing schema & agency you can send some unique no and in later stage of transformation( Custom Function ) manipulate which Value Mapping to be used.
  • You can handle failure case of value mapping ( in our case I have hard coded “default” for failure case) by passing custom key or default value in input payload.

Reference:

[1] Java Mapping API Help

 

Hope this is helpful..!

Regards,

Sriprasad Shivaram Bhat

To report this post you need to login first.

6 Comments

You must be Logged on to comment or reply to a post.

  1. Aditya Mani

    Hi Sriprasad,

     

    Thanks for Info, For this scenario Value Mapping and IFLOW artifacts should be in same package or it will work in different package?

    (0) 
    1. Sriprasad Shivaram Bhat Post author

      Hello Aditya,

      There is no dependency as such ,it works if Value Mapping and Integration Project are present in different packages.

      Regards,

      Sriprasad Shivaram Bhat

      (1) 

Leave a Reply