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 !! :)

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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 !!

Accepted answers

Nic Brough -Adaptavist-

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?

All comments

Nic Brough -Adaptavist-

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jira-service-desk