ContactLists
Retrieve ContactList for each contact Group or for the specific Contact group.
Table Specific Information
Select
The connector uses the ActiveCampaign API to process search criteria that refer to the Id column. The connector processes other filters client-side within the driver. For example, the following query is processed server side:
SELECT * FROM ContactLists WHERE Id = 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. |