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; } } }

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

ROBERT Denis

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

Accepted answers

Aron Gombas

The Structure app's REST API is documented here: https://wiki.almworks.com/documentation/structure/latest/data-center-and-server/structure-rest-api-reference-32223493.html

All comments

Aron Gombas

The Structure app's REST API is documented here: https://wiki.almworks.com/documentation/structure/latest/data-center-and-server/structure-rest-api-reference-32223493.html

ROBERT Denis

Thanks a lot Aron :-)

Melvin Mathew_le8e3f

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

Ron A_9i9k70

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?

Welcome!

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

Quick Links

Find more posts tagged with

server

jira

jira-server