How to create JIRA issue ticket from a template using REST api?

Mary Mark

User Data with approx 15 fields is loaded to a sql table on a daily basis. Once the data is
available in sql table, we would like to post to jira (generate the creation of issue tickets to jira to the jira database instance)

What tool process / translator can be used to get data from sql and post to jira?

Thanks

Stephen Sifers

Hello Mary,

Since your data is already stored within SQL you can simply query the data out and pass it through within a REST API to Jira via a self written script. Simple enough right? Well, not fully that simple but it is doable.

To understand the Jira REST API, you should review the documentation at:

JIRA Server platform REST API reference

Jira Cloud platform REST API reference

You will also need to choose which scripting language you want to have interact with SQL and the Jira API. If you’re running Windows and your SQL instance is MS SQL, then powershell would be an easy choice and it easily connects to MS SQL. If you’re using MS SQL 2016 or higher then your SQL data is queryable within a JSON format. You may find more about this at JSON data in SQL Server. If you’re not on Windows, then using Python would be a safe choice as there are many examples and Python experts available to answer your questions.

There are ample amounts of example on how to use the Jira REST API. You may find some basic examples at Jira REST API examples.

Your options for interaction with the Jira API are limited to your available resources. I hope this was helpful in providing some guidance to working with the REST API.

Regards,
Stephen Sifers