TransactionalAllowlists
Lists all sender addresses or domains approved to send transactional messages through Mailchimp Transactional.
Table Specific Information
SELECT, INSERT and DELETE is supported for TransactionalAllowlists.
Select
The connector will use the Mailchimp API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the connector.
- Email supports the '=' operator.
SELECT * FROM TransactionalAllowlists WHERE Email = '[email protected]'
Insert
Email is required for Insert operation.
INSERT INTO TransactionalAllowlists(Email) VALUES ('[email protected]')
Delete
Email is required for Delete operation.
DELETE FROM TransactionalAllowlists WHERE Email = '[email protected]'
Columns
| Name | Type | ReadOnly | Description |
| Email [KEY] | String | False |
The email address that has been added to the allowlist to ensure its messages are not blocked or filtered as spam. |
| CreatedAt | Datetime | True |
The date and time when the email address was added to the allowlist, providing traceability for the change. |
| Detail | String | True |
Additional details or context about the allowlist entry, such as the reason or method by which it was added. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| Comment | String |
An optional note describing why the email address was added to the allowlist. This field is used only for INSERT operations. |