List all the columns in an issue

[Jack]

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

[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]

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.

[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

[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]

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]

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