invantive documentation
Forum di supporto InvantiveAccedi / Registrati

ContactAut: ActiveCampaign Contact Aut

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

read only

  • Catalog: ActiveCampaign
  • Schema: Views
  • Label: Contact Aut

Can only retrieve data.

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 ContactAut 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
adddate datetime Add Date filters on the platform, writable
automation int64 Automation filters on the platform, writable
batchid varchar2 Batch ID filters on the platform, writable
completeValue int64 Complete Value filters on the platform, writable
completed int64 Completed filters on the platform, writable
completedElements int64 Completed Elements filters on the platform, writable
contact int64 Contact filters on the platform, writable
contact_adate datetime itgen_acn_adate writable
contact_anonymized int64 Anonymized filters on the platform, writable, computed Whether the contact has been anonymised.
contact_best_send_hour int64 Best Send Hour filters on the platform, writable, computed Hour of the day with the highest expected engagement.
contact_bounced_date datetime Bounced Date writable
contact_bounced_hard int64 Bounced Hard writable
contact_bounced_soft int64 Bounced Soft writable
contact_cdate datetime Created filters on the platform, writable, computed
contact_created_by int64 Created by filters on the platform, writable, computed ID of the user that created the contact.
contact_created_timestamp datetime Created filters on the platform, writable, computed Moment of creation in the time zone of the account.
contact_created_utc_timestamp datetime Created UTC Timestamp filters on the platform, writable, computed Moment of creation in UTC.
contact_deleted int64 Deleted writable
contact_deleted_at datetime Deleted At filters on the platform, writable, computed Moment of deletion.
contact_edate datetime itgen_acn_edate writable
contact_email varchar2 Email Address filters on the platform, writable
contact_email_domain varchar2 Email Domain writable
contact_email_local varchar2 Email Local writable
contact_firstName varchar2 First Name filters on the platform, writable
contact_gravatar int64 Gravatar writable
contact_hash varchar2 Hash writable
contact_id int64 ID filters on the platform, writable, computed
contact_ip int64 IP Address writable
contact_lastName varchar2 Last Name filters on the platform, writable
contact_last_click_date datetime Last Click Date filters on the platform, writable, computed Moment the contact last clicked a link.
contact_last_mpp_open_date datetime Last Mpp Open Date filters on the platform, writable, computed Moment of the last open attributed to Apple Mail Privacy Protection.
contact_last_open_date datetime Last Open Date filters on the platform, writable, computed Moment the contact last opened a message.
contact_mpp_tracking int64 MPP Tracking filters on the platform, writable, computed Whether Apple Mail Privacy Protection was observed for this contact.
contact_organization int64 Account filters on the platform, writable Deprecated. Do not use.
contact_orgid int64 Organisation ID writable
contact_orgname varchar2 Organisation Name filters on the platform, writable, computed Name of the account the contact belongs to.
contact_phone varchar2 Phone filters on the platform, writable
contact_rating_tstamp datetime Rating Date writable
contact_segmentio_id int64 Segment ID writable
contact_sentcnt int64 Sent Count writable
contact_sms_consent int64 SMS Consent filters on the platform, writable, computed Consent status for SMS.
contact_sms_consent_updated_at datetime SMS Consent Updated at filters on the platform, writable, computed Moment the SMS consent was last changed.
contact_socialdata_lastcheck datetime Social Data Last Check writable
contact_ua varchar2 User Agent writable
contact_udate datetime Last Updated filters on the platform, writable, computed
contact_updated_by int64 Updated by filters on the platform, writable, computed ID of the user that last changed the contact.
contact_updated_timestamp datetime Updated filters on the platform, writable, computed Moment of last change in the time zone of the account.
contact_updated_utc_timestamp datetime Updated UTC Timestamp filters on the platform, writable, computed Moment of last change in UTC.
contact_whatsapp_id varchar2 Whatsapp ID filters on the platform, writable, computed WhatsApp identifier of the contact.
contact_whatsapp_username varchar2 Whatsapp Username filters on the platform, writable, computed WhatsApp user name of the contact.
id int64 ID filters on the platform, writable, computed
lastblock int64 Last Block filters on the platform, writable
lastdate datetime Last Date filters on the platform, writable
lastlogid int64 Last Log ID filters on the platform, writable
remdate datetime Reminder Date filters on the platform, writable
seriesid int64 Series ID filters on the platform, writable
startid int64 Start ID filters on the platform, writable
status int64 Status filters on the platform, writable
timespan int64 Timespan filters on the platform, writable
totalElements int64 Total Elements filters on the platform, writable

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

  • + contact_anonymized (int64)
  • + contact_best_send_hour (int64)
  • + contact_created_by (int64)
  • + contact_created_timestamp (datetime)
  • + contact_created_utc_timestamp (datetime)
  • + contact_deleted_at (datetime)
  • + contact_last_click_date (datetime)
  • + contact_last_mpp_open_date (datetime)
  • + contact_last_open_date (datetime)
  • + contact_mpp_tracking (int64)
  • + contact_orgname (varchar2)
  • + contact_sms_consent (int64)
  • + contact_sms_consent_updated_at (datetime)
  • + contact_updated_by (int64)
  • + contact_updated_timestamp (datetime)

3 ulteriori modifiche

  • + contact_updated_utc_timestamp (datetime)
  • + contact_whatsapp_id (varchar2)
  • + contact_whatsapp_username (varchar2)

Tutte le sostituzioni del conducente, da 26.0 a 27.0