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 can I export to CSV the results of a search via the REST API?

Anibal Jodorcovsky

I'm connecting to a Jira server with version v8.22.3#822003.

I'm doing this search:

https://informs.infoway-inforoute.ca/issues/?jql=%22Batch%20ID%22%20~%20BSCT-18060

And this search gives me a list of tickets. From there, I'm currently doing the following:

* Manually selecting the Export pull-down menu

* Selecting CSV (all fields)

I'd like to do the above via REST API to automate it. I can login and get a ticket via the REST API (using jiraone in Python). But I can't find what's the endpoint and payload to be able to download the result of a search.

Accepted answers

All comments

Vikrant Yadav

Hi @Anibal Jodorcovsky Welcome to Atlassian Community!

You can export REST API data into CSV using MS Excel.

REST API result in JSON, you can convert JSON data into csv OR you can use below method to get JQL Data directly into csv. Any changes in JIRA Issue also get reflected in Excel file, no need to export again or run API again.

Open MS Excel --> Select Data tab >> Select Data Source >> From Web >> Enter URL :- https://informs.infoway-inforoute.ca/issues/?jql=%22Batch%20ID%22%20~%20BSCT-18060 >> Press OK >> Enter Basic Auth or Web API token >> Power Query Editor will Open >> Click "List" >> Records will open >> Click "Into Table" >> Select Column/Fields which you want to add into your excel >> Press "Save & Close".

Use Basic or web API.png Paste URL Press OK.png Screenshot 2023-04-09 121019.png Screenshot 2023-04-09 121157.png

Anibal Jodorcovsky

The thing is that I need to do some more postprocessing on the CSV file, so this Excel trick, although nice to know, does not help me. Once I get the CSV file (or xlsx file) I need to run some business logic on values obtained, and then update some other database we have.

So, is there a way for me to be able to basically do what the image below does in the UI?

Vikrant Yadav

@Anibal Jodorcovsky This Excel trick save your time, and you don't need to export JIRA into csv again and again. Map only your projects fields in column. This is a one time setup, next time you only need to click refresh data.

Above Screenshot feature is only available in JIRA. Using REST API you get data in json format. For CSV convert data into csv.

Anibal Jodorcovsky

But I can't use Excel. My program is all in Python and I need to extract this information from Python, not from Excel.

Anibal Jodorcovsky

This is weird. I have an email with another answer, which is correct, but I don't see it online when logging in to the website. Why would that be?

Aditya Srikanth

Anibal Jodorcovsky can you plz post the correct answer here? I'm also having the same requirement.

Robin Kon

I automated this using Skyvia by syncing Jira data directly to CSV. It might save you some coding effort and streamline the process. You can find more information about it here.

Hope this helps!

Welcome!

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

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud

rest-api

python