To take information from the email description and incorporate it into the issue summary

jira_admin_cu

Hi Team,

We have a requirement using email handlers.

In the email, we will receive information about the "Vendor Name" and the "Order No." The subject of this email is always "You have 1 new document(s)." When creating a ticket using the email handler, it doesn't make sense to have an unclear ticket summary. Therefore, we would like to copy the "Vendor Name" and the "Order No" from the email description to the ticket summary. Is it possible to achieve this using ScriptRunner?

You can see how the email body looks in the email in the attached screenshot for reference.

Ram Kumar Aravindakshan _Adaptavist_

Hi @jira_admin_cu

Using ScriptRunner's Mail Handler, this is pretty simple. You will just need to filter the content of the message body.

Below is a sample working code for your reference:-

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.service.util.handler.MessageUserProcessor
import com.atlassian.mail.MailUtils

final def username = 'admin'
final def projectKey = 'MOCK'
final def issueTypeName = 'Bug'

def userManager = ComponentAccessor.userManager
def projectManager = ComponentAccessor.projectManager
def issueFactory = ComponentAccessor.issueFactory
def messageUserProcessor = ComponentAccessor.getComponent(MessageUserProcessor)

def user = userManager.getUserByName(username)
def project = projectManager.getProjectByCurrentKey(projectKey)

def issueReporter = messageUserProcessor.getAuthorFromSender(message) ?: user
def messageBody = MailUtils.getBody(message)

if (messageBody.contains('Order No') && messageBody.contains('Vendor Name')) {
    def subject = new StringBuilder()

    messageBody.eachLine { line ->
        if(line.contains('Vendor Name')){
            subject.append(line).append(',\t')
        } else if(line.contains('Order No')){
            subject.append(line)
        }
        line
}

    def issueObject = issueFactory.issue
    issueObject.setProjectObject(project)
    issueObject.setSummary(subject.toString())
    issueObject.setIssueTypeId(project.issueTypes.find { it.name == issueTypeName }.id)
    issueObject.setReporter(issueReporter)
    messageHandlerContext.createIssue(user, issueObject)
}

Please note that the sample working code above is not 100% exact to your environment. Hence, you must modify the code accordingly.

Below are the screenshots of the Mail Handler configurations:-

Below is the sample email that is tested:-

And below is a sample of the output that is produced:-

I hope this helps to answer your question.

Thank you and Kind regards,
Ram