Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Workday Connector - Not Returning any accounts

sunilrashinkar
New Contributor II
New Contributor II

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

 

4 REPLIES 4

rushikeshvartak
All-Star
All-Star

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."


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

sunilrashinkar
New Contributor II
New Contributor II

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

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


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

sunilrashinkar
New Contributor II
New Contributor II

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.