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?
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
I've considerable VBA experience, but no experience with JSON. Are there any sample routines of how to go about this?
It looks like you're new here. Sign in or register to get started.
