invantive documentation
Invantive Support ForumsLog In / Sign Up

DealActivitiesNonEmail: ActiveCampaign Deal Activities Non Email

read only

  • Catalog: ActiveCampaign
  • Schema: Views
  • Label: Deal Activities Non Email

Can only retrieve data.

Performance Characteristics

Characteristic Value
Average access latency (ms) 264
Full scan rows per minute 13,400

The result can be cached on the client.

Table Columns

The columns of the table DealActivitiesNonEmail 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
automation int64 Automation filters on the platform, writable, computed
cdate datetime Created filters on the platform, writable, computed
d_id int64 Deal ID filters on the platform, writable, computed
d_stageid int64 Stage ID filters on the platform, writable, computed
dataAction varchar2 Data Element Action filters on the platform, writable
dataId int64 Data Element ID filters on the platform, writable
dataOldval varchar2 Data Element Old Value filters on the platform, writable
dataType varchar2 Data Element Type filters on the platform, writable
deal int64 Deal filters on the platform, writable, computed
deleted char Deleted filters on the platform, writable
id int64 ID filters on the platform, writable, computed
isAddtask char Is Add Task filters on the platform, writable
seriesid int64 Series ID filters on the platform, writable
sortdate datetime Sorting Date filters on the platform, writable
stage int64 Stage filters on the platform, writable, computed
user int64 User filters on the platform, writable, computed
userid int64 User ID filters on the platform, writable, computed

Release Notes

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