JDBC Driver for ActiveCampaign

Build 22.0.8462

ContactAutomations

View many or all contacts by including their ID's or various filters.

Table Specific Information

Select

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

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462