SSIS Components for Act-On

Build 25.0.9434

ContactList

Retrieve contact lists in your ActOn account.

View Specific Information

Retrieve contact lists in your ActOn account.

SELECT * FROM ContactList;

Columns

Name Type Description
Id [KEY] String Unique identifier of the contact list.
Name String Display name of the contact list.
FolderName String The folder under which this list is stored.
SourceId String Identifier of the source list.
BaseId String 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 Name of the source from which this list originates.
TsLastModified Datetime Last modified timestamp (Unix milliseconds).
TsLastCounted Datetime Timestamp when list size was last calculated.
TsSource Datetime Timestamp of the list source.
SourceTS Datetime Human-readable version of the source timestamp.
BIsSingleton Boolean Indicates if this is a singleton list.
BIsList Boolean Indicates if this is a standard list.
BIsSforce Boolean Indicates if the list is based on Salesforce data.
BIsSforceReport Boolean Indicates if the list is from a Salesforce report.
BIsSforceAvailable Boolean Whether Salesforce list data is available.
BIsMSDyn Boolean Indicates if the list uses Microsoft Dynamics.
BIsMSDynAvailable Boolean Whether Microsoft Dynamics list data is available.
BIsSugar Boolean Indicates if the list is linked to SugarCRM.
BIsSugarAvailable Boolean Whether SugarCRM list data is available.
BIsSL Boolean Indicates if the list is based on SalesLogix.
BIsSLAvailable Boolean Whether SalesLogix list data is available.
BIsNsuite Boolean Indicates if the list is linked to NetSuite.
BIsNsuiteAvailable Boolean Whether NetSuite list data is available.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434