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. |