TransactionalAllowlists
Get Transactional Allowlists.
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 |
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. |