It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Google Code to connect Google Sheet with JIRA API KEY

 

Greeting, I was using "mylittleblue" script to push GSheet information into a Jira Ticket, but since July 2019, this methoud are in "phase out". How can i convert this method to the new API KEY method ?  (here bellow what i'm using)

 

 

 

var username = "myemailadress@mydomain.ca"
var password = "pw"
var CloudIdKey = "myapikeygeneratedfromjira"
var UserCredentials = username + ":" + CloudIdKey;
var headers =
{
"content-type": "application/json",
"Accept": "application/json",
"authorization": UserCredentials
};

//
// A final few options to complete the JSON string
//
var options =
{
"content-type": "application/json",
"method": "POST",
"headers": headers,
"payload": payload
};

//
// Make the HTTP call to the JIRA API
//
var response = UrlFetchApp.fetch(url, options);
Logger.log(response.getContentText());
//

1 answer

0 votes
Dario Atlassian Team Oct 08, 2019

Hi @ERIK GAUDIN ,

As written in the Deprecation of basic authentication with passwords for Jira and Confluence APIs:

Atlassian Cloud sites have introduced support for API tokens to replace Atlassian account passwords for all Jira and Confluence APIs.

In other words: Basic Authentication with username and password has been replaced by Baisc authentication with email address and API tokens.

 

Therefore, it is just enough to replace the username with the email address and the password with an API token in your script in order to have it working as before.

 

For further details please see:

 

 

Cheers,
Dario

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira

Demo Den Ep. 7: New Jira Cloud Reports

Learn how to use two new reports for next-gen projects in Jira Cloud:  Cumulative flow diagram and Sprint burndown chart. Ivan Teong, Product Manager, Jira Software, demos the Cumulative ...

342 views 1 3
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you