REST API works fine in browser, but not in Excel

[Paul Haubold]

I'm trying to fetch some data via the REST API of out Jira Server. When I type in the URL "https://<jiraserver>/rest/api/latest/search?jql=status=done" everything works fine and I see the json results with the following fields:

"expand":"schema,names",

"startAt":0,

"maxResults":50,

"total":40432,

"issues": list full of items

But when I try to get these data via the Power Query in Excel with the same URL I get an empty list. I only get the fields "startAt=0", "maxResults": 50, "total": 0, "issues": empty list

Does anyone know why? 

[Neil Mansilla]

Perhaps it's a permissions issue. When you make the call from your browser, the request is authenticated using your session cookies. If you're making the call through another client, you'll need to pass your credentials in the request with basic auth. How are you providing your credentials for the API call made from Excel?

NOTE: Please be certain not to paste any of your credentials here. 

[Deleted user]

I have the exact same issue.  I created a token and passed "Bearer <Token>" in the Authorization header of the GET request - and I can see from my personal settings that the token is being accessed.  But it returns a 400 error through the API with response text {"errorMessages":["Issue does not exist or you do not have permission to see it."],"warningMessages":[]}

but the same request through the browser returns a perfect result.

Help appreciated