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 | 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. |