Write an automation rule to get a Hiring Manager information from Description Field

[sharos.pillai]

Hi there, I have an issue with description field.

I want to take the value of Hiring Manager: John Smith from the description field and assign this issue to the hiring manager.  In this example , it will be John Smith.

Any suggestions on how I can achieve this?

Thanks

SP

[Piyush Annadate _ACE Pune_]

Hi @sharos.pillai ,
If your description have 'Manager' details, then you can use regular expression to get that information. 
Ref. https://support.atlassian.com/cloud-automation/docs/jira-smart-values-text-fields/

Example I've below data in description:

Title: Onboarding Request 
Hiring Manager: Piyush Annadate 
Status: In Process 

With above, I will use automation to extract Hiring manager name value, i.e. create a variable and have the value as below: 

{{issue.description.substringBetween("Hiring Manager: ","\n")}}

Once you get the above, then you have to DO a web request to fetch the correct user matching the display name. Below will result all the matching users as Piyush Annadate, eventually it search for all users having Piyush. You have to perform a iteration to match the exact. 

/rest/api/2/user/search?query=Piyush%20Annadate

[sharos.pillai]

Hi Piyush,

Position Title: Production Assistant

Hiring Manager: Tara Jacobs

Department: Program

The match did not work.

Thanks

SP

[Bob Dalm]

{{issue.description.match("Hiring Manager:(.*)")}}

[Bob Dalm]

Hi @sharos.pillai , 

Using automation; 

1. Fetch the hiring manager:
   • https://support.atlassian.com/cloud-automation/docs/jira-smart-values-text-fields/#match--
   • It would look something like this; {{issue.description.match("Hiring Manager:(.*)")}}
2. Store this to a variable, do a log action to ensure you get the right value. 
3. Add a web request action using the Jira API; https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-user-search/#api-rest-api-3-user-search-query-get
   • More info on web requests through automation here: https://community.atlassian.com/forums/Jira-articles/Automation-for-Jira-Send-web-request-using-Jira-REST-API/ba-p/1443828
4. Use the output in an Edit issue action to update the assignee.