Click HERE to see how Saviynt Intelligence is transforming the industry. |
08/09/2024 03:50 AM
Hi,
We are trying to create dynamic attribute based on calculated account name in ARS request.
When requests is raised account name is calculated using endpoint's 'Account name Rule'.
What attribute we should we use in SQL query for dynamic attribute?
We started with this query (relevant part only)
select case when ${acctype} = 'Standard Admin' then ${account}
Kind regards,
Piotr
Solved! Go to Solution.
08/09/2024 06:11 AM
08/09/2024 07:43 AM
Thank you Rushikesh. I'm not sure you understand what we're trying to achieve. We have account naming rule that calculates account name as shown in the screenshot above. We then would like to use this calculated account name in the dynamic attribute SQL query.
Kind regards,
Piotr
08/09/2024 08:12 AM
Thats not supported
08/09/2024 08:43 AM
Thank you, we'll use query then.
08/09/2024 08:08 AM
Hi @piotrj , I don't think so you can refer it in other dynamic attribute.
What you can do is construct an SQL query in dynamic attribute.
08/09/2024 08:42 AM
Thank you, that's what we're going to do. I was trying to simplify thnings!
08/09/2024 08:45 AM
If you found the response please accept the solution and click on kudos button
Thanks 🙂
09/26/2024 04:12 AM
09/26/2024 04:16 AM
Hi @hareeshreddyk it's not supported you can use it in other DA
10/09/2024 01:18 AM
Hli @NM, So Can not we use the generated Account Name value in the Connection?
I have tried with "accountsObj?.accountID" to get the "Account Name" value in into target from AddaccessJSON it was successfull,
\"username\": \"${requestAccessAttributes.get('ACCOUNTTYPE') == 'Service Account'? accountsObj?.accountID
but in CreateaccountJSON the same "accountsObj?.accountID" did not work.
Requirement is to get the "Account Name" value into target. So what would be the variable in CreateAccountJSON, AddaccessJSON?
So how can i achieve this?