Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Question about jira.issueviews:searchrequest-xml

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.[mytoken_generated]_lin&tempMax=1000

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)

url = """

Set JiraService = New MSXML2.XMLHTTP60
With JiraService
       .Open "GET", [url], False
       .setRequestHeader "Content-Type", "application/json"
       .setRequestHeader "Accept", "application/json"
       .setRequestHeader "Authorization", "Basic " & modSecurity.EncodeBase64()

       result= .responseText

End With

By the way, if you are thinking to change /json to /xml, think again. It does not work

No cigar...

0 answers

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira Service Management

Atlympic Event: Jira Service Managemnt

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! ...

121 views 0 2
Read article

Community Events

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

Events near you