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 | ||
customer |
int64 |
Customer Account | filters on the platform, writable | ||
description |
varchar2 |
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 | ||
is |
char |
Disabled | filters on the platform, writable | ||
mdate |
datetime |
Last Modified | filters on the platform, writable, computed | ||
next |
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 | ||
win |
int64 |
Win Probability | filters on the platform, writable | ||
win |
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