Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

SavForSAV Rest for User Import through Schema Job

Souvik_Dey
New Contributor
New Contributor

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

2 REPLIES 2

SB
Saviynt Employee
Saviynt Employee

You will need to use User Import via a Connection (UserImportJob). What is the issue you are facing with this job. Can you elaborate.


Regards,
Sahil

rushikeshvartak
All-Star
All-Star

What are current limitation hence you choose to go with workaround ?


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.