Open Issue from scheduled sql query

[Rodney Fries]

I am looking for recommendations for a solution to open issues in service desk from a sql query on a different database that can be ran on a schedule. 

[LarryBrock]

Hello @Rodney Fries!

I'd recommend using the JSD API to open the issues based on the query to the other database.  By using the API, you position yourself to survive upgrades and other maintenance that could break other methods.

The API documentation is here: 

https://docs.atlassian.com/software/jira/docs/api/REST/7.13.0/?_ga=2.219656153.1344980107.1543243739-519660487.1507835842

and  here's a link to some examples:

https://developer.atlassian.com/server/jira/platform/jira-rest-api-examples/

Hope this answers your question.  If so, please click the "Accept Answer" button next to this answer so  others see the answered flag in their search results.  Thanks!

Cheers,
~~Larry Brock

[Nic Brough -Adaptavist-]

You will need to feed the results of your regular query through something that issues REST calls to Jira to create the issues or requests in Jira. 

Do not even think about writing to a Jira database directly - you will destroy your system beyond repair almost instantly.