FireDAC Components for Act-On

Build 20.0.7654

OtherLists

Query the hardbounce, spam complaint and optout lists on ActOn.

View Specific Information

To query data from this view, you must specify Type.
The component 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 component.

  • 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.

Columns

Name Type Description
Email 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.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654