I am attempting to download automatically some issues from JIRA. I have written some code with the help of other JIRA users and I can download issue, but in JSON, which is not very easy to manipulate. I am very good and my application can read easily XML.
This returns me the XML document with all the documents I need; then I use this XML to update a local database. So far so good.
Now I want to download them using VBA, but I cannot get the API working. The GET looks like this: (the encoding is fine because this returns JSON)
Set JiraService = New MSXML2.XMLHTTP60
.Open "GET", [url], False
.setRequestHeader "Content-Type", "application/json"
.setRequestHeader "Accept", "application/json"
.setRequestHeader "Authorization", "Basic " & modSecurity.EncodeBase64()
By the way, if you are thinking to change /json to /xml, think again. It does not work
Hello Community! Quick disclaimer: We are running a contest on Community (The Atlympics!) from July 23rd - August 8th of 2021. If you are interested in participating in this contest (prizes! ...
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