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...
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?
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.
Here is the article on the same which I have showcased it via Shell scripting
And this is via Python Scripting
You can use jq tool which is convenient to convert JSON format to CSV
Here's the example for the same
Let me know if you have any queries
Here is the Doc ref
It's REST API which provides the data& querying
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