TransactionalAllowlists

Get Transactional Allowlists.

Table Specific Information

SELECT, INSERT and DELETE is supported for TransactionalAllowlists.

Select

The 本製品 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 本製品.

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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
Comment	String	An optional description of why the email was added to the allowlist. Only used for INSERT.