Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,359,951
Community Members
 
Community Events
168
Community Groups

How can I get data from an external api, and fill out "new issue" fields with that data.

Hello,

I'm trying to do the following:

Create a new ticket in JIRA, and pull data from an external API, using that data to fill out the new JIRA issue fields.

 

This is because we use a separate helpdesk system, and our users need to pull those external helpdesk tickets and place them in JIRA to use them in their sprint.

 

The way I think I'd like it to work is to have a "helpdesk ticket ID" field in the new issue screen, and a button to "pull data now". That button would initiate a REST API call, passing in the helpdesk ticket ID as a parameter, and then place the details from the ticket into various fields, such as the description field.

 

I've been playing with scriptrunner to do this, and can't seem to figure it out. I have managed to make a test REST API call from the script console using this code I found:

 

private static get(String url) {
def connection = url.toURL().openConnection()
connection.addRequestProperty("Authorization", "Basic ${authString}")
 
connection.setRequestMethod("GET")
connection.doOutput = false
connection.connect()
connection.content.text

}

 

I can't figure out the following:

1. How to initiate this script based on a user clicking a button

2. How to do something with the data when it comes back.

 

 

Thanks for any help anyone can provide.

 

Dan

2 answers

Hi @Dan Conroy ...were you able to get this working? I am trying to accomplish a similar functionality. 

 

Thank you

+1, looking for exactly the same

Update: as I'm working through this, I've managed to get a scriptrunner groovy script to trigger based on clicking the Update button for an issue. I can get that to pull a value from a REST api call, and then display that output in a notification using the script below.

(The rest api call is just an easy example to prove I get data back)

 

Now I'm trying to figure out how I can SET the value of the "Description" field, with the output of my REST call.

 

Can anyone point me in the right direction for how to set the description field?

 

 

import com.onresolve.scriptrunner.runner.util.UserMessageUtil
import com.atlassian.jira.issue.Issue
import com.atlassian.jira.issue.CustomFieldManager
import com.atlassian.jira.issue.fields.CustomField
import com.atlassian.jira.ComponentManager
import com.atlassian.jira.issue.customfields.option.LazyLoadedOption

    private static get(String url) {
        def connection = url.toURL().openConnection()
        connection.setRequestMethod("GET")
        connection.doOutput = false
        connection.connect()
        connection.content.text
    }


def output = get('https://api.macvendors.com/8c8590')


UserMessageUtil.success("Output:" + output)

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira

Online AMA this week: Your project management questions answered by Jira Design Lead James Rotanson

We know that great teams require amazing project management chops. It's no surprise that great teams who use Jira have strong project managers, effective workflows, and secrets that bring planning ...

179 views 1 6
Read article

Atlassian Community Events