API VBA HOW TO

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.

API VBA HOW TO

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. Download Jira_Excel_Integration.zip - 478.3 KB.Download Jira_Excel_Integration.rar - 478.5 KB.

Api vba