Workday RAAS - Account Import Job data discrepancy

[Mohit_Sanka]

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]

[SB]

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.

[Mohit_Sanka]

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]

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

[Mohit_Sanka]

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]

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.