![service now rest api vba service now rest api vba](https://i.ytimg.com/vi/309zss_H5uI/mqdefault.jpg)
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.
![service now rest api vba service now rest api vba](https://raw.githubusercontent.com/aduguid/Portfolio/master/Images/ReadMe/powerbi.servicenow.png)
![service now rest api vba service now rest api vba](https://zappysys.com/blog/wp-content/uploads/2019/06/odbc-create-table-in-access.png)
#Service now rest 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.