Jira Excel VBA Module with Basic functions

I share in this post some examples how to use Jira REST API from Excel VBA. This post is a WIP/Draft. If you are interested in me explaining more, leave a comment.

Resources

The solution here makes use of 2 VBA Libraries provided by @timhall (many thanks!):

• VBA-Web
• VBA-JSON

Jira Integration

Login/ WebService

This implementation example is for the Jira server version with a Basic authentication.

Run WebRequest

Parse Json Response

Code

Code is available in this Gist.

See also