Hardcode user attribute during import

[asp]

Hi all,

We are setting up a user import for contractors from AD from a special OU and would need to hardcode the 'employeeclass' to map to 'Contractor'. What is the correct syntax for the userimportjson for this? Or is this something that we would need a inline preprocessor? 

[rushikeshvartak]

You can perform from a preprocessor.

[NM]

Hi @asp if you have a attribute in AD which stores a contractor value.

You can directly map it to emoloyeetype attribute in saviynt.

[asp]

Its not set on any AD attribute. Basically, we are pulling from a special OU. Everyone in that OU, is  a contractor. So, is inline preprocessor my only option? I can't set just the employeeclass directly to 'Contractor' in the 'user_attribute' json for the connection?

[NM]

@asp then no, you have to use preprocessor.

[asp]

Ok..so just something like this - 

{"ADDITIONALTABLES":{"USERS":"SELECT USERKEY FROM USERS"},
"COMPUTEDCOLUMNS":["employeeclass"],
"PREPROCESSQUERIES":["UPDATE NEWUSERDATA SET employeeclass = 'Contractor'"]}

Thank you @NM  and @rushikeshvartak , appreciate all the help. 

[rushikeshvartak]

Yes but add where clause to make sure its added only for contractor users.

[NM]

@asp update query so that it only runs for contactor and not other ID, otherwise it will hamper the system.

[asp]

Oh yes, good catch!

[rushikeshvartak]

✅Please click the 'Accept As Solution' button on the reply (or replies) that best answered your original question and hit 'Kudos' button 👍.