Leveraging Intelligent Recommendations for Operational Transformation. AMS Partners Click HERE | EMEA/APJ Click HERE |
09/21/2023
05:51 AM
- last edited on
09/25/2023
02:18 AM
by
Sunil
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+.
09/25/2023 10:18 AM - edited 09/25/2023 10:18 AM
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.
09/26/2023 12:19 AM - edited 09/26/2023 12:45 AM
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"
}
}
09/26/2023 08:31 AM
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",
09/28/2023 01:37 AM
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>
09/28/2023 09:12 AM
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.