Campaigns: ActiveCampaign Campaigns
delete REST
- Catalog:
ActiveCampaign - Schema:
V3 - Primary Keys:
id - Label: Campaigns
Can retrieve data and change data using delete.
API Source
- Endpoint:
/campaigns
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 247 |
| Full scan rows per minute | 4,860 |
The result can be cached on the client.
Table Columns
The columns of the table Campaigns are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
activerss_ |
varchar2 |
Active RSS Interval | filters on the platform, writable | ||
activerss_ |
int64 |
Active RSS Items | filters on the platform, writable | ||
activerss_ |
varchar2 |
Active RSS URL | filters on the platform, writable | ||
addressid |
int64 |
Address ID | filters on the platform, writable | ||
analytics_ |
varchar2 |
Analytics Campaign Name | filters on the platform, writable | ||
automation |
int64 |
Automation | filters on the platform, writable | ||
basemessageid |
int64 |
Base Message ID | filters on the platform, writable | ||
basetemplateid |
varchar2 |
Base Template ID | filters on the platform, writable | ||
bounceid |
int64 |
Bounce ID | filters on the platform, writable | ||
cdate |
datetime |
Created | filters on the platform, writable, computed | ||
deletestamp |
datetime |
Deleted | filters on the platform, writable | ||
embed_ |
int64 |
Embed Images | filters on the platform, writable | ||
facebook |
int64 |
filters on the platform, writable | |||
formid |
int64 |
Form ID | filters on the platform, writable | ||
forwards |
int64 |
Forwards | filters on the platform, writable | ||
hardbounces |
int64 |
Hard Bounces | filters on the platform, writable | ||
htmlunsub |
varchar2 |
HTML Unsubscribe | filters on the platform, writable | ||
htmlunsubdata |
int64 |
HTML Unsubscribe Data | filters on the platform, writable | ||
id |
int64 |
ID | filters on the platform, writable, computed | ||
ip4 |
int64 |
IPv4 Address | filters on the platform, writable | ||
laststep |
varchar2 |
Last Step | filters on the platform, writable | ||
ldate |
datetime |
itgen_acn_ldate | filters on the platform, writable | ||
linkclicks |
int64 |
Link Clicks | filters on the platform, writable | ||
mail_ |
int64 |
Mail Cleanup | filters on the platform, writable | ||
mail_ |
int64 |
Mail Send | filters on the platform, writable | ||
mail_ |
int64 |
Mail Transfer | filters on the platform, writable | ||
mailer_ |
int64 |
Mailer Log File | filters on the platform, writable | ||
managetext |
int64 |
Manage Text | filters on the platform, writable | ||
mdate |
datetime |
Last Modified | filters on the platform, writable, computed | ||
name |
varchar2 |
Name | filters on the platform, writable | ||
opens |
int64 |
Number of Opens | filters on the platform, writable | ||
public |
int64 |
Public | filters on the platform, writable | ||
realcid |
int64 |
Real CID | filters on the platform, writable | ||
recurring |
varchar2 |
Recurring | filters on the platform, writable | ||
reminder_ |
varchar2 |
Reminder Field | filters on the platform, writable | ||
reminder_ |
varchar2 |
Reminder Format | filters on the platform, writable | ||
reminder_ |
varchar2 |
Reminder Last Cron Run | filters on the platform, writable | ||
reminder_ |
int64 |
Reminder Offset | filters on the platform, writable | ||
reminder_ |
varchar2 |
Reminder Offset Sign | filters on the platform, writable | ||
reminder_ |
varchar2 |
Reminder Offset Type | filters on the platform, writable | ||
reminder_ |
varchar2 |
Reminder Type | filters on the platform, writable | ||
replies |
int64 |
Replies | filters on the platform, writable | ||
replysys |
int64 |
Reply System | filters on the platform, writable | ||
responder_ |
int64 |
Responder Existing | filters on the platform, writable | ||
responder_ |
int64 |
Responder Offset | filters on the platform, writable | ||
responder_ |
varchar2 |
Responder Type | filters on the platform, writable | ||
schedule |
int64 |
Schedule | filters on the platform, writable | ||
scheduleddate |
datetime |
Scheduled Date | filters on the platform, writable | ||
sdate |
datetime |
itgen_acn_sdate | filters on the platform, writable | ||
segmentid |
int64 |
Segment ID | filters on the platform, writable | ||
send_ |
int64 |
Send Amount | filters on the platform, writable | ||
sendid |
int64 |
Sender ID | filters on the platform, writable | ||
seriesid |
int64 |
Series ID | filters on the platform, writable | ||
socialshares |
int64 |
Social Shares | filters on the platform, writable | ||
softbounces |
int64 |
Soft Bounces | filters on the platform, writable | ||
source |
varchar2 |
Source | filters on the platform, writable | ||
split_ |
int64 |
Split Content | filters on the platform, writable | ||
split_ |
int64 |
Split Offset | filters on the platform, writable | ||
split_ |
varchar2 |
Split Offset Type | filters on the platform, writable | ||
split_ |
varchar2 |
Split Type | filters on the platform, writable | ||
split_ |
int64 |
Split Winner Awaiting | filters on the platform, writable | ||
split_ |
int64 |
Split Winner Message ID | filters on the platform, writable | ||
status |
int64 |
Status | filters on the platform, writable | ||
subscriberclicks |
int64 |
Subscriber Clicks | filters on the platform, writable | ||
survey |
varchar2 |
Survey | filters on the platform, writable | ||
textunsub |
varchar2 |
Text Unsubscribe | filters on the platform, writable | ||
textunsubdata |
int64 |
Text Unsubscribe Data | filters on the platform, writable | ||
threadid |
int64 |
Thread ID | filters on the platform, writable | ||
total_ |
int64 |
Total Amount | filters on the platform, writable | ||
tracklinks |
varchar2 |
Track Links | filters on the platform, writable | ||
tracklinksanalytics |
int64 |
Track Link Analytics | filters on the platform, writable | ||
trackreads |
int64 |
Track Reads | filters on the platform, writable | ||
trackreadsanalytics |
int64 |
Track Reads Analytics | filters on the platform, writable | ||
tweet |
int64 |
Tweet | filters on the platform, writable | ||
type |
varchar2 |
Type | filters on the platform, writable | ||
uniqueforwards |
int64 |
Unique Forwards | filters on the platform, writable | ||
uniquelinkclicks |
int64 |
Unique Link Clicks | filters on the platform, writable | ||
uniqueopens |
int64 |
Unique Opens | filters on the platform, writable | ||
uniquereplies |
int64 |
Unique Replies | filters on the platform, writable | ||
unsubreasons |
int64 |
Unsubscription Reasons | filters on the platform, writable | ||
unsubscribes |
int64 |
Unsubscribes | filters on the platform, writable | ||
updates |
int64 |
Updates | filters on the platform, writable | ||
user |
int64 |
User | filters on the platform, writable | ||
userid |
int64 |
User ID | filters on the platform, writable | ||
waitpreview |
int64 |
Wait Preview | filters on the platform, writable | ||
willrecur |
int64 |
Will Recur | filters on the platform, writable |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver:
Changes of This Table, 26.0 to 27.0
ActiveCampaign.V3.Campaigns can no longer insert
The driver no longer supports insert on ActiveCampaign.V3.Campaigns. The capability never worked in 26.0, so no working statement is affected.
true→false- importance 2
ActiveCampaign.V3.Campaigns can no longer update
The driver no longer supports update on ActiveCampaign.V3.Campaigns. The capability never worked in 26.0, so no working statement is affected.
true→false- importance 2