Click HERE to see how Saviynt Intelligence is transforming the industry. |
09/25/2024 12:26 AM - edited 09/25/2024 12:30 AM
Hi team,
On a user import from a workday connector (soap)
I would like to update the user custom attribut 1 and 2 with the following request in the preprocessor :
"UPDATE NEWUSERDATA LEFT JOIN CURRENTUSERS ON NEWUSERDATA.USERNAME = CURRENTUSERS.USERNAME SET NEWUSERDATA.statuskey = IF( NEWUSERDATA.customproperty2 = 1, 1, NEWUSERDATA.statuskey )",
"UPDATE NEWUSERDATA LEFT JOIN CURRENTUSERS ON NEWUSERDATA.USERNAME = CURRENTUSERS.USERNAME SET NEWUSERDATA.customproperty1 = IF( NEWUSERDATA.statuskey = 1, 'Onboarded', 'Terminated' );"
In the log view it's working as expected
Proceed to Import for records - > [ville, Regular, null, Gael, Gael, xxx,xxx,xxx,FR_GROUPxx,xx, gl.c@mail.com, gl.c@mail.com, null, FRA, Cxx, gl.c@mail.com, Gx Cxxx, xxxxx, Onboarded, Ville, IT, Support, All Product l, XXX_Group, xxx, Company, Group ,Product ,Support, xxxxr, 1, null] : true
i have the data i want , but in my user the CP1 and 2 is not update.
Do you have any clues to help me solve this problem?
Thanks in advance
Solved! Go to Solution.
09/25/2024 01:15 AM
Sorry it's working now :
Solution :
i forgot to put the Customproperty in the Table index current users
09/25/2024 05:33 AM
Please share full preprocessor JSON