DealWithContacts: ActiveCampaign Deal Contacts
read only REST
- Catalog:
ActiveCampaign - Schema:
V3 - Primary Keys:
id - Label: Deal Contacts
Can only retrieve data.
API Source
- Endpoint:
/deals?include=contact
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 DealWithContacts 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 |
|---|---|---|---|---|---|
adate |
datetime |
itgen_acn_adate | filters on the platform, writable | ||
anonymized |
int64 |
Anonymized | filters on the platform, writable | ||
bounced_ |
datetime |
Bounced Date | filters on the platform, writable | ||
bounced_ |
int64 |
Bounced Hard | filters on the platform, writable | ||
bounced_ |
int64 |
Bounced Soft | filters on the platform, writable | ||
cdate |
datetime |
Created | filters on the platform, writable, computed | ||
created_ |
varchar2 |
Created by | filters on the platform, writable, computed | ||
created_ |
datetime |
Created | filters on the platform, writable, computed | ||
created_ |
datetime |
Created UTC Timestamp | filters on the platform, writable, computed | ||
deleted |
int64 |
Deleted | filters on the platform, writable | ||
deleted_ |
datetime |
Deleted At | filters on the platform, writable | ||
edate |
datetime |
itgen_acn_edate | filters on the platform, writable | ||
email |
varchar2 |
Email Address | filters on the platform, writable | ||
email_ |
varchar2 |
Email Domain | filters on the platform, writable | ||
email_ |
char |
Email Empty | filters on the platform, writable | ||
email_ |
varchar2 |
Email Local | filters on the platform, writable | ||
first |
varchar2 |
First Name | filters on the platform, writable | ||
gravatar |
int64 |
Gravatar | filters on the platform, writable | ||
hash |
varchar2 |
Hash | filters on the platform, writable | ||
id |
int64 |
ID | filters on the platform, writable, computed | Unique ID. | |
ip |
int64 |
IP Address | filters on the platform, writable | ||
last |
varchar2 |
Last Name | filters on the platform, writable | ||
orgid |
int64 |
Organisation ID | filters on the platform, writable | ||
orgname |
varchar2 |
Organisation Name | filters on the platform, writable | ||
phone |
varchar2 |
Phone | filters on the platform, writable | ||
rating_ |
datetime |
Rating Date | filters on the platform, writable | ||
segmentio_ |
int64 |
Segment ID | filters on the platform, writable | ||
sentcnt |
int64 |
Sent Count | filters on the platform, writable | ||
sentiment |
varchar2 |
Sentiment | filters on the platform, writable | ||
socialdata_ |
datetime |
Social Data Last Check | filters on the platform, writable | ||
ua |
varchar2 |
User Agent | filters on the platform, writable | ||
udate |
datetime |
Last Updated | filters on the platform, writable, computed | ||
updated_ |
varchar2 |
Updated by | filters on the platform, writable, computed | ||
updated_ |
datetime |
Updated | filters on the platform, writable, computed | ||
updated_ |
datetime |
Updated UTC Timestamp | filters on the platform, writable, computed |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: