Optout
Upsert, delete and query records of a Optout list.
Table Specific Information
Select
The adapter will use the ActOn API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the adapter.
- Timestamp supports the '>=' , '>' , '<=' and '<' operator.
For example:
SELECT * FROM Optout SELECT * FROM Optout WHERE Timestamp >= '2022-09-15 08:53:50.111' AND Timestamp <= '2022-09-16 00:30:33.14' SELECT * FROM Optout WHERE Timestamp > '2022-09-15 08:53:50.111' AND Timestamp < '2022-09-16 00:30:33.14'
Upsert
Upsert can be executed by specifying the Email column. Following is an example of how to insert a single email into this table
UPSERT INTO Optout(Email) VALUES('ym@cdata.com')
Multiple emails can also be added or updated. Following is an example of how to insert multiple emails into this table
UPSERT INTO Optout(Email) VALUES('jk@cdata.com;mk@cdata.com')
DELETE
Delete can be executed by specifying the Email column in the WHERE Clause. Following is an example of how to delete a single email from this table
DELETE FROM Optout WHERE Email='ym@cdata.com'
Multiple emails can also be deleted. Following is an example of how to delete multiple emails into this table
DELETE FROM Optout WHERE Email='jk@cdata.com;mk@cdata.com'
Columns
Name | Type | ReadOnly | Description |
String | False |
Email of the user. | |
Origin | String | True |
Origin. |
Timestamp | Timestamp | True |
When the user joined the list. |