Workday-RAAS: Mapping Manager Attribute

[dgeorge_]

We are working with the Workday RAAS connector and are trying to map the manager employee ID to the Saviynt Manager attribute. 

We have the following response from Workday during user import:

We need to map the Manager_1 Employee_ID. We have the following which isn't working and returning null values in the logs for this property.

"MANAGER": "wd:Manager1.wd:ID(@type=='Employee_ID')~#~string"

[rushikeshvartak]

"MANAGER": "wd:Manager_1/wd:ID[@wd:type='Employee_ID']~#~string"

[dgeorge_]

Logs still show the value being mapped as null. I've switched to using custom property 7 for now...

"CUSTOMPROPERTY7": "wd:Manager_1/wd:ID[@wd:type='Employee_ID']~#~string"

[rushikeshvartak]

Employee_ID should be same as user's user name

[dgeorge_]

They are but I have switched to a custom property now to avoid any issues with that.

[rushikeshvartak]

Does it resolved issue?

[dgeorge_]

It did not, the value is coming in as null still in the logs.

[dgeorge_]

Any other possible solutions for this?

[rushikeshvartak]

wd:Manager1.ID(@type=='Employee_ID')

[dgeorge_]

that property is still coming across as null in the logs. 

[rushikeshvartak]

wd.ID(@type=='Employee_ID')

[dgeorge_]

Still no luck on that attempt.

[rushikeshvartak]

Share response in text format

"MANAGER": "wd:Manager_1.wd:ID[@wd:type='Employee_ID']~#~string"

[dgeorge_]

2024-08-20T10:24:12-05:00-ecm-worker-services.ImportSAvDataUserService-quartzScheduler_Worker-6-f2jh2-DEBUG-Processing a Update User 9000511

2024-08-20T10:24:12-05:00-ecm-worker-services.ImportSAvDataUserService-quartzScheduler_Worker-6-f2jh2-DEBUG-processing attributes for user 9000511 , userattribute = null , updateuser = true

2024-08-20T10:24:12-05:00-ecm-worker-services.ImportSAvDataUserService-quartzScheduler_Worker-6-f2jh2-DEBUG-#3 :: 9000511 :: #Update user :: 9 :: 103

2024-08-20T10:24:12-05:00-ecm-worker-services.ImportSAvDataUserService-quartzScheduler_Worker-6-f2jh2-DEBUG-Saving user data for username : 9000511

2024-08-20T10:24:10-05:00-ecm-worker-services.ImportSAvDataUserService-quartzScheduler_Worker-6-f2jh2-DEBUG-Proceed to Import for records - > [9000511, mark goetsch, Mark, D, Goetsch, Mark Goetsch, Pensacola, Senior Instructor, ...., ....., 1, USA, PCC Faculty, 01 Pensacola Christian College, Inc., 0, Eric Bryant, FASI, Education Department (Eric Bryant), 1994-08-23-07:00, 0, null, SAATHDIR,FASI,SUEATH,SUONLGR,SUPROMO,,,,,, Mike Davis,John Cuendet,Mike Davis,Steven Martin,Doug Bullock,,,,,, Student Activities Administration (Mike Davis),Business Department (John Cuendet),Student Activities Administration (Mike Davis),Online Learning (Steven Martin),Promotions (Doug Bullock),,,,,, null, null, null] : true

2024-08-20T10:24:10-05:00-ecm-worker-services.ImportSAvDataUserService-quartzScheduler_Worker-6-f2jh2-DEBUG-Executing query select userkey as userkey from users where username = :reconvalue , reconvalue=9000511

2024-08-20T10:24:10-05:00-ecm-worker-services.ImportSAvDataUserService-quartzScheduler_Worker-6-f2jh2-DEBUG-found userkey = 1641 for 9000511

2024-08-20T10:24:10-05:00-ecm-worker-services.ImportSAvDataUserService-quartzScheduler_Worker-6-f2jh2-DEBUG-reconcillationValue during updation ::: 9000511

2024-08-20T10:24:10-05:00-ecm-worker-services.ImportSAvDataUserService-quartzScheduler_Worker-6-f2jh2-DEBUG-User with username '9000511' found.

2024-08-20T10:24:10-05:00-ecm-worker-services.ImportSAvDataUserService-quartzScheduler_Worker-6-f2jh2-DEBUG-Adding user 9000511 to the batch

2024-08-20T10:24:10-05:00-ecm-worker-services.ImportSAvDataUserService-quartzScheduler_Worker-6-f2jh2-DEBUG-This is update user 9000511 before setting the dirtyMap

2024-08-20T10:24:10-05:00-ecm-worker-services.ImportSAvDataUserService-quartzScheduler_Worker-6-f2jh2-DEBUG-#1 :: 9000511 :: #Adding update user to the batch

The second last null in that response is the property we are attempting to set, it just comes across null each time and there are no errors or info pointing to incorrect syntax or why it's not working.

[rushikeshvartak]

what is second last null? what column ?

[dgeorge_]

Should be customproperty7 (not mapping to MANAGER to get away from any User-Manager linking issues) that we are attempting to map manager_1 employee ID to. 

[dgeorge_]

Any update on this?

[dgeorge_ · Accepted solution]

The following has worked, closing this as an accepted solution:

"MANAGER": "wd:Manager_1.wd:ID[1].content~#~string"