Workday Connector - Not Returning any accounts

[sunilrashinkar]

Hello Team,

I am using Workday connector (connector type - WORKDAY_HYBRID_BASIC(Workday)) to import accounts. When I run the import, I dont see any accounts on Saviynt under its endpoint and the job is successful.

Here is my account mapping JSON:

{

"ImportType": "RAAS",

"ResponsePath": "wd:Report_Data.wd:Report_Entry",

"ImportMapping": {

"NAME": "wd:SAV_User_Name~#~char",

"DISPLAYNAME": "wd:Worker_group.wd:Full_Name~#~char",

"COMPANY": "wd:Worker_group.wd:Company~#~char",

"ACCOUNTID": "wd:User_Name~#~char",

"CUSTOMPROPERTY1": "wd:Worker_group.wd:Manager~#~char",

"CUSTOMPROPERTY2": "wd:Worker_group.wd:Cost_Center~#~char",

"CUSTOMPROPERTY3": "wd:Most_Recent_Sign_On~#~char",

"CUSTOMPROPERTY4": "wd:Time_of_Most_Recent_Sign_On~#~char",

"CUSTOMPROPERTY5": "wd:Worker_group.wd:Worker_Account_Status~#~char"

}

}

and Access Import list attribute:

Security Group, Organizational Role

Attached is the debug log for reference.

Any help is appreciated.

Tks

Sunil

[rushikeshvartak]

Does it works from postman ?

Account name is mandatory attribute which is coming as blank 

"2024-05-22T21:41:07.893+00:00","ecm-worker","rest.RestProvisioningService","quartzScheduler_Worker-5-pnj8d","DEBUG","INFO: Account Name is null, record not saved."

[sunilrashinkar]

Yes, it works from Postman.

If you see the above account import mapping we do have NAME and ACCOUNTID in it:

"NAME": "wd:SAV_User_Name~#~char",

"ACCOUNTID": "wd:User_Name~#~char",

Here is the Postman output with the header and one user:

User_Name,SAV_User_Name,First_Name,Middle_Name,Last_Name,Full_Name,Employee_Type,Worker_Status,Worker_Account_Status,Primary_Work_Email,Manager,Cost_Center,Company,Instance4,Instance11,Instance21,Account_Locked__Disabled_Expired,Password_Expired,Locked_-_Invalid_Credentials,Time_of_Most_Recent_Sign_On
aableidinger@xxx,aableidinger,Amy,D,Ableidinger,Amy D Ableidinger,,Active,Active,aableidinger@xxx,,,,Amy Ableidinger,aableidinger@xxx / Amy Ableidinger,aableidinger@xxx.com / Amy Ableidinger: 2024 05 17 18 10 44 756 -0700,0,1,0,2024-05-17T18:10:44.756-07:00

Note --> Email address is changed in the above output

Tks

Sunil

[rushikeshvartak]

Please share postman screenshot and job config which job type has been ran.

[sunilrashinkar · Accepted solution]

Hello Rushikesh

The account status attribute in the account mapping JSON was not correctly mapped. We changed it to the following:

"CUSTOMPROPERTY5": "wd:Account_Locked__Disabled_Expired~#~char"

AND added the following in the Status_Threshold_Config

"statusColumn": "customproperty5",

Once the above change was done, the accounts were imported back into Saviynt.

Tks for all your help so far on this.