Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,465,334
Community Members
 
Community Events
176
Community Groups

How do I automate a periodic export of filtered Jira data to a CSV file?

I see how to do an export from the UI on-demand, but I need to do a daily export of selected FEATURE records to sync to another system, via GSheet.

4 answers

Hi @Jeffrey Lyons are you familiar with the free add on Jira cloud for sheets.  We use this for a lot of our reporting.  You set up your query of what you want to pull into sheets and there is a setting to schedule it to update. Not aware of an automated save to CSV but it can be downloaded as a CSV

Darryl Lee Community Leader Dec 07, 2022

THIS is a much better answer!

Like Lynne Ratcliffe likes this

Thanks @Lynne Ratcliffe through your link I found Jira Cloud for Excel !

Like Lynne Ratcliffe likes this
0 votes

Hi @Jeffrey Lyons

I’ve linked your suggestion to a related feature request, which counts as an upvote for this ticket:

https://jira.atlassian.com/browse/AUTO-241

Cheers,

Charlie

0 votes
Darryl Lee Community Leader Dec 07, 2022

Hey @Jeffrey Lyons and @Mark Segall ....

Well, you could use the Web Request action to make a POST to somewhere on the Internets, and you could schedule that to run against a JQL query against your FEATURE project every day.

The problem would be that I'm pretty sure Google GSheets and Drive's APIs require more complicated authentication than can be done with Web Requests (which are limited to Basic Auth in headers).

So what I guess I'm saying is that another alternative would be to try and find or create a service that can "receive" data from an Automation POST, and "feed" it to Google, and this would at least alleviate you from having to program to the the Jira API.

0 votes
Mark Segall Community Leader Dec 07, 2022

Hi @Jeffrey Lyons - Natively, this simply isn't possible.  You would need to do some custom development for this leveraging the API.

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events