Hi,
I have a database in Jove.
I am hoping to use SQL to get outputs and then use this outputs to trigger generating JIRA tickets in JIRA cloud.
For example,
My SQL will get the data for anything with a “FAIL” results, and based on these result I want to generate JIRA ticket.
SQL query could be:
Select A,B,C
from <my tab>
Where result =’FAIL’
Is this something achievable in Zapier to use SQL query database as the trigger?
Or any workaround I can use to achieve the same result?
Thank you
+5I think you’ll need to trigger from the database side.
I have a feeling unless you have an authorised connection you will not be able to inject SQL into a database. I haven’t heard of Jove I couldn’t see it in the list of Apps zapier.com/apps. But there are several premium options for databases.
If you have access to the database server you could implement a webhook to send your SQL results to zapier. this may be the easiest way to do things as you’ll be able to format the results before sending them to Jira
+11Hi
Just came across this and wanted to check how you got on with Badger’s suggestion here—were you able to send a webhook from your Jove database to trigger the Zap?
Keen to ensure you’re all set so let us know if you need any further help at all!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
