Deals: ActiveCampaign Deals
popular insert update delete REST
- Catalogus:
ActiveCampaign - Schema:
V3 - Primaire sleutels:
id - Label: Deals
Je kunt gegevens ophalen en wijzigen met insert, update en delete.
API-bron
- Eindpunt:
/deals
Prestatiekenmerken
| Characteristic | Value |
|---|---|
| Gemiddelde toegangsvertraging (ms) | 228 |
| Aantal rijen per minuut bij volledige scan | 13,500 |
Het resultaat kan op de client in de Cache worden opgeslagen.
Tabelkolommen
De kolommen van de tabel Deals worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.
| Name | Datatype | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
account |
int64 |
Account | filters on the platform, writable | Reference to the account. | |
activitycount |
int64 |
Aantal Activiteiten | 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 |
Klantaccount | 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 |
Laatst Gewijzigd | filters on the platform, writable, computed | Last modified date. | |
nextdate |
datetime |
Volgende Datum | filters on the platform, writable | ||
nextdealid |
int64 |
Volgende Deal ID | filters on the platform, writable | ||
nexttaskid |
int64 |
Volgende Taak 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 |
Winkans | filters on the platform, writable | ||
win |
datetime |
Winwaarschijnlijkheid Laatst Bijgewerkt | filters on the platform, writable |
Toetsen
| Key | Column | Verwijst naar | 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 |
Geciteerd door
- DealCustomFieldValues
dealId(Candidate) - DealWithActivities
deal(Candidate) - SecondaryContacts
deal(Candidate)
Release Notes
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver:
Wijzigingen in deze tabel, 26.0 tot 27.0
+hash(varchar2)