Excel data connection to Jira query

[Ken Warthen]

Is it possible to, or do connectors exist, that would allow me to create a data connection in Excel or Microsoft Access to my Jira queries?

[Ken Warthen]

I've considerable VBA experience, but no experience with JSON.  Are there any sample routines of how to go about this?

[miikhy]

Hi Ken,

It's indeed possible. I've done that for many customers and unfortunately can't share it here but you'll need to use VBA and a JSON Parser. Using Microsoft XML dependency you can create requests to Jira's REST API and parse the reply with a great JSON Parser (a lot of them are freely available on the web :) ).

Please, if you give it a try and have specific points where you're struggling, I'll be happy to assist!

Cheers