MODIFYUSERJSON for LDAP connection

[prachi]

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?

[adarshk]

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. 

[prachi]

HI,

I am trying to hard code the value in USER_IMPORT JSON but it is giving error :

{EMPLOTEETYPE::'Internal'#String}

[adarshk · Accepted solution]

Try this: 
employeeType::Internal#SavData

[prachi]

Thanks this is working!!