Community
Products
Jira
Questions
Any idea how to get list of webhooks from DB by SQL

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

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

2 answers

1 accepted

3 votes

Answer accepted

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

0 votes

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like • Valiantys Support likes this

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/

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Forums

Product Q&A

Community resources

Support

Top groups

Community resources

Support

Learn

Community resources

Support

Events

Community resources

Support

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

2 answers

1 accepted

Suggest an answer

Was this helpful?

Thanks!

DEPLOYMENT TYPE

PRODUCT PLAN

TAGS

Community showcase

Atlassian Community Events