ContactAutomations
View many or all contacts by including their ID's or various filters.
Table Specific Information
Select
The add-in uses the ActiveCampaign API to process search criteria that refer to the ContactId column. The add-in processes other filters client-side within the driver. For example, the following query is processed server side:
SELECT * FROM ContactAutomations WHERE ContactId = 1000
Columns
| Name | Type | Description |
| Id | String | The Id column of the ContactAutomations table. |
| Adddate | Datetime | The Adddate column of the ContactAutomations table. |
| Automation | String | The Automation column of the ContactAutomations table. |
| Batchid | Unknown | The Batchid column of the ContactAutomations table. |
| CompleteValue | Integer | The CompleteValue column of the ContactAutomations table. |
| Completed | Integer | The Completed column of the ContactAutomations table. |
| CompletedElements | String | The CompletedElements column of the ContactAutomations table. |
| ContactId | String | The ContactId column of the ContactAutomations table. |
| Lastblock | String | The Lastblock column of the ContactAutomations table. |
| Lastdate | Datetime | The Lastdate column of the ContactAutomations table. |
| LastLogId | String | The LastLogId column of the ContactAutomations table. |
| AutomationLink | String | The AutomationLink column of the ContactAutomations table. |
| ContactLink | String | The ContactLink column of the ContactAutomations table. |
| ContactGoalsLink | String | The ContactGoalsLink column of the ContactAutomations table. |
| Remdate | Datetime | The Remdate column of the ContactAutomations table. |
| SeriesId | String | The SeriesId column of the ContactAutomations table. |
| StartId | String | The StartId column of the ContactAutomations table. |
| Status | String | The Status column of the ContactAutomations table. |
| TimeSpan | String | The TimeSpan column of the ContactAutomations table. |
| TotalElements | String | The TotalElements column of the ContactAutomations table. |