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.
These columns support only the = comparison, unless stated otherwise. The available columns for this
table are: Id, Status. All other columns are processed client side.
SELECT * FROM Webhooks WHERE Id = 4
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 | 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 | True |
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. |