Click HERE to see how Saviynt Intelligence is transforming the industry. |
03/06/2024 12:05 AM
Hi,
We have a LDAP connection, which we are using the import users.
I am trying to also have preprocessor query in import users in MODIFYUSERJSON which is :
{
"ADDITIONALTABLES": {
"USERS": "SELECT username,employeeType FROM USERS"
},
"COMPUTEDCOLUMNS": [
"employeeType"
],
"PREPROCESSQUERIES": [
"UPDATE NEWUSERDATA SET NEWUSERDATA.employeeType = 'Internal'"
]
}
but this is not working.
Any inputs/sugesstion on what could be wrong here?
Solved! Go to Solution.
03/06/2024 01:18 AM
Please use the below JSON. If you are testing it through CSV upload, make sure you have the json populated during import.
{
"ADDITIONALTABLES": {
"USERS": "SELECT username,employeeType FROM USERS"
},
"COMPUTEDCOLUMNS": [
"username,employeeType"
],
"PREPROCESSQUERIES": [
"UPDATE NEWUSERDATA SET NEWUSERDATA.employeeType = 'Internal'"
]
}
Per the query written here, if the requirement is to have employeeType for all the imported users mapped to 'Internal' then this can better be achieved from Import JSON(mappig employeeType to 'Internal') than introducing MODIFYUSERJSONDATA.
03/06/2024 01:39 AM
HI,
I am trying to hard code the value in USER_IMPORT JSON but it is giving error :
{EMPLOTEETYPE::'Internal'#String}
03/06/2024 02:52 AM
Try this:
employeeType::Internal#SavData
03/06/2024 03:36 AM
Thanks this is working!!