Auto Extract of data from JIRA Cloud

[Suchita Kumari]

Hello,

We need daily auto extract of data on Cloud version of JIRA. Is there a way for the same?

[Petter Gonçalves · Accepted solution]

Hello Suchita,

Welcome to Atlassian Community!

Are you looking for a way to automatically generate backups from your entire JIRA Site (Including projects, workflows, schemes, etc) or you are only looking for an export option for issue details, like CSV exports?

If you are talking about your issue information only, you can try the getIssueList from JIRA Command Line Interface (CLI) plugin:

- Jira Command Line Interface (CLI)

Let me know if this is the option you are looking for.

[Suchita Kumari]

Hi Petterson,

Thanks for the response.

Actually I need all the Tickets created in JIRA for all projects daily automation required.

[Suchita Kumari]

And that is required in CSV format at some location on local server

[Suchita Kumari]

Yes Daily extract of all issues in JIRA to some FTP location ,so that it helps senior management in reporting.

Senior management is not ready to buy any plugin within the JIRA for reporting, because for most of the things they use dashboards in JIRA and for rest they need the data in csv so that they can use that using excel manipulations.

[Nic Brough -Adaptavist-]

This isn't going to happen in any sane way.  "Extract all" is hard work and a vast waste of your time.  Coding it is going to consume far more money than a look at add-ons or reporting tools, and be nowhere near as flexible, maintainable or useful.

You would be better off doing a proper analysis of what reports your management really want and describing that.  What are the questions they are trying to answer with the reporting?

[Nic Brough -Adaptavist-]

You could use the REST API to pull down a range of issues that you need, but the best approach depends on what you're trying to "extract"?

[Suchita Kumari]

Hey Nic,

thanks for the response.

Can we use REST API for cloud version of JIRA also and can we get daily extract of all the issues in JIRA ?

[Nic Brough -Adaptavist-]

Yes, the REST API exists for all Jira installs. 

A "daily extract of all the issues" is still a bit too vague.  Extract what?  Everything?  You want to download every issue every day?  How is that useful?  Why not just do the reporting in Jira?