Webhooks
Retrieve and modify webhooks.
Table Specific Information
Select
WooCommerce allows only a small subset of columns to be used in the WHERE clause of a SELECT query. Following columns are supported server side, all other columns are processed client side.
- Id supports the '=,IN,NOT IN ' operator.
- Status supports the '=' operator.
- DateCreated supports the '>,<,>=,<=,=' operator.
SELECT * FROM Webhooks WHERE Id = 4 SELECT * FROM Webhooks WHERE Id IN (4,5) SELECT * FROM Webhooks WHERE DateCreated = '2024-08-22 08:47:21.0'
Insert
The following attributes are required when performing an insert: Topic, DeliveryUrl.
INSERT INTO Webhooks (Topic, DeliveryUrl) VALUES ('order.updated', 'http://url.com')
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Long | True |
Unique identifier for the resource. | |
| Name | String | False |
A friendly name for the webhook. | |
| Status | String | False |
Webhook status. Options: active, paused and disabled. Defaults to active. | |
| Topic | String | False |
Webhook topic. | |
| Resource | String | True |
Webhook resource. | |
| Event | String | True |
Webhook event. | |
| HooksAggregate | String | True |
WooCommerce action names associated with the webhook. | |
| DeliveryUrl | String | False |
The URL where the webhook payload is delivered. | |
| Secret | String | False |
Secret key used to generate a hash of the delivered webhook and provided in the request headers. This will Defaults to a MD5 hash from the current user's ID | |
| DateCreated | Datetime | True |
The date the webhook was created, in the site's timezone. | |
| DateModified | Datetime | True |
The date the webhook was last modified, in the site's timezone. |