Hey, Im trying to integration Google sheet to integration with JIRA using Google App script to count for a given JQL. in some forum mentioned that i will get
response like below:
{"expand":"schema,names","startAt":0,"maxResults":50,"total":29521,"issues":[]}
But, for the same
URL https://abc.com/rest/api/2/search?jql=project in (MOBILEDEV)
I'm getting response as expected in browser but not in Google app response.
var headers = {"Accept":"application/json", "Authorization": UserCredentials};
var options = {"method":"GET", "contentType" : "application/json", "headers": headers,"payload" : "payload" };
var response = UrlFetchApp.getRequest(IssueURL, options);
Logger.log(response);
any hep appreciated.
Thanks.
Shiva
Thanks but I want the counts out of JQL result, I don't want the details of the JIRA tickets.
I have learned that, we have to use var resp = UrlFetchApp.fetch(IssueURL, options); instead of getRequest but fetch throws bad request exception.
any help appreciated.
Thanks
S