Unable to set a custom user picker field with email address using automation for jira plugin

Question

I've been testing and searching for a way to set a custom user picker field with email address using automation for jira plugin via Edit Issue action > Additional fields window as follows without success:

1)

{
"fields": {
"mycustom_user_picker": {"emailAddress": "{{blah@blah.com}}"}
}
}

2)

{
"update": {
"mycustom_user_picker": [{
"set": {"emailAddress": "{{blah@blah.com}}"}
}]
}
}

Both #1 and #2 above will give me success status after running the automation rule but "mycustom_user_picker" will still show empty.

However, if I paste blah@blah.com in "mycustom_user_picker" field in the Jira issue edit screen it will autocomplete and populate the fullname of Mr. Blah.

Any suggestions on how to set custom user picker field with email address using automation for jira plugin please?

Paul Benati · Answer

FWIW, I too need this capability.  In my use case, I'm receiving a string from an external system (Salesforce) representing the email address of an employee.  I'd like to leverage that string and Automation for Jira to populate a People custom field in a JSM Next Gen project.

Thanks,
Paul

Victor Seger_82gbv0 · Answer

Hi @Arnel Burlayan ,

I just saw the ticket that Yvan helped you with.

Currently, the best is to wait for the AUT ticket to be implemented. Although it might take some time to be ready, it will give you a most optimized solution to your scenario.

Let me know if you got any further questions.

Cheers,

Victor

Arnel Burlayan · Answer

Hello @Victor Seger

Thank you for your response. I actually raised a case with code barrel support (CBS-16664) and has been advised that my use case is not supported at this stage and it is in their backlog (AUT-725 ) to fix this in the future. I'm hoping that it's in the very near future.

So, to answer your questions:

- Yes, that is correct, I am trying to populate a custom user picker field using an email address.

- To elaborate further so you'll have a idea of our use case...here's what I've written in the code barrel case:

========================

I am using the Advanced JSON Edit because my use case is different.

We are using email ingestion to populate the fields automatically by parsing both Summary and Description Fields of the ticket created.

So, my rule is basically

* When issue is created -> parse the summary and description fields using the if/else block condition and regex -> edit ticket with "set" on all the fields involve.
* Few different types of custom fields, ie. date and time pickers, radio buttons, select lists(both single and multi-select ), text and user picker fields
* I only have a problem with setting up the user picker fields because our requirements changed where we don't have the user id or user name. We only have the email address.
* I am aware that I can get the name, displayName and emailAddress attributes of the user picker fields but only when the user picker fields are set or populated (I've been using this solution on most of my rules)
* Using the username to set the user pickers fields works perfectly fine but as I've mentioned above, our requirements have changed.

========================

I've been googling and found this: https://community.atlassian.com/t5/Marketplace-Apps-Integrations/Get-JIRA-username-from-email/qaq-p/597381

I know that Automation for Jira can run a Scriptrunner as an action.

But no success yet unfortunately.

Also, I was looking at hitting the API directly using the following search but it will take more time for me to craft a code that would parse the returned results where email address search would return a couple of users (e.g. email address associated to a couple of users). But a username/id is unique hence I guess most Jira and/or plugins support the lookup only by username/id and not email address.

http://localhost:8080/rest/api/2/user/search?username=blah@blah.com&includeActive=true&includeInactive=false

Any suggestions how to get this to work please?

Best regards,
Arl B.