Jira API Not Working From Google Script

Question

I have a Google Script running as part of Sheet that fetched some tickets from out Jira board using basic authentication and JQL.

The JQL works perfectly fine when run from command line via curl (ubuntu) but shows the following error when executed from Google Script -

{"errorMessages":["Field 'assignee' does not exist or this field cannot be viewed by anonymous users."],"errors":{}}

This is how I'm making the curl request -

curl -H "Authorization: Basic <base64 encoded username:password>" -X GET -H "Content-Type: application/json" https://<jira_host>.com/rest/api/2/search?jql=<JQL>

and this is how I'm doing it form Google Script -

var url = encodeURI(host + 'rest/api/2/search?jql=' + jql);
var params = {};
params['header'] = {'Authorization': PropertiesService.getUserProperties().getProperty('AUTH')};
params['Content-Type'] = 'application/json';
params['Accept'] = 'application/json';
params['method'] = 'GET';
params['muteHttpExceptions'] = true;
var response = UrlFetchApp.fetch(url, params);

I referred JIRA Basic Authentication guide's CAPTCHA section to see if I'm being denied authentication but I confirmed that this is not the case by verifying response headers.

I'm not sure what am I doing incorrectly to cause this error. Any help is appreciated.

Thanks.

Harshil Sharma · Accepted Answer · 2016-09-12 08:25:29Z

2

I solved it myself. It was a typo.

params['header'] = {'Authorization': PropertiesService.getUserProperties().getProperty('AUTH')};

Fixed to

params['headers'] = {'Authorization': PropertiesService.getUserProperties().getProperty('AUTH')};

Notice that it is 'headers' not 'header'.

answered Sep 12, 2016 at 8:25

Harshil Sharma

2,0454 gold badges30 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

rorschach · Accepted Answer · 2016-08-31 17:55:18Z

0

The most probable answer is that the jql parameter isn't properly encoded. Switch to the POST method and try it that way.

answered Aug 31, 2016 at 17:55

rorschach

2,9571 gold badge20 silver badges20 bronze badges

Collectives™ on Stack Overflow

Jira API Not Working From Google Script

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related