Hi team,
I am trying to use dynamic attribute in UPDATEACCOUNTJSON for a DB connection, but after updating the dynamic values the UPDATEACCOUNTJSON is picking it up as NULL.
I am attaching the UPDATEACCOUNTJSON and the queries used for dynamic attribute.
I have already referred --Various Usage of Dynamic Attributes - Saviynt Forums - 37329
Below are the queries configured for the dynamic attributes in the end points these queries return the expected values when verified from Data Analyzer.
1.SurrogateOwnersAMAccountName
SELECT m.customproperty3 as ID FROM users AS u JOIN users AS m ON u.customproperty50 = m.username WHERE u.userkey =${requestee}
2. SurrogateOwnerDisplayName
SELECT m.customproperty19 as ID FROM users AS u JOIN users AS m ON u.customproperty50 = m.username WHERE u.userkey =${requestee}
3. SurrogateOwnerADDN
SELECT m.customproperty11 as ID FROM users AS u JOIN users AS m ON u.customproperty50 = m.username WHERE u.userkey =${requestee}
4. LineManagerFullName
SELECT m.displayName as ID FROM users AS u JOIN users AS m ON u.customproperty50 = m.username WHERE u.userkey =${requestee}
5. LineMangerEmailAddress
SELECT m.email as ID FROM users AS u JOIN users AS m ON u.customproperty50 = m.username WHERE u.userkey =${requestee}
Below is the UPDATEACCOUNTJSON configured in the connection --
{ "UpdateAccountQry": [ "USE [SQLD0227Q]", "EXEC [sp_ICM_UpdateUserFromSaviynt] @ICM_Case_ID = '${user.customproperty16}', @Manager_Name = ${requestAccessAttributes.get('LineManagerFullName')}, @Manager_Email_Address = ${requestAccessAttributes.get('LineMangerEmailAddress')}, @Surrogate_Owner = ${requestAccessAttributes.get('SurrogateOwnersAMAccountName')}, @Approver_Name = ${requestAccessAttributes.get('SurrogateOwnerDisplayName')}, @Approver = ${requestAccessAttributes.get('SurrogateOwnerADDN')}}" ] }
