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 = ""
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);

1 answer

0 votes
Dario B Atlassian Team Oct 08, 2019


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:




Suggest an answer

Log in or Sign up to answer

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