Workday Title is coming as multivalued, please assist in writing the title mapping code

[sangitaladi]

Hi Team

We are currently using below workday user import mapping :

{
"ImportType": "RAAS",
"ResponsePath":"wd:Report_Data.wd:Report_Entry",
"ImportMapping": {
"EMPLOYEEID": "wd:Employee_ID~#~string",
"USERNAME": "wd:User_Name~#~string",
"DISPLAYNAME": "wd:Full_Name~#~string",
"PREFEREDFIRSTNAME": "wd:Preferred_First_Name~#~string",
"FIRSTNAME": "wd:First_Name~#~string",
"LASTNAME": "wd:Last_Name~#~string",
"STARTDATE": "wd:Start_Date~#~string",
"TITLE": "wd:Job_Data.wd:Business_Title~#~string",
"EMAIL": "wd:Primary_Work_Email~#~string",
"CUSTOMPROPERTY1": "wd:User_Name~#~string",
"STATUSKEY": "wd:SAV_Identity_Status~#~string",
"DEPARTMENTNAME": "wd:Department.wd:Descriptor~#~string",
"CUSTOMPROPERTY12": "wd:Job_Data.wd:Company.wd:Descriptor~#~string",
"EMPLOYEETYPE": "wd:Employee_Type.wd:Descriptor~#~string",
"CUSTOMPROPERTY6": "wd:Is_Manager~#~string",
"CUSTOMPROPERTY11": "wd:Worker_Status~#~string",
"CUSTOMPROPERTY13": "wd:Cost_Center.wd:Descriptor~#~string",
"CUSTOMPROPERTY14": "wd:workdayID~#~string",
"CUSTOMPROPERTY15": "wd:Termination_Date~#~string",
"OWNER": "wd:Managers_User_Name~#~string",
"CUSTOMPROPERTY65": "wd:Managers_User_Name~#~string"
}
}

But with a recent update from Workday , we see title is coming with multivalued data like : 

["Supervisor, Production - STA","Lead Production Assoc"]

Can anyone suggest how to retrive data in below format:

Supervisor, Production - STA,Lead Production Assoc

Regards

Sangita Ladi

[rushikeshvartak]

What is current value getting pulled ?

"TITLE": "wd:Job_Data.wd:Business_Title~#~listAsString",

Reference - https://forums.saviynt.com/t5/identity-governance/saviynt-workday-attribute-mapping-for-manager/m-p/... 

[AmitM]

Hi @sangitaladi ,

try using ~listAsString instead #~string for that attribute. This will bring in multi-valued as comma separated.

Thanks,

Amit

If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

[Raghu]

@sangitaladi  try below

"TITLE": "wd:Job_Data.wd:Business_Title~;~listAsString"