Multivalued field from Workday

[asp]

Hello,

We have a scenario where some users in Workday may have secondary and tertiary jobs. So their record in the RaaS report would contain nodes similar to this:

All elements of "Additional_Jobs_Group" nodes need to be read into EIC. This can appear in either of the 2 ways:

CUSTOMPROPERTY20 = "Job Code 1"

CUSTOMPROPERTY21 = "Job Title 1"

CUSTOMPROPERTY22 = "Job Code 2"

CUSTOMPROPERTY23 = "Job Code 2"

OR

CUSTOMPROPERTY20 = "Job Code 1 + Job Title 1"

CUSTOMPROPERTY21 = "Job Code 2 + Job Title 2"

How can this be handled in the USER_IMPORT_MAPPING json for workday that uses the RaaS report?

Thanks

[rushikeshvartak]

share you current USER_IMPORT_MAPPING 

[asp]

{
"ImportType": "RAAS",
"ResponsePath": "wd:Report_Data.wd:Report_Entry",
"ImportMapping": {
"USERNAME": "wd:Workday_ID~#~string",
"SYSTEMUSERNAME": "wd:Workday_ID~#~string",
"FIRSTNAME": "wd:First_Name~#~string",
"LASTNAME": "wd:Last_Name~#~string",
"MIDDLENAME": "wd:Middle_Name~#~string",
"DISPLAYNAME": "wd:Full_Name_Display~#~string",
"LOCATIONDESC": "wd:Location.wd:Descriptor~#~string",
"CITY": "wd:Location_City~#~string",
"TITLE": "wd:Job_Title~#~string",
"JOBCODE": "wd:Job_Code~#~string",
"JOB_ID": "wd:Position_ID~#~string",
"EMPLOYEEID": "wd:Workday_ID~#~string",
"EMPLOYEECLASS": "wd:Employee_Type.wd:Descriptor~#~string",
"MANAGER": "wd:Manager_Info.wd:Mgr_ID~#~string",
"PREFEREDFIRSTNAME": "wd:Preferred_First~#~string",
"EMAIL": "wd:Work_Email~#~string",
"statuskey": "wd:Worker_Status~#~string",
"COUNTRY": "wd:Location_Country wd:type:ISO_3166-1_Alpha-2_Code~#~string",
"EMPLOYEETYPE": "wd:Worker_Type.wd:Descriptor~#~string",
"COMPANYNAME": "wd:Company.wd:Descriptor~#~string",
"STARTDATE": "wd:Hire_Date~#~string",
"PHONENUMBER": "wd:Work_Phone.wd:Work_Phone_Ext~#~string",
"SECONDARYPHONE": "wd:Mobile_Phone~#~string",
"LOCATIONNUMBER": "wd:Location_Code~#~string",
"COSTCENTER": "wd:Cost_Center_Name~#~string",
"TERMDATE": "wd:Termination_Dt~#~string",
"CUSTOMPROPERTY1": "wd:Cost_Center_Code~#~string",
"CUSTOMPROPERTY2": "wd:Cost_Center_Hierarchy_Code~#~string",
"CUSTOMPROPERTY3": "wd:Cost_Center_Hierarchy_Name~#~string",
"CUSTOMPROPERTY4": "wd:Home_Phone~#~string",
"CUSTOMPROPERTY5": "wd:Location_Country.wd:Descriptor~#~string",
"CUSTOMPROPERTY6": "wd:Is_Manager~#~string",
"CUSTOMPROPERTY7": "wd:Pronoun.wd:Descriptor~#~string",
"CUSTOMPROPERTY8": "wd:MFA_Register_Phone~#~string",
"CUSTOMPROPERTY9": "wd:Worker_Type.wd:Descriptor~#~string",
"CUSTOMPROPERTY10": "wd:Termination_Dt~#~string",
"CUSTOMPROPERTY11": "wd:Location_Country wd:type:ISO_3166-1_Alpha-3_Code~#~string",
"CUSTOMPROPERTY12": "wd:Location_Country wd:type:ISO_3166-1_Numeric-3_Code~#~string",
"CUSTOMPROPERTY13": "wd:Cost_Center_Hierarchy.wd:Descriptor~#~string",
"CUSTOMPROPERTY14": "wd:Worker.wd:type='WID'~#~string",
"CUSTOMPROPERTY15": "wd:Store_System_Access1~#~string",
"CUSTOMPROPERTY16": "wd:Store_System_Access2~#~string",

"CUSTOMPROPERTY20": "wd:Additional_Jobs_Group.wd:Job_Code~#~string",
"CUSTOMPROPERTY21": "wd:Additional_Jobs_Group.wd:Business_Title~#~string",
"CUSTOMPROPERTY22": "wd:Additional_Jobs_Group.wd:Job_Code~#~string",
"CUSTOMPROPERTY23": "wd:Additional_Jobs_Group.wd:Business_Title~#~string"

}
}

[rushikeshvartak]

Sample Example

Worker_Data.Employment_Data.Worker_Job_Data.Position_Data.Job_Profile_Summary_Data.Management_Level_Reference.ID(@type=='Management_Level_ID')