We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK HERE.

Workday RAAS - Account Import Job data discrepancy

Mohit_Sanka
New Contributor II
New Contributor II

Hi Team,

We have configured a RAAS connector to import data from Workday into Saviynt as accounts. Currently when we trigger the job we can see some discrepancy in Data, we can see error that account information is not saved. The total No of accounts on Workday 265000+.

When we fetch the data of a single user using Postman or web browser, we can see that API is returning the latest/updated information of the user, but in Saviynt somehow the data is mismatching and getting the error message "the record is not saved."
Error: Account Name is null, record not saved 
 
Kindly help us how to fix this issue.
 
[Updated 9/25] Can anyone help us with this issue.
 
Thanks & Regards,
Mohit Srinath Sanka.
 
[This message has been edited by moderator to merge reply comment]
 
5 REPLIES 5

SB
Saviynt Employee
Saviynt Employee

Based on the error it appears the account name value is coming as null. Can you share the JSON you are using for import mapping.


Regards,
Sahil

Mohit_Sanka
New Contributor II
New Contributor II

Hi Sahil,

I am sharing the sample here.

{
"ImportType": "RAAS",
"ResponsePath": "wd:Report_Data.wd:Report_Entry",
"ImportMapping": {
"NAME": "wd:Identity~#~char",
"DISPLAYNAME": "wd:HRBP~#~char",
"ACCOUNTID": "wd:Identity~#~char",
"CUSTOMPROPERTY1" : "wd:First_Name~#~char",
"CUSTOMPROPERTY2" : "wd:Last_Name~#~char",
"CUSTOMPROPERTY3" : "wd:termination_date~#~char",
"CUSTOMPROPERTY4" : "wd:Worker_ID~#~char",
"CUSTOMPROPERTY5": "wd:Identity~#~char",
"CUSTOMPROPERTY6": "wd:Organization_Name~#~char",
"CUSTOMPROPERTY7": "wd:CountryCode~#~char",
"CUSTOMPROPERTY8": "wd:Worker_Status~#~char",
"CUSTOMPROPERTY9": "wd:Employee_Type_ID~#~char"
}
}

SB
Saviynt Employee
Saviynt Employee

The issue does appear to be with the mapping. As per the sample def mapping, the accountname and ID mapping should be as below. Can you try with below and validate.

"NAME": "wd:User_Name~#~char",
"ACCOUNTID": "wd:Workday_Account.wd:ID[0].content~#~char",


Regards,
Sahil

Mohit_Sanka
New Contributor II
New Contributor II

Hi Sahil,

I don't think we can use the above mapping. As per the response of the Report we are working there is no Account hierarchy. 

Sharing sample response we are getting in the Report.

<wd:Report_Data xmlns:wd="urn:com.workday.report/SAV_Users">
<wd:Report_Entry>
<wd:CountryCode>IN</wd:CountryCode>
<wd:Worker_ID>0007834592</wd:Worker_ID>
<wd:Worker_Status>1</wd:Worker_Status>
<wd:Employee_Type_ID>Regular</wd:Employee_Type_ID>
<wd:Identity>123454</wd:Identity>
<wd:Business_Title>Sample</wd:Business_Title>
</wd:Report_Entry>
</wd:Report_Data>

SB
Saviynt Employee
Saviynt Employee

In that case I do not see an issue with the mapping. Can you share the complete job logs. If sharing the logs over forums is not possible, you can also create a ticket with Saviynt support.


Regards,
Sahil