Deals: ActiveCampaign Deals
popular insert update delete REST
- Catalogue :
ActiveCampaign - Schéma :
V3 - Clés primaires :
id - Label: Deals
Permet de récupérer et de modifier des données à l'aide de insert, update et delete.
Source de l'API
- Point de terminaison :
/deals
Caractéristiques de performance
| Characteristic | Value |
|---|---|
| Latence moyenne d'accès (ms) | 228 |
| Nombre de lignes par minute en mode de balayage complet | 13,500 |
Le résultat peut être mis en cache côté client.
Colonnes de table
Les colonnes de la table Deals sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.
| Name | Type de données | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
account |
int64 |
Account | filters on the platform, writable | Reference to the account. | |
activitycount |
int64 |
Compteur d'activités | 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 |
Compte client | 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 |
Dernière modification | filters on the platform, writable, computed | Last modified date. | |
nextdate |
datetime |
Prochaine date | filters on the platform, writable | ||
nextdealid |
int64 |
ID de la prochaine offre | filters on the platform, writable | ||
nexttaskid |
int64 |
ID de tâche suivante | 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 |
Probabilité de gagner | filters on the platform, writable | ||
win |
datetime |
Dernière mise à jour de la probabilité de gagner | filters on the platform, writable |
Clés
| Key | Column | Se réfère à | 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 |
Référencée
- DealCustomFieldValues
dealId(Candidate) - DealWithActivities
deal(Candidate) - SecondaryContacts
deal(Candidate)
Notes de Version
Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :
Modifications apportées à cette table, 26.0 à 27.0
+hash(varchar2)
Toutes les modifications apportées au chauffeur, 26.0 à 27.0