---
title: "Contacts (ActiveCampaign)"
description: "Contacts"
language: fr
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/fr/datamodels/activecampaign/ActiveCampaign.V3.Contacts
original: https://documentation.invantive.eu/en/datamodels/activecampaign/ActiveCampaign.V3.Contacts
updated: 2026-11-16T13:02:14Z
license: https://documentation.invantive.eu/fr/
---

# 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 | [x] | writable |  |
| `bounced_soft` | `int64` | Rebondi doux | [x] | 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 | [x] | 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 | [x] | writable |  |
| `hash` | `varchar2` | Hash | [ ] | writable |  |
| `id` | `int64` | ID | [x] | filters on the platform, writable, computed |  |
| `ip` | `int64` | Adresse IP | [x] | 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 | [x] | 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 | [x] | 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

```sql
--
-- 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 :

- [ActiveCampaign](/fr/release-notes/drivers?driver=activecampaign)

### Modifications apportées à cette table, 26.0 à 27.0

<a id="ACN-27.0-D039"></a><a id="ACN-27.0-D040"></a><a id="ACN-27.0-D041"></a><a id="ACN-27.0-D042"></a><a id="ACN-27.0-D043"></a><a id="ACN-27.0-D044"></a><a id="ACN-27.0-D045"></a><a id="ACN-27.0-D046"></a><a id="ACN-27.0-D047"></a><a id="ACN-27.0-D048"></a><a id="ACN-27.0-D049"></a><a id="ACN-27.0-D050"></a><a id="ACN-27.0-D051"></a><a id="ACN-27.0-D052"></a><a id="ACN-27.0-D053"></a>

- `+` `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`)

<details>
<summary>

3 modifications supplémentaires

</summary>

<a id="ACN-27.0-D054"></a><a id="ACN-27.0-D055"></a><a id="ACN-27.0-D056"></a>

- `+` `updated_utc_timestamp` (`datetime`)
- `+` `whatsapp_id` (`varchar2`)
- `+` `whatsapp_username` (`varchar2`)

</details>

[Toutes les modifications apportées au chauffeur, 26.0 à 27.0](/fr/release-notes/drivers?driver=activecampaign&step=26.0-to-27.0#activecampaign-26.0-to-27.0)
