SSIS Components for ActiveCampaign

Build 23.0.8839

ContactLists

Retrieve ContactList for each contact Group or for the specific Contact group.

Table Specific Information

Select

Retrieving information from ContactLists requires specifying a ContactId.

SELECT * FROM ContactLists WHERE ContactId = 1000

Columns

Name Type Description
Id [KEY] String The Id column of the ContactLists table.
ContactId String The ContactId column of the ContactLists table.
AutomationId String The AutomationId column of the ContactLists table.
AutosyncLog String The AutosyncLog column of the ContactLists table.
Campaign String The Campaign column of the ContactLists table.
CreatedBy String The CreatedBy column of the ContactLists table.
CreatedTimestamp Datetime The CreatedTimestamp column of the ContactLists table.
FirstName String The FirstName column of the ContactLists table.
Form String The Form column of the ContactLists table.
Ip4Sub String The Ip4Sub column of the ContactLists table.
Ip4Unsub String The Ip4Unsub column of the ContactLists table.
Ip4Last String The Ip4Last column of the ContactLists table.
LastName String The LastName column of the ContactLists table.
AutomationLink String The AutomationLink column of the ContactLists table.
AutosyncLogLink String The AutosyncLogLink column of the ContactLists table.
CampaignLink String The CampaignLink column of the ContactLists table.
ContactLink String The ContactLink column of the ContactLists table.
FormLink String The FormLink column of the ContactLists table.
ListLink String The ListLink column of the ContactLists table.
MessageLink String The MessageLink column of the ContactLists table.
UnsubscribeAutomationLink String The UnsubscribeAutomationLink column of the ContactLists table.
ListId String The ListId column of the ContactLists table.
Message String The Message column of the ContactLists table.
Responder String The Responder column of the ContactLists table.
Sdate Datetime The Sdate column of the ContactLists table.
SeriesId String The SeriesId column of the ContactLists table.
Status String The Status column of the ContactLists table.
SourceId String The SourceId column of the ContactLists table.
Sync String The Sync column of the ContactLists table.
Unsubreason String The Unsubreason column of the ContactLists table.
UnsubscribeAutomation String The UnsubscribeAutomation column of the ContactLists table.
UpdatedBy String The UpdatedBy column of the ContactLists table.
UpdatedTimestamp Datetime The UpdatedTimestamp column of the ContactLists table.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839