automate the process of JIRA data extraction without any human intervention

I am tracking the progress of each JIRA on a daily basis in a project. All the in-progress JIRAs are listed in the saved query as follow.

http://hostname:8080/secure/IssueNavigator.jspa?mode=hide&requestId=13239

There is a field in the schema ‘Remaining Estimate’ indicating the effort of Expected To Completion(ETC) and my developer updates the number in that field daily. I need to extract the remaining estimate of each JIRA in the list COB everyday and convert it into a status report with a standalone Java program I created. The number of ‘Remaining Estimate’ can be extracted by manually clicking Views -> Excel (All Fields) but it quite inconvenient due to the manual effort required. My requirement is actually, in short, to automate the process of JIRA data extraction without any human intervention.

This could be achieved with one of the two approaches as per my knowledge. More options are to be suggested.

A. An programming interface that allows data retrieval for the JIRA fields.

I have been working with the JIRA SOAP Service interface. I could retrieve data from the web service URL http://hostname:8080/rpc/soap/jirasoapservice-v2?wsdl. The problem is that the SOAP Service API gives some common JIRA fields such as Summary and Description but it does not provide a method that returns the field of Remaining Estimate. Let me know if there is such an API I am looking for. This is my preferred approach because I have spent time on the programming.

B. JIRA extract the data and send it to me automatically with scheduled job.

Please someone advise the details of the file format and the delivery approach if this is the preferred approach.

1 answer

1 accepted

Accepted Answer
0 votes

Use getIssueList from JIRA Command Line Interface. The the appropriate outputFormat, you can retrieve all the fields you want including time tracking for all issues returned by a JQL search. The result is a CSV file.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Tuesday in Featured Groups

Tuesday tips & tricks: What is the Atlassian Community?

It's officially Tuesday, which means it's officially time for another tip to help you better navigate this space we call the Atlassian Community. 😄 I got a great question from community member, Sa...

122 views 6 8
View post

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you