Where the downloaded excel sheet from jira in export option is coming from?

[Razia Sultana]

Whichever the file we are downloading in jira from where this file is coming??

[Aron Gombas _Midori_]

Although I cannot know the exact use case, from the other discussion it sounds you're trying to automate the generation of Excel files. Before re-inventing the wheel, maybe you should check the (intuitively named) Excel Automation app which serves this exact purpose.

See: https://marketplace.atlassian.com/apps/1212797/excel-automation-plugin-for-jira-xlsx?hosting=server&tab=overview

[Thiago Ribeiro [Adaptavist]]

Excellent and Epic reply @Aron Gombas _Midori_ !

[Thiago Ribeiro [Adaptavist]]

JIRA writes the temporary files to the temp directory. It stores the temporary files such as import / export files, attachment files and indexes in this /temp directory.

[Razia Sultana]

Thanks for the quick response. But where will be that temp directory stores?

[Thiago Ribeiro [Adaptavist]]

You can find the tmp folder in the JIRA Home directory.

This article shows you the folder structure: Important directories and files 

[Nic Brough -Adaptavist-]

I have a feeling that this question is about trying to download an export directly instead of going through the UI.

Please, do not bother looking in the tmp or working directories for it.  The file is not always there, it's usually not complete and it is often deleted before you get to it.  Jira does a lot of the work of it in memory, and delivers it from there as well.  You should not touch any files in the working directories of an active Jira system either (beyond reading, although that does not include copying them).

May we ask why you are looking at this?

[Razia Sultana]

@Nic Brough -Adaptavist-For the automation purpose.

[Razia Sultana]

@Thiago Ribeiro [Adaptavist], Need to know on web application.

[Nic Brough -Adaptavist-]

I'm afraid that does not really answer the question.  But you still should not be reading the files from the server, they're not suitable for it.

For automation of downloads of data, use the REST interface.

[Razia Sultana]

@Nic Brough -Adaptavist-, How to find out the REST url's?

[Nic Brough -Adaptavist-]

Start at https://developer.atlassian.com/server/jira/platform/rest-apis/