Query the hardbounce, spam complaint and optout lists on ActOn.
View Specific Information
To query data from this view, you must specify Type.
The driver will use the Act-On API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the driver.
- Type supports the '=' operator.
- CreatedAfter supports the '=' operator.
- CreatedBefore supports the '=' operator.
For example, the following queries are processed server side:
SELECT * FROM [OtherLists] WHERE Type='OPTOUT' SELECT * FROM [OtherLists] WHERE Type='OPTOUT' AND CreatedAfter ='2018-08-28T14:37:48.923+02:00' AND CreatedBefore ='2018-08-28T14:37:48.925+02:00' SELECT * FROM [OtherLists] WHERE Type='HARDBOUNCE' AND CreatedBefore ='2019-09-28T14:39:48.924+02:00'You can turn off client-side execution by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will result in unfiltered data being pushed.
|String||Email of the user.|
|Timestamp||Datetime||When the user joined the list.|
|Type||String||The type of list.
The allowed values are HARDBOUNCE, SPAMCOMPLAINT, OPTOUT.
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.
|CreatedBefore||String||Only records created before the supplied value will be returned.|
|CreatedAfter||String||Only records created after the supplied value will be returned.|