CPI- accessing value mapping using groovy script

[anitabarge]

Hello Everyone ,

I want to access the value mapping in my Integration Flow.

Currently , In my graphical mapping, I have tried accessing value mapping using the standard Value Mapping function . But I want to access the value mapping using groovy script - no graphical mapping used. Whole mapping is written in groovy script only . But I am not able to access the value mapping in this scenario. Can you please help me out here?

[MortenWittrock · Accepted solution]

Hi Anita

Yes, it's possible to access value mappings from a Groovy script. Here's how to do it:

def valueMapApi = ITApiFactory.getApi(ValueMappingApi.class, null)
def value = valueMapApi.getMappedValue('source-agency', 'source-identifier', 'source-value', 'target-agency', 'target-identifier')

In order for this to work, include the following two import statements in your script:

import com.sap.it.api.ITApiFactory
import com.sap.it.api.mapping.ValueMappingApi

Javadoc documentation here: ITApiFactory ValueMappingApi

Regards,

Morten

[mhitelli · Accepted solution]

Hello Morten,

Thanks for the answer! Is it also possible to use the value mapping out on a XSLT mapping?

Best Regards,

Maximilian

[PiotrRadzki · Accepted solution]

Thanks Morten, works great.

[former_member605051]

How to pass a dynamic value for source-value?
def value= valueMapApi.getMappedValue('source-agency','source-identifier','source-value','target-agency','target-identifier').

I have tried the following code but it gives error as follows "Cannot retrive artifact for empty alias@"

import com.sap.gateway.ip.core.customdev.util.Message; import java.util.HashMap; import com.sap.it.api.ITApiFactory; import com.sap.it.api.securestore.SecureStoreService; import com.sap.it.api.securestore.UserCredential; import com.sap.it.api.ITApiFactory; import com.sap.it.api.mapping.ValueMappingApi;

def Message processData(Message message) { // get the message Properties def mProp = message.getProperties(); String site = mProp.get("Local_Prop_site"); // read the value mapping to get the security credential def valueMapApi = ITApiFactory.getApi(ValueMappingApi.class, null) String secretCredID = valueMapApi.getMappedValue('SRC', 'Site', site , 'DEST', 'Credential');

Thanks,

Thosif Chand.