Lists webhooks configured for an audience list, used to trigger updates based on subscriber activity.

Table-Specific Information

Select

The driver uses the Mailchimp API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the driver.

Column	Supported Operators
ListId	=
Id	=

For example, the following query is processed server-side:

SELECT * FROM ListsWebhooks WHERE ListId = 'abc' AND Id = '456'

Insert

The ListId column is required for INSERT operations. Optional insertable columns include Url, Events_Subscribe, Events_Unsubscribe, Events_Profile, Events_Cleaned, Events_Upemail, Events_Campaign, Sources_User, Sources_Admin, and Sources_Api.

INSERT INTO ListsWebhooks (ListId, Url, Events_Subscribe, Events_Unsubscribe) VALUES ('d24310a638', 'https://example.com/webhook', true, true)

Update

The ListId and Id columns are required in the WHERE clause for UPDATE operations. Updatable columns include Url, Events_Subscribe, Events_Unsubscribe, Events_Profile, Events_Cleaned, Events_Upemail, Events_Campaign, Sources_User, Sources_Admin, and Sources_Api.

UPDATE ListsWebhooks SET Url = 'https://example.com/webhook-v2', Events_Campaign = true WHERE ListId = 'd24310a638' AND Id = '456'

Delete

The following is an example of a DELETE operation:

DELETE FROM ListsWebhooks WHERE ListId = 'd24310a638' AND Id = '456'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		The unique identifier of the webhook within Mailchimp.
Url	String	False		The endpoint URL where webhook event notifications are sent when triggered.
Events_Subscribe	Boolean	False		If the value is 'true', the webhook is triggered when a subscriber joins the list.
Events_Unsubscribe	Boolean	False		If the value is 'true', the webhook is triggered when a subscriber unsubscribes from the list.
Events_Profile	Boolean	False		If the value is 'true', the webhook is triggered when a subscriber's profile information is updated.
Events_Cleaned	Boolean	False		If the value is 'true', the webhook is triggered when a subscriber's email address is cleaned due to repeated bounces.
Events_Upemail	Boolean	False		If the value is 'true', the webhook is triggered when a subscriber's email address is changed.
Events_Campaign	Boolean	False		If the value is 'true', the webhook is triggered when a campaign is sent or activity occurs related to that campaign.
Sources_User	Boolean	False		If the value is 'true', includes webhook events triggered by subscriber actions (such as signing up or unsubscribing).
Sources_Admin	Boolean	False		If the value is 'true', includes webhook events triggered by admin actions within Mailchimp.
Sources_Api	Boolean	False		If the value is 'true', includes webhook events triggered by API calls.
ListId [KEY]	String	False	Lists.Id	The unique identifier of the Mailchimp list (audience) associated with the webhook.