Fetching picklists from SuccessFactors and implementing custom lookup using Groovy Script in CPI

Fetching picklists from SuccessFactors and implementing custom lookup using Groovy Script in CPI

Introduction

In this blog, we will see how a SuccessFactors picklist lookup can be implemented and consume the picklist <key – value> pairs in the incoming XML and further message processing using SAP cloud platform integration in details.

 

Here, we will generate the output XML as shown below from input XML, where the values of three XML elements will be replaced with their keys.

In this case, values of TITLE, BLOOD_GROUP and Address_type fields need to be updated from picklists salutation, bloodGroup and addressType respectively.

It is important to understand that the <key-value> pair for addressType and salutation picklists would be <OptionId – en_US> but in case of bloodGroup picklist, <key-value> pair would be <external_code – en_US>. This difference can found in Groovy Script in step7.

Example of a few picklists exported from SuccessFactors:

The picklists pairs are highlighted which are being consumed in our scenario.

 

Description

The complete iFlow which is further explained step by step, here it is just to give you an overview that there’re basically two Local Integration Processes:

In first Local Integration Process(SF Picklist from lookup), we are fetching the required picklists in XML format and storing the same in global variable in

The post Fetching picklists from SuccessFactors and implementing custom lookup using Groovy Script in CPI appeared first on HR Tech Feed.