TransactionalAllowlists
Get Transactional Allowlists.
Table Specific Information
SELECT, INSERT and DELETE is supported for TransactionalAllowlists.
Select
The driver 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 driver.
- 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 |
An email address to add to the allowlist. |
| CreatedAt | Datetime | True |
A description of why the email was allowlisted. |
| Detail | String | True |
When the email was added to the allowlist. |
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 description of why the email was added to the allowlist. Only used for INSERT. |