invantive documentation
Invantive Support ForumsLog In / Sign Up

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_interval varchar2 Active RSS Interval filters on the platform, writable
activerss_items int64 Active RSS Items filters on the platform, writable
activerss_url varchar2 Active RSS URL filters on the platform, writable
addressid int64 Address ID filters on the platform, writable
analytics_campaign_name 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_images int64 Embed Images filters on the platform, writable
facebook int64 Facebook 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_cleanup int64 Mail Cleanup filters on the platform, writable
mail_send int64 Mail Send filters on the platform, writable
mail_transfer int64 Mail Transfer filters on the platform, writable
mailer_log_file 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_field varchar2 Reminder Field filters on the platform, writable
reminder_format varchar2 Reminder Format filters on the platform, writable
reminder_last_cron_run varchar2 Reminder Last Cron Run filters on the platform, writable
reminder_offset int64 Reminder Offset filters on the platform, writable
reminder_offset_sign varchar2 Reminder Offset Sign filters on the platform, writable
reminder_offset_type varchar2 Reminder Offset Type filters on the platform, writable
reminder_type 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_existing int64 Responder Existing filters on the platform, writable
responder_offset int64 Responder Offset filters on the platform, writable
responder_type 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_amt 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_content int64 Split Content filters on the platform, writable
split_offset int64 Split Offset filters on the platform, writable
split_offset_type varchar2 Split Offset Type filters on the platform, writable
split_type varchar2 Split Type filters on the platform, writable
split_winner_awaiting int64 Split Winner Awaiting filters on the platform, writable
split_winner_messageid 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_amt 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

All changes of the driver, 26.0 to 27.0