Saviynt unveils its cutting-edge Intelligence Suite products to revolutionize Identity Security!
Click HERE to see how Saviynt Intelligence is transforming the industry.
Saviynt Copilot Icon

HANA UPDATEUSER Json with user attribute logic

praveen_naik
New Contributor II
New Contributor II

Hi Team,

We have HANA conneciton to provison users and access, we need to maintain JWT attribute at HANA system. JWT provider based on employee type needs to be updated. 

We tried below logic, but task is not getting processed. 

{
if (user.employeeType) == 'A' {
UpdateAccountQry: [
"ALTER USER ${accountName} SET PARAMETER EMAIL ADDRESS = '${user.email}'",
"ALTER USER ${accountName} ADD IDENTITY ANY FOR JWT PROVIDER ###############",
"ALTER USER ${accountName} ENABLE JWT"
]
}else{
UpdateAccountQry: [
"ALTER USER ${accountName} SET PARAMETER EMAIL ADDRESS = '${user.email}'",
"ALTER USER ${accountName} ADD IDENTITY '${user.email}' FOR JWT PROVIDER ###########",
"ALTER USER ${accountName} ENABLE JWT"
]
}
}

 

 

If we pass below without employee type condition, it works fine.

{

UpdateAccountQry: [
"ALTER USER ${accountName} SET PARAMETER EMAIL ADDRESS = '${user.email}'",
"ALTER USER ${accountName} ADD IDENTITY '${user.email}' FOR JWT PROVIDER ###########",
"ALTER USER ${accountName} ENABLE JWT"
]


}

Please let us know how we can handle logic based on employeeType. 

 

Thanks,

Praveen

2 REPLIES 2

prtkrh007
Saviynt Employee
Saviynt Employee

What is the Error in the logs?

rushikeshvartak
All-Star
All-Star

Use below

{
"UpdateAccountQry": [
"${if(user.employeeType == 'A') { " +
"'ALTER USER ' + accountName + ' SET PARAMETER EMAIL ADDRESS = \"' + user.email + '\"; ' + " +
"'ALTER USER ' + accountName + ' ADD IDENTITY ANY FOR JWT PROVIDER ###########; ' + " +
"'ALTER USER ' + accountName + ' ENABLE JWT;' " +
"} else { " +
"'ALTER USER ' + accountName + ' SET PARAMETER EMAIL ADDRESS = \"' + user.email + '\"; ' + " +
"'ALTER USER ' + accountName + ' ADD IDENTITY \"' + user.email + '\" FOR JWT PROVIDER ###########; ' + " +
"'ALTER USER ' + accountName + ' ENABLE JWT;' " +
"} }"
]
}


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.