Click HERE to see how Saviynt Intelligence is transforming the industry. |
06/17/2024 08:26 AM
Hi Team,
We have below scenario for preprocessor.
User data comes from workday with 50K users and it contains both email and with out email users.
I have custom jar to generate email. I am using Modify user Json and it is working.
Question: How to restrict users to pass only who don't have email id instated of sending all 50K users to the custom Jar to validate and generate email id.
I tried this logic.
Modify User Json:
{
"ADDITIONALTABLES": {
"USERS": "SELECT email,CUSTOMPROPERTY21 from USERS"
},
"COMPUTEDCOLUMNS": [
"customproperty1",
"customproperty21",
"email"
],
"PREPROCESSQUERIES": [
"UPDATE NEWUSERDATA SET customproperty1= CASE WHEN (NEWUSERDATA.EMAIL IS NULL and NEWUSERDATA.EMPLOYEETYPE='F' and NEWUSERDATA.ORGUNITID='Contract') then 'MODIFY USER needed2' ELSE 'no update needed' END",
"CUSTOMFUNCTION###FUNCTION1"
],
"CUSTOMFUNCTIONS":{
"FUNCTION1":{
"FULLCLASSNAME":"com.saviynt.custom.emailFormatter",
"METHODNAME":"formatEmail"
}
}
}
06/17/2024 10:01 AM
Hi @srikanth1202 , in custom jar are you calling rest API to get those user entries? Can you share jar and elaborate more the case.
You can do a get call to get those users and check if they have email already present or not ..
Don't think we can restrict on number of users to be passed in function.
06/17/2024 10:28 AM
It is simple Java logic to to generate email id based on first name and last name with the condition checking of alias stored in one of the custom property. Due to the restriction I am unable to share the code here.
question was can pass users only who don't have email id to the custom Jar?
06/17/2024 10:13 AM
Try making function as parameterized
06/17/2024 10:29 AM
you mean here,
"CUSTOMFUNCTIONS":{
"FUNCTION1":{
"FULLCLASSNAME":"com.saviynt.custom.emailFormatter",
"METHODNAME":"formatEmail"
}
if Yes, can you please provide an example
06/17/2024 06:59 PM
I dont have example. and I know its not supported but you can give try
06/27/2024 06:16 AM
Thank you. It is not supported.
06/27/2024 06:26 AM
Please submit idea ticket for enhancement