SSIS Components for WooCommerce

Build 24.0.9062

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062