invantive documentation
Invantive Support ForumsLog In / Sign Up

DealsByContactId: ActiveCampaign Deals by Contact ID

read only REST

  • Catalog: ActiveCampaign
  • Schema: V3
  • Primary Keys: id
  • Label: Deals by Contact ID

Can only retrieve data.

API Source

  • Endpoint: /contacts/{id}/deals

Performance Characteristics

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

The result can be cached on the client.

Parameters

Name Data Type Required Default Documentation
id `` ID of the record.

Table Columns

The columns of the table DealsByContactId 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
account int64 Account filters on the platform, writable
activitycount int64 Activity Count filters on the platform, writable
cdate datetime Created filters on the platform, writable, computed
contact int64 Contact filters on the platform, writable
currency varchar2 Currency filters on the platform, writable
customerAccount int64 Customer Account filters on the platform, writable
description varchar2(4000) Description filters on the platform, writable
edate datetime itgen_acn_edate filters on the platform, writable
group int64 Group filters on the platform, writable
hash varchar2 Hash filters on the platform, writable
id int64 ID filters on the platform, writable, computed
isDisabled char Disabled filters on the platform, writable
mdate datetime Last Modified filters on the platform, writable, computed
nextTask int64 Next Task filters on the platform, writable
nextdate datetime Next Date filters on the platform, writable
nextdealid int64 Next Deal ID filters on the platform, writable
nexttaskid int64 Next Task ID filters on the platform, writable
organization int64 Account filters on the platform, writable Deprecated. Do not use.
owner int64 Owner filters on the platform, writable
percent int64 Percentage filters on the platform, writable
stage int64 Stage filters on the platform, writable
status int64 Status filters on the platform, writable
title varchar2 Title filters on the platform, writable
value int64 Value filters on the platform, writable
winProbability int64 Win Probability filters on the platform, writable
winProbabilityMdate datetime Win Probability Last Updated 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.DealsByContactId can no longer delete

The driver no longer supports delete on ActiveCampaign.V3.DealsByContactId. The capability never worked in 26.0, so no working statement is affected.

  • true → false
  • importance 2
ActiveCampaign.V3.DealsByContactId can no longer insert

The driver no longer supports insert on ActiveCampaign.V3.DealsByContactId. 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