Any URL associated to the "Export to Excel" menu within a structure?

LaBulle22 December 8, 2019

Hi everyone,

I'd like to know whether it's possible to get the URL that is behind the "Export to Excel" function in a Structure just like the one one can get for example from the "Export CSV (Current fields)" in a Search (i.e. https://<jira server>/sr/jira.issueviews:searchrequest-csv-current-fields/<filter id>/SearchRequest-<filter id>.csv)?

Thanks for your help.

 

 

 

1 answer

1 accepted

0 votes
Answer accepted
Egor Tasa [ALM Works]
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.
December 8, 2019

Hello!

Here is an example how you can access export.

https://Jiraalmworks.com/plugins/servlet/structure/excel?forestSpec=%7B%22structureId%22%3A2615%2C%22title%22%3Atrue%7D&viewId=12

The URL Consists of the following parts:

1. https://Jiraalmworks.com/plugins/servlet/structure/excel?forestSpec= This part is standard, and you would only need to paste your server address.

2. Forest spec can be taken from the page’s requests table (in Google Chrome: Settings | More Tools | Developer Tools | Network tab). Any poll request will have a row looking like spec:

{structureID: X}

The contents in the curly brackets might be more complex, depending on the columns and transformations being used.

You would need to encode the copied contents (brackets included), for that paste it here: https://www.url-encode-decode.com/ , paste the result and add it to the link;

3. viewId=12 indicates the used view. To find out its ID please open: Administration > Structure > Defaults and find it on the list in the ‘Default View Settings’ section.

Regards,

Egor Tasa

ALM Works

LaBulle22 December 9, 2019

Hi Egor,

It took me sometime to apply all you told me, but that works fine now. Thanks a lot.

Regards,
LaBulle22

Suggest an answer

Log in or Sign up to answer