Lists
Usage information for the operation Lists.rsd.
Table Specific Information
Select
The add-in 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 add-in 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. |