User Pre-processor Config JSON not working as expected

[nomaaaaaan]

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. 

[rushikeshvartak]

You are trying delete queries in 

PREPROCESSQUERIES

[nomaaaaaan]

thank you for responding, so does delete queries do not work in PREPROCESSORQUERIES ?

Is there any way to achieve the above usecase?

[rushikeshvartak]

You can use Custom JAR

[nomaaaaaan]

Will it work for CSV?, if Yes, can you please help with a sample

[rushikeshvartak]

https://forums.saviynt.com/t5/identity-governance/preprocessor-jar-file/m-p/11707#M3365