Export data from Jira using APIs

[Nirvana Admin Team]

Hi,

We are looking to introduce agents model in our business who will be referring lot of customers to us. Unfortunately we can’t give Jira access to all agents as it will increase our costs (we are using Jira software at the moment). Also there is an issue with not being able to create our own reports. So to address these 2 issues, we hired a team of web developers who are going to create agents portal and also user dashboards. In agents portal we want to show the agents cases (agent email id in on if the fields is uniq agent id) that are referred by us and dashboards highlighting their performance and bonus. Can u please help us with pointing out which APIs our dev team should use to achieve the below,

1) Extract data from Jira (all issues and fields related to it) on regular basis using APIs

2) once full data is extracted, from the next extract, only extract info related to newly created issues and updates issues

3) Create a new issue every time an agent registers a lead on the website.

Thank you,

Vamshi.

[eynat bing]

You can import data to excel with the URL:

http://<<your server here >>/secure/IssueNavigator.jspa?mode=hide&requestId=<<your filter id here>>&os_username=<<your username here>>&os_password=<<your password here>>

Make sure that you shared your filter with everybody and not set it as a private filter.

[Rochak Sharma]

Can you please help with an example of Server to enter in the <<your space here>>

[Adam Lee]

I couldn't get this to work. 

[Midori]

Save some scripting efforts, and just conveniently create an automation rule with the JIRA Automation Plugin:

• trigger: use the CRON type trigger (built-in)
• action: use the Send Excel action (provided by the Excel Automation Plugin)

Read the complete how-to.

[hrzadnn]

did it work, @Israel Dvorsky ??

[Iain Brown]

If you don't mind using Google Docs, then this is also an option - it can print index cards for you too http://www.littlebluemonkey.com/blog/automatically-import-jira-backlog-into-google-spreadsheet

[Renjith Pillai]

Read the answer in the below posting.

https://answers.atlassian.com/questions/29981/how-can-i-periodically-email-the-excel-version-of-a-report