Can if else statement and concate be written in USER_IMPORT_MAPPING of Connection RAAS(Workday)

[PriyankaJha]

Hi,

I am working on Workday where connection type is Workday_RAAS(Workday). In USER_IMPORT_MAPPING, directing mapping are working but concate , if -else is not working

{
"ImportType": "RAAS",
"ResponsePath": "wd:Report_Data.wd:Report_Entry",
"ImportMapping": {
"USERNAME": "wd:userName~#~string",
"EMPLOYEETYPE": "wd:employeeType~#~string",
"EMPLOYEEID": "wd:employeeID~#~string",
"CUSTOMPROPERTY3": "wd:preferredCommLanguage~#~string",
"CUSTOMPROPERTY5": "${'CHW'+wd:employeeID}~#~string",
"CUSTOMPROPERTY4": "${String status= wd:employeeStatus;if(status!=null && status!='' && ('L'.equalsIgnoreCase(status) || 'P'.equalsIgnoreCase(status) || 'W'.equalsIgnoreCase(status) )){'Leave of Absence'} }~#~string"
}
}

CUSTOMPROPERTY5 and  CUSTOMPROPERTY4 are not working properly.

Please find the below screenshot.

can someone help, to figure out correct syntax for RAAS(Workday) USER_IMPORT_MAPPING for concate and if-else?

Thanks & Regards,

Priyanka Jha

[armaanzahir]

Hi @PriyankaJha ,

Please use the preprocessor queries and configure the ModifyuserJSOn in the connection in order to transform and normalize the data coming in. 

Normalizing the Identity Data Using the User Import Preprocessor (saviyntcloud.com)

Solved: User Import Preprocessor - Saviynt Forums - 2765

Solved: Did You Know? You have the ability to compute user... - Saviynt Forums - 3158

Integration Options with the Saviynt Database (saviyntcloud.com)