invantive documentation
Forum di supporto InvantiveAccedi / Registrati

DealWithContacts: ActiveCampaign Deal Contacts

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

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_date datetime Bounced Date filters on the platform, writable
bounced_hard int64 Bounced Hard filters on the platform, writable
bounced_soft int64 Bounced Soft filters on the platform, writable
cdate datetime Created filters on the platform, writable, computed
created_by varchar2 Created by filters on the platform, writable, computed
created_timestamp datetime Created filters on the platform, writable, computed
created_utc_timestamp datetime Created UTC Timestamp filters on the platform, writable, computed
deleted int64 Deleted filters on the platform, writable
deleted_at 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_domain varchar2 Email Domain filters on the platform, writable
email_empty char Email Empty filters on the platform, writable
email_local varchar2 Email Local filters on the platform, writable
firstName 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
lastName 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_tstamp datetime Rating Date filters on the platform, writable
segmentio_id 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_lastcheck 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_by varchar2 Updated by filters on the platform, writable, computed
updated_timestamp datetime Updated filters on the platform, writable, computed
updated_utc_timestamp datetime Updated UTC Timestamp filters on the platform, writable, computed

Note di rilascio

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