OtherLists
Query the hardbounce, spam complaint and optout lists on ActOn. This view has been deprecated.
View Specific Information
To query data from this view, you must specify Type.
The connector 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 connector.
- 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'
Columns
| Name | Type | Description |
| String | Email of the user. | |
| Timestamp | Datetime | When the user joined the list. |
| Origin | String | |
| Type | String | The type of list.
The allowed values are HARDBOUNCE, SPAMCOMPLAINT, OPTOUT. |
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 |
| CreatedBefore | String | Only records created before the supplied value will be returned. |
| CreatedAfter | String | Only records created after the supplied value will be returned. |