invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

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.
customerAccount int64 Klantaccount 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 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.
winProbability int64 Winkans filters on the platform, writable
winProbabilityMdate datetime Winwaarschijnlijkheid Laatst Bijgewerkt filters on the platform, writable

Toetsen

Key Column Verwijst naar 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

Geciteerd door

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)

Alle wisselingen van de Driver, 26.0 tot 27.0