Using REST/SOAP to generate reports in JIRA

[Eric Gross]

I want to generate regular reports in JIRA based on filters that I have already created. I was thinking of using the REST API to create a python script that will do this automatically, but I've never used REST/JSON before. If I used the REST API, would I be able to generate reports that could be emailed to someone, and would I be able to use the same data later in other applications (to graph, chart, etc.)? Would I be better off using the SOAP API (I haven't used this before either)? Am I overlooking an easier way of doing this?

Also, what would I need to do to start using the REST/SOAP API? Does anything need to be installed on the JIRA server?

[Bob Swift OSS (Bob Swift Atlassian Apps) · Accepted solution]

Consider using the JIRA Command Line Interface to avoid the programming. getIssueList or other actions.

[Eric Gross]

Ah, okay. That looks like it might be a little bit easier. If I were to go with using SOAP/REST, would I be able to pull the data I'm looking for (issues open based on filters)? I'm leaning slightly towards SOAP (although it isn't being developed anymore) because I will be importing this data to MS Excel at some point.

[Bob Swift OSS (Bob Swift Atlassian Apps)]

Certainly SOAP works with a filter. For REST, I think you use the JQL search and specify in the JQL to use the filter.

[Eric Gross]

Would I be able to email the issue list once it is obtained through the JIRA CLI?

[Bob Swift OSS (Bob Swift Atlassian Apps)]

Yes. Output the result to a file (file parameter) and the send as an attachment. It is a csv file format.

[Pablo Beltran]

The SQL for JIRA plugin is a insanely powerful alternative to REST for reporting....

[mwarton]

You can also try a plugin like Intelligent Reports which makes creating regular scheduled reports easy. You design your report Template in Microsoft Word, then choose the data to fill it with using simple point and click rules, no scripting or API to learn. You can then generate reports on demand or schedule them to be delivered to you by email every day, week, etc.

[Yogendra Jat]

Hi, Could you also able to fetch sub-version commits values? If yes how?