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.
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.
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
It looks like you're new here. Sign in or register to get started.
