Temporal Data recovery

[Yasir EL GHARNAJI]

I want to recovery data from the JIRA REST API, The objective of this work is to confirm

• the ability to recover automatically (in CSV files) some JIRA data via API
• The possibility to query on elements displayed in JIRA but not requêtable in the JIRA interface (update temporal data)

Here is the list of data that I want to retrieve initially :

•  Log in to the Jira API 
• Retrieve data from User Story files and store them in an excel file
  • ID
  • Labels
  • Components
  • Summary
  • Affected Version
  • Statut
  • LinkedIssues
• Retrieve the status change dates from the User Story sheets

i you have some ideas how to recover temporal data from Jira, Thank you !! :)

[Nic Brough -Adaptavist- · Accepted solution]

The short answer is "you can't".  But that's because the REST API responses are JSON.

If you're happy to write something to convert JSON down to CSV, then yes, you can get ID, labels, component, summary, versions, status, links and a load of other stuff, including the history.

I am not sure what you mean by "temporal" though - what is "temporal data" and what does "elements displayed in JIRA but not requêtable in the JIRA interface (update temporal data)" mean?

[Yasir EL GHARNAJI]

Hi Nic ! thank you for your response.

Yes its a good idea if i can get JSON and convert it to CSV, but how ?

What i mean by Temporal data is like statut of tickets and when they were modified, who modified it and comment of the modification. globaly the changement in tickets by the time.

The possibility to query on elements displayed in JIRA history "for example". I think it's not requêtable in the JIRA interface.

[Nic Brough -Adaptavist-]

Ah, ok, you've picked an English word that has mostly dropped out of use in modern English, in it's original sense of "length of time related".  Most English speakers would go for a longer, but clearer description of "date things happened"

So, yes, that data is all included in the JSON if you ask for it over REST.

I've never needed to convert JSON to CSV, and I don't know what language you are scripting/writing in, so I can't begin to recommend what libraries might be of use to you (there must be a load out there, but I've never looked)

[Yasir EL GHARNAJI]

Ah Ok, sorry english is not my native language my bad :) but you understand what i mean.

I think that i will use JAVA to convert JSON to CSV. in the first place i just need to know how to have JSON data. after that i think it gonna be easy to take what exacty i want from JSON and convert to a CSV file .

Thank for you help !! I appreciate 

[Nic Brough -Adaptavist-]

It's not your fault, or lack of English, it's mine!  My branch (English, rather than American, Australian etc) has pretty much stopped using the word outside "Doctor Who" and our House of Lords, so I have become very vague on how it might be used!

Start at https://developer.atlassian.com/server/jira/platform/rest-apis/ for working with REST in Jira - the basic calls are there, starting with authentication, and if you then have a look at the links near the top of the page, you'll find the full API exposed - look for issue related calls, and you'll see the history and fields in there.

[Yasir EL GHARNAJI]

Thnak you @Nic Brough -Adaptavist-