invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

Contacts: ActiveCampaign Contacts

popular insert update delete REST

  • Catalogus: ActiveCampaign
  • Schema: V3
  • Primaire sleutels: id
  • Label: Contacts

Je kunt gegevens ophalen en wijzigen met insert, update en delete.

API-bron

  • Eindpunt: /contacts

Prestatiekenmerken

Characteristic Value
Gemiddelde toegangsvertraging (ms) 321
Aantal rijen per minuut bij volledige scan 12,000

Het resultaat kan op de client in de Cache worden opgeslagen.

Parameters

Name Datatype 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.

Tabelkolommen

De kolommen van de tabel Contacts 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
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 Beste Stuur Tijdstip filters on the platform, writable, computed Hour of the day with the highest expected engagement.
bounced_date datetime Datum Afgewezen writable
bounced_hard int64 Hard Afgewezen writable
bounced_soft int64 Zacht Afgewezen writable
cdate datetime Created filters on the platform, writable, computed
created_by int64 Gemaakt door 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 Aangemaakte UTC-tijdstempel filters on the platform, writable, computed Moment of creation in UTC.
deleted int64 Deleted writable
deleted_at datetime Verwijderd op filters on the platform, writable, computed Moment of deletion.
edate datetime itgen_acn_edate writable
email varchar2 E-mailadres filters on the platform, writable
email_domain varchar2 E-maildomein writable
email_local varchar2 E-mail Lokaal writable
firstName varchar2 Voornaam filters on the platform, writable
gravatar int64 Gravatar writable
hash varchar2 Hash writable
id int64 ID filters on the platform, writable, computed
ip int64 IP-adres writable
lastName varchar2 Achternaam filters on the platform, writable
last_click_date datetime Laatste Klik Datum filters on the platform, writable, computed Moment the contact last clicked a link.
last_mpp_open_date datetime Laatste Openingsdatum Mpp filters on the platform, writable, computed Moment of the last open attributed to Apple Mail Privacy Protection.
last_open_date datetime Laatste Openingsdatum filters on the platform, writable, computed Moment the contact last opened a message.
mpp_tracking int64 MPP-tracking 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 Organisatie ID writable
orgname varchar2 Organisatienaam 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 Beoordelingsdatum writable
segmentio_id int64 Segment ID writable
sentcnt int64 Verzonden Aantal writable
sms_consent int64 SMS-toestemming filters on the platform, writable, computed Consent status for SMS.
sms_consent_updated_at datetime SMS-toestemming Bijgewerkt op filters on the platform, writable, computed Moment the SMS consent was last changed.
socialdata_lastcheck datetime Sociale Data Laatste Controle writable
ua varchar2 Browser Specificatie writable
udate datetime Laatst Bijgewerkt filters on the platform, writable, computed
updated_by int64 Bijgewerkt door 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 Bijgewerkte UTC-tijdstempel 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.

Voorbeeldqueries

--
-- 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

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

  • + 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 meer wijzigingen

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

Alle wisselingen van de Driver, 26.0 tot 27.0