extract data from JIRA by getIssuesFromJqlSearch

[Li Zou]

Hi,

I want to use EXCEL 2003 VBA to extract JIRA isssues based on a certain JQL and dump Issue ID, summany, status, etc info into the spreadsheet.

I believe getIssuesFromJqlSearch method can work for the purpose, but I don't know how to do that.

Can anyone please share your success experience? Detail code is appreciated. Thanks!

[Midori]

Instead of Visual Basic, you could approach this from the other end: create a custom Excel template for the Better Excel add-on.

[Renjith Pillai]

You need to make web service requests to the Jira instance for doing the same. A quick Google search returned me these links.

http://www.webcontinuum.net/ws_4.aspx

http://msdn.microsoft.com/en-us/library/aa140260(v=office.10).aspx

Or the best and maintainable way for handling this is to do Excel automation from within a C# project (you can download free Express Edition of Visual Studio from MS) and do all your SOAP handling in your C# code.

And if you are looking at a simple dump of values into Excel sheet, you need not do all these as you can get it directly from the Jira filter.