Query the available programs on ActOn.
View Specific Information
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.
For example, the following queries are processed server side:
SELECT * FROM Programs WHERE Type = 'RACK'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.
|Id [KEY]||String||The id of the program.|
|Name||String||The name of the program.|
|IsFavorite||Bool||Flag denoting if the program is among the 'favorite' ones.|
|Description||String||The description of the program.|
|SrcIds||String||Ids of the lists involved in the program.|
|SrcNames||String||Name of the lists involved in the program.|
|MessageIds||String||Ids of the messages sent within the program.|
|Created||Datetime||When the program was created.|
|Modified||Datetime||When the program was last modified.|
|NextRun||Datetime||When the program is going to run again.|
|State||String||The state of the program.|
|Running||Bool||Flag denoting if the program is running or not.|
|Active||Int||Flag denoting if the program is active or not.|
|Scheduled||Bool||Flag denoting if the program is scheduled or not.|
|TagNames||String||List of tags related to the program.|
|Valid||Bool||Flag denoting if the program is valid or not.|
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.
|Type||String||Type of the program, used for filtering.
The allowed values are RACK, EVENT, LIST_MAINT.