Inconsistent REST behaviour.

[DaveF]

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:

http://jira.hk.xxx/rest/api/2/project/PLR/versions
http://jira.hk.xxx/rest/api/2/project/FIT/versions
https://jira.hk.xxx/rest/api/latest/issue/PLR-3933
https://jira.hk.xxx/rest/api/latest/issue/FIB-14736

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.

[Dario B · Accepted solution]

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 http://jira.hk.xxx/rest/api/2/project/PLR/versions


curl -D- -u USERNAME:PASSWORD  -H "Accept: application/json" -H "Content-Type: application/json" -X GET https://jira.hk.xxx/rest/api/latest/issue/PLR-3933

Best Regards,
Dario
Atlassian Cloud Support

[DaveF]

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

Dave

[Dario B]

Hi Dave,

This sounds definitely like a permission problem. 

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

Best Regards,
Dario
Atlassian Cloud Support

[DaveF]

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:  https://www.youtube.com/watch?v=jGvmmjVUKuM

Kind regards

Dave

[Dario B]

Nice to hear so @DaveF :) 

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

Have a nice day!

Dario