How to send user manager displayname and request approver name in create account json in DB

[sudheera]

Hi, 

We need to send user manager displayname not the userkey and request approver displayname in create/ update account query for DB connection.

Provide any solution to send the attributes in query.

[rushikeshvartak · Accepted solution]

Share current JSON

for manager displayname 

${user?.manager?.displayName} or ${usersManagerObj?.displayName}

You can't fetch request approval 

https://docs.saviyntcloud.com/bundle/EIC-Connectors/page/Content/Binding-Variables-for-Provisioning-... 

[sudheera]

${usersManagerObj?.displayName} it is worked.

And is there any logic to create dynamic attribute to fetch the username who had approved the request and send in json, in case if the approver is not the manager.

current json:

"insert into NPIT_USERS (USERID, DISPLAYNAME, EMAIL, INACTIVE, APPROVER_NAME, JOBTITLE, MANAGER) Values ('${user.username}','${user.lastname+', '+user.firstname}','${user.email}', '0', '${usersManagerObj?.lastname+', '+usersManagerObj?.firstname}', '${user.title}', ' ${usersManagerObj?.username}')"

[NM]

Hi @sudheera , DA comes into picture only at the time of submitting the request you can't have SQL query to fetch the details.

Approves happen after request submission and approval page..

[stalluri]

@sudheera 
Try this out
${managerAccount?.displayName}

[NM]

Hi @sudheera try this 

${usersManagerObj?.displayName}