Use Case:
How to restrict ModifyUserDataJSON of UserImport to only a set of users based on user conditions?
Application Version:
v2020.x and above
Pre - Requisite:
The user should have ROLE_ADMIN sav role to configure the User Import Connector
Solution:
The PREPROCESSQUERIES in ModifyuserdataJSON should include a where clause based on the data that needs to be modified with the preprocessor query.
Example : Customproperty45 needs to be updated with value 'Licensed Status' for users whose username begins with a36803. The below JSON can be used
{
"ADDITIONALTABLES":{"USERS": "SELECT username, CUSTOMPROPERTY45 from USERS'"},
"COMPUTEDCOLUMNS": ["CUSTOMPROPERTY45","USERNAME"],
"TABLEINDEXES": {
"currentusers": ["username"]
},
"PREPROCESSQUERIES": ["UPDATE NEWUSERDATA SET NEWUSERDATA.CUSTOMPROPERTY45 = 'Licensed Status' where NEWUSERDATA.username like 'a36803%'"]
}
