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

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

1 answer

... Hello Gustavo,
I was wondering if you ever get this to work. I'm able to download all my issues from the filters with all the available fields without the API and it takes 12 seconds max...

I accomplished it using the "export > HTML all fields" feature to download the filters, then I read the file in excel.

What I need is how to get the xml content though VBA so I can extract the atl_token like the one below, or if you know how to generate the token

Any help is appreciated. 

-Cris Rguez

Suggest an answer

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

Coming Soon: Insight Changing to Assets

The 2020 acquisition of Mindville added powerful asset and configuration management capabilities to Jira Service Management in the form of Insight. Following the completion of that integration, custo...

251 views 1 9
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