and more in a single search tool across platforms. Read the announcement here. |
10/19/2023 12:36 AM
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.
Preprocessor Query:
{
"ADDITIONALTABLES": {
"USERS": "SELECT USERKEY,username,customproperty30,departmentname,customproperty17,status FROM USERS"
},
"COMPUTEDCOLUMNS": [
"departmentname",
"statuskey"
],
"PREPROCESSQUERIES": [
"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
10/20/2023 08:58 AM - edited 10/20/2023 08:58 AM
You will need to use User Import via a Connection (UserImportJob). What is the issue you are facing with this job. Can you elaborate.
10/22/2023 06:23 PM
What are current limitation hence you choose to go with workaround ?