How to get Jira issue inserted from SQL Server to show up on the website?

[elliotw_itsoft]

We have a Microsoft SQL database that we use for Jira.

We created a new row in the table jiraissue but this new issue doesn't show up on the Jira website.

Do you know why this is happening?

How can we get this new issue to show on the website?

[Andrej Freeze _ greenique · Accepted solution]

The best way to get your Data into Jira would be to write something outside Jira that can poke the data in. Jira exposes a REST interface which is ideal for this - you can use whatever language / system you have available (as long as it can issue REST calls) to enter the data whenever you need it. Java, c, python, shell scripts, I've even seen this done with database triggers.

Here is more information on Atlassians REST API's 

The more troublesome way would be to write a Jira App that does what you need. Maybe even the App Jira Command Line Interface (CLI) from Bobswift would do what you want, however I have never evaluated it.

[elliotw_itsoft]

I have looked into using the Jira API. I think this is going to work.

Thank You

[Nic Brough -Adaptavist-]

>We created a new row in the table jiraissue 

ARGH.  Never never never do that. 

Inserting issues via SQL is complex, painful and absolutely requires that your Jira is offline while SQL is being run. 

For example, did you update all the tables you needed to insert an issue?  Unless you can tell me (without searching), which are the two tables you needed to change as well as jiraissue for adding the most simple of issues, then I can guarantee you that you have just broken your Jira.

I would strongly recommend that you stop your Jira, and restore the database from the backup you took before you ran your SQL.

[Matt Doar]

Yup. These days inserting data directly into a database of any complexity is like patching a binary executable. While it's running.