JDBC Driver for ActiveCampaign

Build 22.0.8462

Campaigns

Query the campaigns information in ActiveCampaign.

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 Campaigns WHERE Id = 10003

Columns

Name Type Description
Id [KEY] String The Id column of the Campaigns table.
ActiveRssInterval String The ActiveRssInterval column of the Campaigns table.
ActiveRssItems String The ActiveRssItems column of the Campaigns table.
ActiveRssUrl String The ActiveRssUrl column of the Campaigns table.
AddressId String The AddressId column of the Campaigns table.
AnalyticsCampaignName String The AnalyticsCampaignName column of the Campaigns table.
Automation String The Automation column of the Campaigns table.
BaseMessageId String The BaseMessageId column of the Campaigns table.
BaseTemplateId String The BaseTemplateId column of the Campaigns table.
BounceId String The BounceId column of the Campaigns table.
CanSkipApproval String The can_skip_approval column of the Campaigns table.
Cdate Datetime The Cdate column of the Campaigns table.
CreatedBy String The Created By column of the Campaigns table.
CreatedTimestamp Datetime The Created Timestamp column of the Campaigns table.
DeleteStamp String The DeleteStamp column of the Campaigns table.
EmbedImages String The EmbedImages column of the Campaigns table.
Facebook String The Facebook column of the Campaigns table.
FormId String The FormId column of the Campaigns table.
Forwards String The Forwards column of the Campaigns table.
HardBounces String The HardBounces column of the Campaigns table.
HasPredictiveContent Bit The HasPredictiveContent column of the Campaigns table.
HtmlUnsub String The HtmlUnsub column of the Campaigns table.
HtmlUnsubdata String The HtmlUnsubdata column of the Campaigns table.
Ip String The Ip column of the Campaigns table.
Ip4 String The Ip4 column of the Campaigns table.
LastStep String The LastStep column of the Campaigns table.
Ldate String The Ldate column of the Campaigns table.
LinkClicks String The LinkClicks column of the Campaigns table.
AutomationLink String The AutomationLink column of the Campaigns table.
CampaignAggregateRevenuesLink String The AggregateRevenues column of the Campaigns table.
CampaignListsLink String The CampaignListsLink column of the Campaigns table.
CampaignMessageLink String The CampaignMessageLink column of the Campaigns table.
CampaignMessagesLink String The CampaignMessagesLink column of the Campaigns table.
LinksLink String The LinksLink column of the Campaigns table.
LinksSegment String The Segment column of the Campaigns table.
UserLink String The UserLink column of the Campaigns table.
MailCleanup String The MailCleanup column of the Campaigns table.
MailSend String The MailSend column of the Campaigns table.
MailTransfer String The MailTransfer column of the Campaigns table.
MailerLogFile String The MailerLogFile column of the Campaigns table.
ManageText String The ManageText column of the Campaigns table.
Mdate Datetime The Mdate column of the Campaigns table.
Name String The Name column of the Campaigns table.
Opens String The Opens column of the Campaigns table.
Public String The Public column of the Campaigns table.
RealCid String The RealCid column of the Campaigns table.
Recurring String The Recurring column of the Campaigns table.
ReminderField String The ReminderField column of the Campaigns table.
ReminderFormat String The ReminderFormat column of the Campaigns table.
ReminderLastCronRun String The ReminderLastCronRun column of the Campaigns table.
ReminderOffset String The ReminderOffset column of the Campaigns table.
ReminderOffsetSign String The ReminderOffsetSign column of the Campaigns table.
ReminderOffsetType String The ReminderOffsetType column of the Campaigns table.
ReminderType String The ReminderType column of the Campaigns table.
Replies String The Replies column of the Campaigns table.
ReplySys String The ReplySys column of the Campaigns table.
ResponderExisting String The ResponderExisting column of the Campaigns table.
ResponderOffset String The ResponderOffset column of the Campaigns table.
ResponderType String The ResponderType column of the Campaigns table.
Schedule String The Schedule column of the Campaigns table.
ScheduledDate String The ScheduledDate column of the Campaigns table.
Screenshot String The Screenshot column of the Campaigns table.
Sdate String The Sdate column of the Campaigns table.
SegmentId String The SegmentId column of the Campaigns table.
SegmentName String The SegmentName column of the Campaigns table.
SendAmt String The SendAmt column of the Campaigns table.
SendId String The SendId column of the Campaigns table.
SeriesId String The SeriesId column of the Campaigns table.
Series Send Lock Time String The SeriesSendLockTime column of the Campaigns table.
SocialShares String The SocialShares column of the Campaigns table.
SoftBounces String The SoftBounces column of the Campaigns table.
Source String The Source column of the Campaigns table.
SplitContent String The SplitContent column of the Campaigns table.
SplitOffset String The SplitOffset column of the Campaigns table.
SplitOffsetType String The SplitOffsetType column of the Campaigns table.
SplitType String The SplitType column of the Campaigns table.
SplitWinnerAwaiting String The SplitWinnerAwaiting column of the Campaigns table.
SplitWinnerMessageId String The SplitWinnerMessageId column of the Campaigns table.
Status String The Status column of the Campaigns table.
SubscriberClicks String The SubscriberClicks column of the Campaigns table.
Survey String The Survey column of the Campaigns table.
TextUnsub String The TextUnsub column of the Campaigns table.
TextUnsubData String The TextUnsubData column of the Campaigns table.
ThreadId String The ThreadId column of the Campaigns table.
TotalAmt String The TotalAmt column of the Campaigns table.
TrackLinks String The TrackLinks column of the Campaigns table.
TrackLinksAnalytics String The TrackLinksAnalytics column of the Campaigns table.
TrackReads String The TrackReads column of the Campaigns table.
TrackReadsAnalytics String The TrackReadsAnalytics column of the Campaigns table.
Tweet String The Tweet column of the Campaigns table.
Type String The Type column of the Campaigns table.
UniqueForwards String The UniqueForwards column of the Campaigns table.
UniqueLinkClicks String The UniqueLinkClicks column of the Campaigns table.
UniqueOpens String The UniqueOpens column of the Campaigns table.
UniqueReplies String The UniqueReplies column of the Campaigns table.
UnsubReasons String The UnsubReasons column of the Campaigns table.
Unsubscribes String The Unsubscribes column of the Campaigns table.
Updated By String The UpdatedBy column of the Campaigns table.
Updated Timestamp String The UpdatedTimestamp column of the Campaigns table.
Updates String The Updates column of the Campaigns table.
User String The User column of the Campaigns table.
UserId String The UserId column of the Campaigns table.
WaitPreview String The WaitPreview column of the Campaigns table.
WillRecur String The WillRecur column of the Campaigns table.

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