How to export a Jira structure (+ a specific view) to excel using the rest api

ROBERT Denis April 20, 2023

Hello

I am trying to automate exporting  Structures (+ a specific view) from JIRA to an excel workbook periodically.

The excel sheet will  got rows grouped following the structure's tree

I would like to use  Jira rest api to adress Jira server from remote  providing structure and view Ids (name or number)

 

Best regards

 

 

2 answers

1 accepted

0 votes
Answer accepted
Aron Gombas
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 21, 2023
ROBERT Denis May 26, 2023

Thanks a lot Aron :-)

Melvin Mathew
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 1, 2024

Hi @ROBERT Denis did you find a way to execute this via REST API? If so can you provide some guidance.

0 votes
Ron A
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 31, 2024

Hi

I would like to do the same as @ROBERT Denis described.

Unfortunately @Aron Gombas s answer doesn't really help me.

Is there a way to automate the export (Excel, CSV, JSON, whatever) of a specific Jira Structure (via REST API), (without installing an additional AddOn)?

The way to get the forest, and pull and extract every single issue doesn't seem very comfortable (especially because I loose all the '(Sub) Folders' name, and have to calculate all the data, which is already done in the structure board, again in my automation python script).

 

So the best way would be to get the data via (Rest) API, as it is in the (manual) exported Excel-file.

Any concrete guidance how to realize that via (rest) API?
Maybe @Brant Schroeder has any clue?

 

 

 

Suggest an answer

Log in or Sign up to answer