ContactAutomations
View many or all contacts by including their ID's or various filters.
Table Specific Information
Select
The connector uses the ActiveCampaign API to process some of the filters.
For example, the following query is processed server side:
SELECT * FROM ContactAutomations WHERE Id = 10003
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. |