invantive documentation
Forums d'Invantive SupportConnectez-vous/inscrivez-vous

Contacts: ActiveCampaign Contacts

popular insert update delete REST

  • Catalogue : ActiveCampaign
  • Schéma : V3
  • Clés primaires : id
  • Label: Contacts

Permet de récupérer et de modifier des données à l'aide de insert, update et delete.

Source de l'API

  • Point de terminaison : /contacts

Caractéristiques de performance

Characteristic Value
Latence moyenne d'accès (ms) 321
Nombre de lignes par minute en mode de balayage complet 12,000

Le résultat peut être mis en cache côté client.

Paramètres

Name Type de données Required Default Documentation
exclude `` Exclude from the response the contact with the given ID.
formid `` Filter contacts associated with the given form.
in_group_lists `` Set this to 'true' in order to return only contacts that the current user has permissions to see.
listid `` Filter contacts associated with the given list.
segmentid `` Return only contacts that match a list segment (this param initially returns segment information, when it is run a second time it will return contacts that match the segment).
seriesid `` Filter contacts associated with the given automation.
status `` -1 = Any, 0 = Unconfirmed, 1 = Active, 2 = Unsubscribed, 3 = Bounced.
tag `` Filter contacts associated with the given tag.
waitid `` Filter by contacts in the wait queue of an automation block.

Colonnes de table

Les colonnes de la table Contacts sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.

Name Type de données Label Required Marks Documentation
adate datetime itgen_acn_adate writable
anonymized int64 Anonymized filters on the platform, writable, computed Whether the contact has been anonymised.
best_send_hour int64 Meilleur moment pour envoyer un message filters on the platform, writable, computed Hour of the day with the highest expected engagement.
bounced_date datetime Date de rebond writable
bounced_hard int64 Rebondi dur writable
bounced_soft int64 Rebondi doux writable
cdate datetime Created filters on the platform, writable, computed
created_by int64 Crée par filters on the platform, writable, computed ID of the user that created the contact.
created_timestamp datetime Created filters on the platform, writable, computed Moment of creation in the time zone of the account.
created_utc_timestamp datetime Horodatage UTC de création filters on the platform, writable, computed Moment of creation in UTC.
deleted int64 Deleted writable
deleted_at datetime Supprimé le filters on the platform, writable, computed Moment of deletion.
edate datetime itgen_acn_edate writable
email varchar2 Adresse de courriel filters on the platform, writable
email_domain varchar2 Domaine de messagerie writable
email_local varchar2 Envoyer un e-mail à Local writable
firstName varchar2 Prénom filters on the platform, writable
gravatar int64 Gravatar writable
hash varchar2 Hash writable
id int64 ID filters on the platform, writable, computed
ip int64 Adresse IP writable
lastName varchar2 Nom filters on the platform, writable
last_click_date datetime Date du dernier clic filters on the platform, writable, computed Moment the contact last clicked a link.
last_mpp_open_date datetime Date de clôture de la dernière session du Mpp filters on the platform, writable, computed Moment of the last open attributed to Apple Mail Privacy Protection.
last_open_date datetime Date de la dernière ouverture filters on the platform, writable, computed Moment the contact last opened a message.
mpp_tracking int64 Suivi MPP filters on the platform, writable, computed Whether Apple Mail Privacy Protection was observed for this contact.
organization int64 Account filters on the platform, writable Deprecated.Do not use.
orgid int64 ID de l'organisation writable
orgname varchar2 Nom d'organisation filters on the platform, writable, computed Name of the account the contact belongs to.
phone varchar2 Phone filters on the platform, writable
rating_tstamp datetime Date d'évaluation writable
segmentio_id int64 ID de segment writable
sentcnt int64 Nombre d'envois writable
sms_consent int64 Consentement par SMS filters on the platform, writable, computed Consent status for SMS.
sms_consent_updated_at datetime Consentement par SMS - Mis à jour le filters on the platform, writable, computed Moment the SMS consent was last changed.
socialdata_lastcheck datetime Dernière vérification des données sociales writable
ua varchar2 Agent utilisateur writable
udate datetime Dernière mise à jour filters on the platform, writable, computed
updated_by int64 Mise à jour par filters on the platform, writable, computed ID of the user that last changed the contact.
updated_timestamp datetime Updated filters on the platform, writable, computed Moment of last change in the time zone of the account.
updated_utc_timestamp datetime Horodatage UTC mis à jour filters on the platform, writable, computed Moment of last change in UTC.
whatsapp_id varchar2 Whatsapp ID filters on the platform, writable, computed WhatsApp identifier of the contact.
whatsapp_username varchar2 Whatsapp Username filters on the platform, writable, computed WhatsApp user name of the contact.

Exemples de Queries

--
-- List of contacts in ActiveCampaign. Use ContactWithCustomFieldValues to retrieve and/or update contact custom fields.
--
-- Table documentation: https://documentation.invantive.eu/2017R2/activecampaign-data-model/webhelp/activecampaign-connector-v3-contacts.html
--
select *
from   ActiveCampaign.V3.Contacts@acn
limit  100

Notes de Version

Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :

Modifications apportées à cette table, 26.0 à 27.0

  • + anonymized (int64)
  • + best_send_hour (int64)
  • + created_by (int64)
  • + created_timestamp (datetime)
  • + created_utc_timestamp (datetime)
  • + deleted_at (datetime)
  • + last_click_date (datetime)
  • + last_mpp_open_date (datetime)
  • + last_open_date (datetime)
  • + mpp_tracking (int64)
  • + orgname (varchar2)
  • + sms_consent (int64)
  • + sms_consent_updated_at (datetime)
  • + updated_by (int64)
  • + updated_timestamp (datetime)

3 modifications supplémentaires

  • + updated_utc_timestamp (datetime)
  • + whatsapp_id (varchar2)
  • + whatsapp_username (varchar2)

Toutes les modifications apportées au chauffeur, 26.0 à 27.0