Lists
Usage information for the operation Lists.rsd.
Table Specific Information
Select
The connector uses the ActiveCampaign API to process some of the filters.
For example, the following queries are processed server side:
SELECT * FROM Lists WHERE Id = 1 SELECT * FROM Lists WHERE Name = 'list1'
In addition the connector supports retrieving information about members of lists in your account by supporting them dynamically as VIEWS. Selecting from a dynamic list will return information about all the contacts that are members of that list. Lists names always start with "List_".
Columns
| Name | Type | Description |
| Id [KEY] | String | The Id column of the Lists table. |
| AnalyticsDomains | String | The AnalyticsDomains column of the Lists table. |
| AnalyticsSource | String | The AnalyticsSource column of the Lists table. |
| AnalyticsUa | String | The AnalyticsUa column of the Lists table. |
| CarbonCopy | String | The CarbonCopy column of the Lists table. |
| Cdate | Datetime | The Cdate column of the Lists table. |
| Udate | Datetime | The Udate column of the Lists table. |
| DeleteStamp | String | The DeleteStamp column of the Lists table. |
| FacebookSession | String | The FacebookSession column of the Lists table. |
| FullAddress | String | The FullAddress column of the Lists table. |
| UnsubscribeReason | String | The UnsubscribeReason column of the Lists table. |
| AddressListsLink | String | The AddressListsLink column of the Lists table. |
| ContactGoalListsLink | String | The ContactGoalListsLink column of the Lists table. |
| UserLink | String | The UserLink column of the Lists table. |
| Name | String | The Name column of the Lists table. |
| OptinMessageId | String | The OptinMessageId column of the Lists table. |
| OptinOptout | String | The OptinOptout column of the Lists table. |
| OptoutConf | String | The OptoutConf column of the Lists table. |
| EmbedImage | String | The EmbedImage column of the Lists table. |
| UseAnalyticsLink | String | The UseAnalyticsLink column of the Lists table. |
| UseAnalyticsRead | String | The UseAnalyticsRead column of the Lists table. |
| UseCaptcha | String | The UseCaptcha column of the Lists table. |
| UseFacebook | String | The UseFacebook column of the Lists table. |
| UseTracking | String | The UseTracking column of the Lists table. |
| UseTwitter | String | The UseTwitter column of the Lists table. |
| Private | String | The Private column of the Lists table. |
| RequireName | String | The RequireName column of the Lists table. |
| SendLastBroadcast | String | The SendLastBroadcast column of the Lists table. |
| SenderAddr1 | String | The SenderAddr1 column of the Lists table. |
| SenderAddr2 | String | The SenderAddr2 column of the Lists table. |
| SenderCity | String | The SenderCity column of the Lists table. |
| SenderCountry | String | The SenderCountry column of the Lists table. |
| SenderName | String | The SenderName column of the Lists table. |
| SenderPhone | String | The SenderPhone column of the Lists table. |
| SenderReminder | String | The SenderReminder column of the Lists table. |
| SenderState | String | The SenderState column of the Lists table. |
| SenderUrl | String | The SenderUrl column of the Lists table. |
| SenderZip | String | The SenderZip column of the Lists table. |
| StringId | String | The StringId column of the Lists table. |
| SubscriptionNotify | String | The SubscriptionNotify column of the Lists table. |
| ToName | String | The ToName column of the Lists table. |
| TwitterToken | String | The TwitterToken column of the Lists table. |
| TwitterTokenSecret | String | The TwitterTokenSecret column of the Lists table. |
| UnsubscriptionNotify | String | The UnsubscriptionNotify column of the Lists table. |
| ListsUser | String | The ListsUser column of the Lists table. |
| ListsUserid | String | The ListsUserid column of the Lists table. |