Entering JQL from excel

[Rahul Aich [Nagra]]

Hi All,

We would like to build an excel tool (with VB coding) to directly enter a JQL from the excel and get the data from jira into the same excel sheet.

Is this possible? If not, what are my alternatives.

We simply want to get data in an excel sheet without going into jira and exporting the filter results into an excel.

Has anyone tried this sort of a thing?

Rahul

[Nic Brough -Adaptavist-]

I've seen it done a couple of times. You can write VBS that can issue a REST call to Jira and pull back the results.

[Rahul Aich [Nagra]]

thanks Nic...