nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

{"errorMessages":["Issue does not exist or you do not have permission to see it."],"errors":{}}

Vivek K_c63ap3

Hello Team,

I am using VBA code to get the issues from JIRA. But I am getting the error

{"errorMessages":["Issue does not exist or you do not have permission to see it."],"errors":{}}

Note working fine in Postman using Basi-Auth (Email and API token)

Username - vxxxx@gmail.com
APITOKEN = APITOKEN

Set JiraService = CreateObject("WinHttp.WinHttpRequest.5.1")
UserNamePQ1 = UserPassBase64

With JiraService
sURL = "https://<<JiraName>>.atlassian.net/rest/api/3/issue/KAN-8"

.Open "GET", sURL
'.SetRequestHeader "Content-Type", "application/json"
'.SetRequestHeader "Accept", "application/json"
.SetRequestHeader "Authorization", "BasicAuth Username:APITOKEN"
.SetRequestHeader "Content-Type", "application/json"
.Send

JiraService.ResponseText

End With

Accepted answers

All comments

Nic Brough -Adaptavist-

Welcome to the Atlassian Community!

This is most likely to be down to the user that you are using to log in and issue the commands not having the permission to see or work with the issue you are trying to use.

Dag Atle Stenstad

Hi @Vivek K Are you sure you have authenticated yourself?
Logging in requires encoding the username and Token to Base64.

.setRequestHeader "Authorization", "Basic " & EncodeBase64(strAtlassianEmail & ":" & strAtlassianToken)

The function below requires that you add "Microsoft XML, v 3.0" under Reference (Tools->Reference)

Private Function EncodeBase64(text As String) As String
   Dim arrData() As Byte
   arrData = StrConv(text, vbFromUnicode)

   Dim objXML As MSXML2.DOMDocument
   Dim objNode As MSXML2.IXMLDOMElement

   Set objXML = New MSXML2.DOMDocument
   Set objNode = objXML.createElement("b64")

   objNode.DataType = "bin.base64"
   objNode.nodeTypedValue = arrData
   EncodeBase64 = Replace(objNode.text, vbLf, "")

   Set objNode = Nothing
   Set objXML = Nothing
End Function

Nic Brough -Adaptavist-

Yes, that was my point

Dag Atle Stenstad

Did the code example work for you?

Nic Brough -Adaptavist-

Yes, when I use a user who has the right permissions.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

rest-api

jira-cloud

authentication