I have written a VBA script for Jira using the rest API.
I am using Basic auth for authentication. The script was working fine until 2 days back it started giving me 403 errors.
The script is running fine for other people it is only me who is getting this issue.
T see if I lost the access I also tested the API in the browser,
I tried with the browser(Talend API tester), it is working fine there. it's only in the VBA it is showing errors
Dim JiraService As New MSXML2.XMLHTTP60
Dim json As Object 'for parsing response to json
Dim IssueId As String 'for getting the issue-id from the user
IssueId = JiraIssue.IssueId.Value 'getting issue id from the user
'if issue id is not available exit the function
If IssueId = "" Then Exit Function
.Open "GET", "https://jira.name.com/rest/api/2/issue/" & IssueId, False
.setRequestHeader "Content-Type", "application/json"
.setRequestHeader "Accept", "application/json"
.setRequestHeader "Authorization", "Basic " & UserPassBase64
'if status 401 not authorized call method for login
If .Status = "401" Then
MsgBox "please Login" & vbNewLine & "invalid username/password"
If LoginForm.Visible = False Then
LoginForm.Show ' calling login pop-up box to get userid and password
'if issue does not exist
ElseIf .Status = "404" Then
MsgBox "issue does not exists", vbInformation, "Not Found" 'sending message if no issue is found
'if user don't have permission to see the issue
ElseIf .Status = "403" Then
MsgBox "You do not have permission to view the specified issue", vbInformation, "Acess Denied"
Kanban is a popular agile framework suitable for both operations and development teams. It does not matter if you are a support team handling issues reported by customers, an internal service desk te...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events