Inconsistent REST behaviour.

Trying to get familiar with REST calls and require some assistance. The problem that I am facing is different behavour in two different projects on the same instance when called from two different environments on my local machine.

Looking at the following calls:

When I make the calls in Chrome data is returned, however when I run via VBA in Excel (2010) using the WinHTTP library The calls to FIT succeed while the calls to PLR fail.

I get different errors for the calls in Excel:

When I call for projects the error is "No project could be found with key 'PLR'."
When I call for a single PLR issue the error is "You do not have the permission to see the specified issue.
Login Required"

It feels like the difference is at the project level but I'm at a loss as to where to check.

1 answer

1 accepted

0 vote

Hi Dave,


How are you authenticating the REST calls you run via VBA? Are you using the same credentials you use to log-into the UI? 

I am asking this because from the error message this seems to be a permission issue and the account used in VBA has no rights to see project PLR.

Also, can you reproduce the issue by using Curl?

curl -D- -u USERNAME:PASSWORD  -H "Accept: application/json" -H "Content-Type: application/json" -X GET

curl -D- -u USERNAME:PASSWORD  -H "Accept: application/json" -H "Content-Type: application/json" -X GET

Best Regards,
Atlassian Cloud Support


Hi Dario,

Thank you for your reply, in my test case I'm not authenticatiing in either case.  If I do authenticate it makes no difference to the outcome.

If I make the call to the "FIT" project everything is fine no matter how many times I make the call. Even if I call "PLR" directly after the "FIT" calls they fail. I can immediately go back to "FIT" and the call works.

The calls also both work in in Chrome but not from VBA.

Kind regards



Hi Dave,

This sounds definitely like a permission problem. 

Please open a support request in to have this issue further investigated.

Best Regards,
Atlassian Cloud Support

Dario you were absolutely correct. In hindsight it is obvious that my cedentials were being held in in the browser. 

I finally found out how to authenticate in VBA in this youtube viedo:

Kind regards


Nice to hear so @Dave Fisher :) 


Please mark this question as resolved and, if you like to, vote for my answer.


Have a nice day!


Suggest an answer

Log in or Join to answer
Community showcase
Alexey Matveev
Published Saturday in Jira

How to run Jira in a docker container

Everything below is tested on Ubuntu 17.10. I prefer to use Jira in a docker container because: 1. I can install Jira with a couple of commands. 2. I can start and stop Jira just by starting and s...

89 views 2 4
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot