Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

API returns 415

Lisa H I'm New Here Aug 23, 2022

Hi all,

I'm trying to get started with communicating between excel and Jira using VBA.  I'm starting very basic.  This is what I've got:


Dim request As New WinHttpRequest
request.Open "GET", ""
request.Send "(""username"":""" & USER & """,""password"":""" & PASS & """)"

This returns an error of 415.  Can anyone help me figure out what is wrong?

1 answer

0 votes
Pramodh M Community Leader Aug 23, 2022

Hi @Lisa H 

Welcome to the Community

If it is Jira DC, it accepts Basic Authentication via Header

Can you try once and see if it accepts the request


Lisa H I'm New Here Aug 24, 2022

Thank you so much for being willing to help!  Very appreciated.

I added this line and am now getting a 500 error:

request.SetRequestHeader "Authorization", "Basic base64Encoded" 'NEW PASSWORD WITH TOKEN

Pramodh M Community Leader Aug 25, 2022

Hi @Lisa H 

Can you help me with the Platform from where you are making the call? I would check it from my end and let you know.

Do help me with the link & Screenshot.


Suggest an answer

Log in or Sign up to answer