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