Google Code to connect Google Sheet with JIRA API KEY

ERIK GAUDIN

 

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());
//

Dario B

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:

• Deprecation notice - Basic authentication with passwords and cookie-based authentication
• Deprecation of basic authentication with passwords for Jira and Confluence APIs
• API tokens

 

 

Cheers,
Dario