Best Way to Export Data From API into Flat File?

Question

I have a project where I need to get results about issues, their assignee, team, etc.  All of this I have been able to accomplish using a filter and then pointing my script to the URL that results from "Export to CSV".

My outstanding task is getting an accurate date/timestamp for when a ticket actually starts development and finishes development (Status changes to In Progress then from Status X to "Done"). Updated date can't always be trusted in case of adding comments among other things after changing the status to done.

I know this is accessible via the API but this will need to be automated (will use scripting to accomplish) and will only run once a week.  Once data is retrieved I will dump into a SQL Server table.

***EDIT***

I have to use the API, my org doesn't want anyone touching the db (can't blame them at all)

Thanks in advance

Ian Heagren · Answer

Thanks Mark.

In case our version is in the cloud, suggestions? (Only ever used JIRA for scrum/agile purposes, never anything more until now).

Mark Markov · Answer

Hello @Ian Heagren

I think in your case it would be better to do it on DB layer.

Create procedure script on your jira DB that will do the trick.

Database scheme you can find here

And remember that changes in DB is highly not recommended and may cause some unexpected behaviours, but for report purpose it is  not that bad thing to do.