Any idea how to get list of webhooks from DB by SQL

[roman smatana]

Hi Team,

just urgently I need to list all webhooks and corresponding SQL query .

The webhook table does not exist, where is it hidding in JIRA Database ?

Many thanks

Roman

[Chihara · Accepted solution]

From Jira Administration Screen "Plugin Storage",  it may be "AO_4AEACD_WEBHOOK_DAO" table.

[Bill Sheboy]

Hi @roman smatana 

Seeing the webhooks is under the system admin functions.  Please look here to learn more:

https://confluence.atlassian.com/adminjiracloud/managing-webhooks-776636231.html

Best regards,

Bill

[roman smatana]

yes, I know in GUI , but I d like to query JIRA Database to get complete info in one table.

[Bill Sheboy]

Gotcha, and sorry I have not tried that before.  I believe you can use the REST API to query.  I did a quick search and found this, which includes information on fetching the webhooks:

https://developer.atlassian.com/cloud/jira/platform/webhooks/