Workflow Keyword switching from Realname to Username

[Mandi_Payton]

I have Unity Form in which I need to display realname to the users.  They choose a person and that is saved as a keyword.  I need to then switch this 'realname' keyword to a username so that I can send a notification to the username later in the workflow.  Please help.

[Scott_Johnson3]

Hi Mandi

I use an Unity script external autofill that does and simple LDAP query on an real name to get account and emails.

Good Luck 

[Rafael_Aguilar]

Could you please provide this simple query to use as an example? There isn't much documentation about this particular topic. 

[Kevin_Gassert]

create an external autofill and run it in workflow. The external query would be.

select realname, username from hsi.useraccount 
where username not like '%deactivated%'
and realname = '@primary'

you could add email address if you want that as a keyword or can just use the username for the notification