invantive documentation
Forum di supporto InvantiveAccedi / Registrati

Deals: ActiveCampaign Deals

Questa pagina non è ancora disponibile nella tua lingua; viene visualizzata la versione originale.

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.
customerAccount int64 Customer Account filters on the platform, writable
description varchar2(4000) 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
isDisabled 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.
winProbability int64 Win Probability filters on the platform, writable
winProbabilityMdate datetime Win Probability Last Updated filters on the platform, writable

Keys

Key Column Refers to Kind Description
Deals_account_fk account Accounts.id Key
Deals_customerAccount_cnd customerAccount 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_fk group Pipelines.id Key
Deals_owner_fk owner Users.id Key
Deals_stage_fk stage Stages.id Key

Referenced By

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver:

Modifiche apportate a questa tabella, da 26.0 a 27.0

  • + hash (varchar2)

Tutte le sostituzioni del conducente, da 26.0 a 27.0