Click HERE to see how Saviynt Intelligence is transforming the industry. |
06/05/2024 03:34 AM
Hi Team,
I have configured a new workday soap connector and use workday as authoritative source with below mapping
As mentioned, since we update OWNER field with manager username, manager data is unaffected but this is increasing the update history every time import is triggered. Any reasons why?
Thanks, in advanced
06/07/2024 01:15 AM
Hi @ag420
Could you please provide more information about your use case. Why are updating the manager using preprocessor? If import is removing the manager, how was the original manager updated?
Import can remove the manager if it is not present for the user in workday. Is the manager present on the workday ?
Regards,
Dhruv Sharma
06/27/2024 07:55 AM
We Save manager WID in a CP for every user and then preprocessor looksup the manager username based on join manager's WID from users= user having that WID. output username is saved in OWNER in users table and manager gets updated on its own.
Yes, there is manager in Workday but we can only get WID in SOAP API response
06/27/2024 10:30 AM
Please share preprocessor logic
06/28/2024 02:10 AM
{
"ADDITIONALTABLES": {
"USERS": "SELECT USERKEY,USERNAME,OWNER,REGION,CUSTOMPROPERTY1,CUSTOMPROPERTY6,CUSTOMPROPERTY65 FROM USERS",
"DATASET_VALUES": "SELECT ATTRIBUTE1,ATTRIBUTE2,DATASETNAME FROM DATASET_VALUES WHERE DATASETNAME = 'MAJOR_OFFICE_TRANSFORM'"
},
"COMPUTEDCOLUMNS": [ "OWNER","CUSTOMPROPERTY65","REGION"],
"PREPROCESSQUERIES": [
"UPDATE NEWUSERDATA SET OWNER = (SELECT CU.USERNAME FROM CURRENTUSERS CU WHERE CU.CUSTOMPROPERTY1 = NEWUSERDATA.CUSTOMPROPERTY6)",
"UPDATE NEWUSERDATA SET CUSTOMPROPERTY65 ='WD-WHO'",
"UPDATE NEWUSERDATA SET REGION = (SELECT DV.ATTRIBUTE1 FROM CURRENTDATASET_VALUES DV WHERE DV.ATTRIBUTE2 = NEWUSERDATA.REGION AND DV.DATASETNAME = 'MAJOR_OFFICE_TRANSFORM' LIMIT 1)"
]
}
06/28/2024 08:28 PM
There is no mapping in Wd JSON it should not add. In user history ideally to narrow down remove preprocessor and try if user history still shows manager field
08/04/2024 07:43 PM
Am using the same connector to import users from workday, have you configured the incremental import in this ,to bring last 24hrs users create/update operation in saviynt..?