ContactList
Retrieve contact lists in your ActOn account.
View Specific Information
Retrieve contact lists in your Act-On account.
SELECT * FROM ContactList;
Columns
| Name | Type | Description |
| Id [KEY] | String | The unique Id of the contact list. |
| Name | String | The display name of the contact list. |
| FolderName | String | The folder under which this list is stored. |
| SourceId | String | The Id of the source list. |
| BaseId | String | The Base Id used for inheritance or replication. |
| Description | String | A textual description of the contact list. |
| SourceSize | Integer | The number of entries in the source list. |
| SourceName | String | The name of the source from which this list originates. |
| TsLastModified | Datetime | The last modified timestamp (in Unix milliseconds). |
| TsLastCounted | Datetime | The date and time when the list size was last calculated. |
| TsSource | Datetime | The timestamp of the list source. |
| SourceTS | Datetime | A human-readable version of the source timestamp. |
| BIsSingleton | Boolean | Indicates whether this is a singleton list. |
| BIsList | Boolean | Indicates whether this is a standard list. |
| BIsSforce | Boolean | Indicates whether the list is based on Salesforce data. |
| BIsSforceReport | Boolean | Indicates whether the list is from a Salesforce report. |
| BIsSforceAvailable | Boolean | Indicates whether Salesforce list data is available. |
| BIsMSDyn | Boolean | Indicates whether the list uses Microsoft Dynamics. |
| BIsMSDynAvailable | Boolean | Indicates whether Microsoft Dynamics list data is available. |
| BIsSugar | Boolean | Indicates whether the list is linked to SugarCRM. |
| BIsSugarAvailable | Boolean | Indicates whether SugarCRM list data is available. |
| BIsSL | Boolean | Indicates whether the list is based on SalesLogix. |
| BIsSLAvailable | Boolean | Indicates whether SalesLogix list data is available. |
| BIsNsuite | Boolean | Indicates whether the list is linked to NetSuite. |
| BIsNsuiteAvailable | Boolean | Indicates whether NetSuite list data is available. |