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

List all the columns in an issue

Jack_s4s0j0

Hello Team , I'm new to Jira and python ..I tried different online solutions to get all the columns in any issue but not able to get those to a data frame and save the data to CSV.

can any one share a code to get all the columns (custom columns also) from any given issue from jira using Python , save those columns data into data frame and to CSV.

Thanks in advance...

Jack

Accepted answers

All comments

Pramodh M

Hi @Jack

Here is the Doc ref

https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-issues/#api-rest-api-3-issue-createmeta-get

It's REST API which provides the data& querying

?fields=all

Would return all the fields

As given in the doc, you can also query specific fields as well

This parameter may be specified multiple times. For example, fields=field1,field2& fields=field3

Thanks,

Pramodh

Jack_s4s0j0

Thanks @Pramodh M - I got all the issues in a JSON format {data here } ..now how can I get all the columns in that string separated by , into Data frame..

Thanks again..

Jack_s4s0j0

I was able to get all the data from Issues to a Json file but now I have to read that file and get all the column names and data into a CSV..any sample code will help us a lot

Pramodh M

Hi @Jack

Here is the article on the same which I have showcased it via Shell scripting

https://community.atlassian.com/t5/Agile-articles/Basic-Jira-Software-Reports-at-Go-using-APIs/ba-p/2117691

And this is via Python Scripting

https://community.atlassian.com/t5/Jira-articles/Atlassian-Python-API-s/ba-p/2091355

https://community.atlassian.com/t5/Marketplace-Apps-Integrations/Python-APIs-for-Atlassian-Jira-Software/ba-p/1907722

You can use jq tool which is convenient to convert JSON format to CSV

Here's the example for the same

https://community.atlassian.com/t5/Jira-questions/Importing-issues-from-JIRA-to-Excel-using-API/qaq-p/1943319#M518597

Let me know if you have any queries

Pramodh M

@Jack

Please accept the answer if it helped your query

Thanks

Nic Brough -Adaptavist-

I am not sure that your question is clear.

Issues do not have columns, they are shown in columns on boards, depending on their status and the board configuration. So I don't quite know what you are looking for.

Do you mean you want to get the current status of issues from a REST call?

Jack_s4s0j0

Yes I'm getting data into JSON using REST call but now how to loop through the JSON file and get each column values from it to an CSV. Pls share any sample on it possible.

Nic Brough -Adaptavist-

I can't help you with the python, it's on my to-do list to learn it.

All I can tell you is that you'll need to read the board configuration to see what status are mapped where, and then go through the JSON to work out where each issue falls based on its current status.

Welcome!

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

Quick Links

Find more posts tagged with

jira

cloud

rest-api

jira-cloud