Can one use Excel and VBA to create a new issue in JIRA?

[Dave Burrells]

I have an Excel spreadsheet of tasks and I want to write some VBA code so that I can press a button and a task is sent to JIRA where a new JIRA Issue (I think that is what they are called) is created.

Is this possible and where would I start? I am perficient in VBA.

Thanks

[Fabiano Nascimento Leite]

Hi Dave,

see this link:

https://answers.atlassian.com/questions/180214/creating-jira-issue-from-excel-vba

[Bob Swift]

VBA can run a command - see JIRA Command Line Interface has createIssue.

[Timothy]

If VBA can convert excel data into JSON strings, then you can use the REST API (https://docs.atlassian.com/jira/REST/latest/).