Google sheet & JIRA integration using Google App script

[ku ku Shiva]

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

[ryry]

I used the API and this app to connect the two

[ku ku Shiva]

Thanks but I want the counts out of JQL result, I don't want the details of the JIRA tickets. 

[ku ku Shiva]

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