New Development

[Daniel Gregory]

Hi

starting new at Jira API development and looking for some advise.

looking at importing information from an old erp that doesn't support any connection types, looking to export via sql query the information i need to csv/xls and the checking off the data in jira cloud and adding new information.

is excel a good platform with vba script, or better off creating a new desktop program that links the gap or is there already something available?

[Dag Atle Stenstad]

Hi @Daniel Gregory, welcome to the Atlassian Community!

There are already ready-made Excel apps for extracting data, such as this one:
https://appsource.microsoft.com/en-gb/product/office/WA200000556?tab=Overview

If you’d like to use VBA, I’ve created a setup for authentication and working with the REST API, which you might find inspiring. You can find the code here:
https://github.com/dagiz007/ExcelAddin4Atlassian

That said, there hasn’t been much development in VBA over the past few decades. I would strongly recommend considering Python instead. There are plenty of libraries available that can help you get started quickly. Python also makes it easy to export results to Excel files if you want to process the data further there.

Good luck! :)