Click HERE to see how Saviynt Intelligence is transforming the industry. |
09/04/2022 02:29 AM
Hello,
I've been trying to implement a usecase, while importing users from CSV, the users whos username, employeeid, location is null or empty don't get onboarded, I configured the User Pre-processor Config JSON as below, but it's not working as expected.
{ "COMPUTEDCOLUMNS": [ "USERNAME" ], "PREPROCESSQUERIES": [ "delete from NEWUSERDATA where username is null or username=''", "delete from NEWUSERDATA where employeeid is null or employeeid=''",
"delete from NEWUSERDATA where location is null or location =''" ], }
I tried every version of this with different attributes / queries and computed columns but still its isn't working, I am not sure what am I missing, Could you guys please advise what could be the issue here.
Thanks.
09/04/2022 05:17 AM
You are trying delete queries in
PREPROCESSQUERIES
09/04/2022 05:37 AM
thank you for responding, so does delete queries do not work in PREPROCESSORQUERIES ?
Is there any way to achieve the above usecase?
09/04/2022 07:34 AM
You can use Custom JAR
09/04/2022 08:10 AM - edited 09/04/2022 08:11 AM
Will it work for CSV?, if Yes, can you please help with a sample
09/04/2022 11:36 AM
https://forums.saviynt.com/t5/identity-governance/preprocessor-jar-file/m-p/11707#M3365