invantive documentation
Invantive Support ForumsLog In / Sign Up

DealWithTasks: ActiveCampaign Deal Tasks

read only REST

  • Catalog: ActiveCampaign
  • Schema: V3
  • Primary Keys: id
  • Label: Deal Tasks

Can only retrieve data.

API Source

  • Endpoint: /deals?include=tasks

Performance Characteristics

Characteristic Value
Average access latency (ms) 264
Full scan rows per minute 3,390

The result can be cached on the client.

Table Columns

The columns of the table DealWithTasks 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
assigned_date datetime Assigned Date filters on the platform, writable
assignee int64 Assignee filters on the platform, writable
automation int64 Automation filters on the platform, writable Automation ID.
cdate datetime Created filters on the platform, writable, computed
created_utc_timestamp datetime Created UTC Timestamp filters on the platform, writable, computed
createdseriesid int64 Created Series ID filters on the platform, writable
dealTasktype int64 Task Type filters on the platform, writable
doneAutomation int64 Done Automation filters on the platform, writable
done_by varchar2 Done by filters on the platform, writable
done_utc_timestamp datetime Done UTC Timestamp filters on the platform, writable
donedate datetime Done Date filters on the platform, writable
duedate datetime Due Date filters on the platform, writable
duration int64 Duration filters on the platform, writable
edate datetime itgen_acn_edate filters on the platform, writable
id int64 ID filters on the platform, writable, computed Unique ID.
note varchar2 Note filters on the platform, writable
outcome_id int64 Outcome ID filters on the platform, writable
outcome_info varchar2 Outcome Info filters on the platform, writable
relid int64 Relationship ID filters on the platform, writable
reltype varchar2 Relationship Type filters on the platform, writable
status int64 Status filters on the platform, writable
title varchar2 Title filters on the platform, writable
udate datetime Last Updated filters on the platform, writable, computed
updated_by varchar2 Updated by filters on the platform, writable
updated_utc_timestamp datetime Updated UTC Timestamp filters on the platform, writable, computed
user int64 User filters on the platform, writable

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: