We have created a SavForSav Rest based connection to manipulate few data which is coming as a HCM CSV File to the File directory.
We have created a ModifyUserDataJson in the Connector however we are not able to trigger it properly.
We have tried the below cases however it didnt process:
1.We have created a Provisioning job without any Security System and tried to run
2.Created a User Import via a Connection (UserImportJob) however it didnt work as well.
"USERS": "SELECT USERKEY,username,customproperty30,departmentname,customproperty17,status FROM USERS"
"UPDATE NEWUSERDATA SET departmentname = CASE WHEN SIGN(LOCATE('-', customproperty30)) = 1 THEN SUBSTRING_INDEX(SUBSTRING_INDEX(customproperty30,'-',4),'-',-1) ELSE customproperty30 END",
"UPDATE NEWUSERDATA SET statuskey = CASE WHEN customproperty17='Active' THEN '1' ELSE '0' END"
Can anyone please let me know how to trigger the Rest Based SavforSav