Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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

roman smatana April 7, 2020

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
Chihara
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 15, 2020

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

0 votes
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 7, 2020

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 April 7, 2020

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

Like Valiantys Support likes this
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 7, 2020

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/

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events