Deals: ActiveCampaign Deals
popular insert update delete REST
- Catalog:
ActiveCampaign - Schema:
V3 - Primary Keys:
id - Label: Deals
Can retrieve data and change data using insert, update and delete.
API Source
- Endpoint:
/deals
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 228 |
| Full scan rows per minute | 13,500 |
The result can be cached on the client.
Table Columns
The columns of the table Deals 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 | Reference to the account. | |
activitycount |
int64 |
Activity Count | filters on the platform, writable | ||
cdate |
datetime |
Created | filters on the platform, writable, computed | Creation date. | |
contact |
int64 |
Contact | filters on the platform, writable | ID of the primary contact. | |
currency |
varchar2 |
Currency | filters on the platform, writable | Currency code for the money value. | |
customer |
int64 |
Customer Account | filters on the platform, writable | ||
description |
varchar2 |
Description | filters on the platform, writable | Description of the deal. | |
edate |
datetime |
itgen_acn_edate | filters on the platform, writable | ||
group |
int64 |
Group | filters on the platform, writable | ID of the pipeline. | |
hash |
varchar2 |
Hash | filters on the platform, writable, computed | Hash identifying the deal in the user interface. | |
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 | Last modified date. | |
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 | ID of the user owning the deal. | |
percent |
decimal |
Percentage | filters on the platform, writable | Percentage of the deal. | |
stage |
int64 |
Stage | filters on the platform, writable | ID of the stage. | |
status |
int64 |
Status | filters on the platform, writable | 0 is Open, 1 is Won and 2 is Lost. | |
title |
varchar2 |
Title | filters on the platform, writable | Title of the deal. | |
value |
int64 |
Value | filters on the platform, writable | Values for the field. For currency fields in cents. | |
win |
int64 |
Win Probability | filters on the platform, writable | ||
win |
datetime |
Win Probability Last Updated | filters on the platform, writable |
Keys
| Key | Column | Refers to | Kind | Description |
|---|---|---|---|---|
Deals_ |
account |
Accounts.id |
Key | |
Deals_ |
customer |
Accounts.id |
Candidate | Follows from the name of the column and held in every filled row of the sandbox on 2026-10-31; not stated by ActiveCampaign in the places read. |
Deals_ |
group |
Pipelines.id |
Key | |
Deals_ |
owner |
Users.id |
Key | |
Deals_ |
stage |
Stages.id |
Key |
Referenced By
- DealCustomFieldValues
dealId(Candidate) - DealWithActivities
deal(Candidate) - SecondaryContacts
deal(Candidate)
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
+hash(varchar2)