I have chaulked it up to load on the Jira server but have not introduced retry logic in that it has been easy enough just to hit the "Get Issues" button again and all works fine the 2nd time around. One interesting thing I have noticed is that the rest api call will sometimes fail but a subsequent call will work just fine. In the points of interest section I'll document the learnings and key code fragments. In this section I'll document how to use the excel workbook as an end user. While working on this project my biggest issue was that there were plenty of articles out there that talked to single point solutions in using the Jira Rest API from Excel but nothing that really provided an end to end view of how to login, call the api, parse the Json, and the nauances around what I learned. The create and update features where more or less a one time need but the form project seemed like on an ongoing generic problem. And if you look at CLOUD-8050 row you will see how when there are multiple issues linked to an issue how it's displayed in one cell.Īfter solving that problem I kept extending the Excel macro functionality to create new tickets update tickets and fill in a word document with data from a jira ticket. In the image below columns O, P, and Q show the results I was looking for.
I couldn't find away to do this in Jira so I decided to write an excel macro that would get issues from Jira and parse through the associated tickets and list out the status and fixed version so that in a single row/view I could see the status of the ticket and it's associated ticket.
The first problem I wanted to solve while using Jira was that I wanted to see a list of issues, and their associated issues with the associated issues current status and fixed versions. In this article I will share my learnings, Excel VBA code, and references to others code that provides a fairly elogant tho still in progress semi generic integration between Jira, Excel, and Word. There are some 3rd party for purchase add-in's to excel out there but I wanted a general all purpose add-in for Jira integration with Excel that allowed me to get, update, create, and create word documents ie change request forms from Jira information without having to pay for something. There is a lot of information on the web about Jira REST API's and do some simple REST calls to Jira from Excel but I have been unable to find a good end to end resource that glues all the concepts together to show one how to login, retrieve data, parse the returned data and insert into excel.
0 kommentar(er)
