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

# Orders: ActiveCampaign Orders

`insert` `REST`

- Catalogue : `ActiveCampaign`
- Schéma : `CustomObjects`
- Clés primaires : `id`
- Label: Orders

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

## Résumé

Orders imported into ActiveCampaign

## Source de l'API

- Point de terminaison : `/customObjects/records/42376388-ff77-49e2-a175-fd92566d749c`

## Caractéristiques de performance

| Characteristic | Value |
|---|---:|
| Latence moyenne d'accès (ms) | 264 |
| Nombre de lignes par minute en mode de balayage complet | 13,400 |

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

## Colonnes de table

Les colonnes de la table `Orders` 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 |
|---|---|---|:---:|---|---|
| `accepts_marketing` | `varchar2` | Accepte les offres commerciales | [ ] | filters on the platform, writable, `fields[?(@.id=='accepts-marketing')].value` | Accepte les offres commerciales |
| `cart_id` | `varchar2` | Référence du panier | [ ] | filters on the platform, writable, `fields[?(@.id=='cart-id')].value` | Référence du panier |
| `connection_id` | `varchar2` | Identifiant de connexion | [ ] | filters on the platform, writable, `fields[?(@.id=='connection-id')].value` | Identifiant de connexion |
| `createdTimestamp` | `datetime` | Created | [ ] | filters on the platform, writable, computed | Moment of creation. |
| `created_by_recurring_payment` | `varchar2` | Créé par Recurring Payment | [ ] | filters on the platform, writable, `fields[?(@.id=='created-by-recurring-payment')].value` | Created By Recurring Payment |
| `creation_source` | `varchar2` | Source de la création | [ ] | filters on the platform, writable, `fields[?(@.id=='creation-source')].value` | Source de la création |
| `customer_locale` | `varchar2` | Paramètres régionaux du client | [ ] | filters on the platform, writable, `fields[?(@.id=='customer-locale')].value` | Paramètres régionaux du client |
| `customer_phone` | `varchar2` | itgen_acn_customer_phone | [ ] | filters on the platform, writable, `fields[?(@.id=='customer-phone')].value` | Customer Phone |
| `discounts` | `varchar2` | Discounts | [ ] | filters on the platform, writable, `fields[?(@.id=='discounts')].value` | Order Discount |
| `discounts_amount` | `decimal` | Montant des remises | [ ] | filters on the platform, writable, `fields[?(@.id=='discounts-amount')].value` | Montant des remises |
| `discounts_amount_currency` | `varchar2` | Réductions Montant Devise | [ ] | filters on the platform, writable, `fields[?(@.id=='discounts-amount')].currency` | Currency of the amount in column discounts_amount. |
| `email` | `varchar2` | Adresse de courriel | [ ] | filters on the platform, writable, `fields[?(@.id=='email')].value` | Email |
| `field_billing_address_address_1` | `varchar2` | Adresse de facturation sur site - Adresse 1 | [ ] | filters on the platform, writable, `fields[?(@.id=='field-billing-address-address-1')].value` | Billing Address Address Line 1 |
| `field_billing_address_address_2` | `varchar2` | Adresse de facturation sur site - Adresse 2 | [ ] | filters on the platform, writable, `fields[?(@.id=='field-billing-address-address-2')].value` | Billing Address Address Line 2 |
| `field_billing_address_address_3` | `varchar2` | Adresse de facturation sur site - Adresse 3 | [ ] | filters on the platform, writable, `fields[?(@.id=='field-billing-address-address-3')].value` | Billing Address Address Line 3 |
| `field_billing_address_city` | `varchar2` | Champ « Adresse de facturation » Ville | [ ] | filters on the platform, writable, `fields[?(@.id=='field-billing-address-city')].value` | Ville de facturation |
| `field_billing_address_company` | `varchar2` | Champ « Adresse de facturation » : Entreprise | [ ] | filters on the platform, writable, `fields[?(@.id=='field-billing-address-company')].value` | Adresse de facturation de l'entreprise |
| `field_billing_address_country` | `varchar2` | Champ « Adresse de facturation » Pays | [ ] | filters on the platform, writable, `fields[?(@.id=='field-billing-address-country')].value` | Pays de l'adresse de facturation |
| `field_billing_address_email` | `varchar2` | Champ « Adresse de facturation » E-mail | [ ] | filters on the platform, writable, `fields[?(@.id=='field-billing-address-email')].value` | Adresse de facturation E-mail |
| `field_billing_address_first_name` | `varchar2` | Champ « Adresse de facturation » Prénom | [ ] | filters on the platform, writable, `fields[?(@.id=='field-billing-address-first-name')].value` | Adresse de facturation : Prénom |
| `field_billing_address_last_name` | `varchar2` | Champ « Adresse de facturation » : Nom de famille | [ ] | filters on the platform, writable, `fields[?(@.id=='field-billing-address-last-name')].value` | Nom de famille (adresse de facturation) |
| `field_billing_address_phone` | `varchar2` | Champ « Adresse de facturation » Téléphone | [ ] | filters on the platform, writable, `fields[?(@.id=='field-billing-address-phone')].value` | Billing Address Phone Number |
| `field_billing_address_postal` | `varchar2` | Champ « Adresse de facturation » Code postal | [ ] | filters on the platform, writable, `fields[?(@.id=='field-billing-address-postal')].value` | Code postal de l'adresse de facturation |
| `field_billing_address_province` | `varchar2` | Champ « Adresse de facturation » Province | [ ] | filters on the platform, writable, `fields[?(@.id=='field-billing-address-province')].value` | Province de l'adresse de facturation |
| `field_shipping_address_address_1` | `varchar2` | Champ « Adresse de livraison » - Adresse 1 | [ ] | filters on the platform, writable, `fields[?(@.id=='field-shipping-address-address-1')].value` | Shipping Address Address Line 1 |
| `field_shipping_address_address_2` | `varchar2` | Champ « Adresse de livraison » - Adresse 2 | [ ] | filters on the platform, writable, `fields[?(@.id=='field-shipping-address-address-2')].value` | Shipping Address Address Line 2 |
| `field_shipping_address_address_3` | `varchar2` | Champ « Adresse de livraison » - Adresse 3 | [ ] | filters on the platform, writable, `fields[?(@.id=='field-shipping-address-address-3')].value` | Shipping Address Address Line 3 |
| `field_shipping_address_city` | `varchar2` | Champ « Adresse de livraison » - Ville | [ ] | filters on the platform, writable, `fields[?(@.id=='field-shipping-address-city')].value` | Ville de livraison |
| `field_shipping_address_company` | `varchar2` | Champ « Adresse de livraison » (entreprise) | [ ] | filters on the platform, writable, `fields[?(@.id=='field-shipping-address-company')].value` | Adresse de livraison de l'entreprise |
| `field_shipping_address_country` | `varchar2` | Champ « Adresse de livraison » – Pays | [ ] | filters on the platform, writable, `fields[?(@.id=='field-shipping-address-country')].value` | Pays de livraison |
| `field_shipping_address_email` | `varchar2` | Champ « Adresse de livraison » E-mail | [ ] | filters on the platform, writable, `fields[?(@.id=='field-shipping-address-email')].value` | Adresse de livraison E-mail |
| `field_shipping_address_first_name` | `varchar2` | Champ « Adresse de livraison » Prénom | [ ] | filters on the platform, writable, `fields[?(@.id=='field-shipping-address-first-name')].value` | Adresse de livraison Prénom |
| `field_shipping_address_last_name` | `varchar2` | Champ « Adresse de livraison » Nom de famille | [ ] | filters on the platform, writable, `fields[?(@.id=='field-shipping-address-last-name')].value` | Adresse de livraison : Nom de famille |
| `field_shipping_address_phone` | `varchar2` | Champ « Adresse de livraison » Téléphone | [ ] | filters on the platform, writable, `fields[?(@.id=='field-shipping-address-phone')].value` | Adresse de livraison Téléphone |
| `field_shipping_address_postal` | `varchar2` | Champ « Adresse de livraison » Code postal | [ ] | filters on the platform, writable, `fields[?(@.id=='field-shipping-address-postal')].value` | Adresse de livraison (code postal) |
| `field_shipping_address_province` | `varchar2` | Champ « Adresse de livraison » - Province | [ ] | filters on the platform, writable, `fields[?(@.id=='field-shipping-address-province')].value` | Province de livraison |
| `final_amount` | `decimal` | Montant final | [ ] | filters on the platform, writable, `fields[?(@.id=='final-amount')].value` | Montant final |
| `final_amount_currency` | `varchar2` | Montant final Devise | [ ] | filters on the platform, writable, `fields[?(@.id=='final-amount')].currency` | Currency of the amount in column final_amount. |
| `id` | `varchar2` | ID | [x] | filters on the platform, writable, computed | Unique ID of the record, in the form of a GUID. |
| `is_test_order` | `varchar2` | Commande de test | [ ] | filters on the platform, writable, `fields[?(@.id=='is-test-order')].value` | Commande de test |
| `legacy_connection_id` | `int64` | Identifiant de connexion hérité | [ ] | filters on the platform, writable, `fields[?(@.id=='legacy-connection-id')].value` | Identifiant de connexion hérité |
| `location_id` | `varchar2` | ID d'emplacement | [ ] | filters on the platform, writable, `fields[?(@.id=='location-id')].value` | ID d'emplacement |
| `normalized_status` | `varchar2` | Statut normalisé | [ ] | filters on the platform, writable, `fields[?(@.id=='normalized-status')].value` | Statut de la commande |
| `notes` | `varchar2` | Notes | [ ] | filters on the platform, writable, `fields[?(@.id=='notes')].value` | Notes |
| `order_number` | `varchar2` | Numéro de Commande | [ ] | filters on the platform, writable, `fields[?(@.id=='order-number')].value` | Numéro de Commande |
| `order_url` | `varchar2` | URL de commande | [ ] | filters on the platform, writable, `fields[?(@.id=='order-url')].value` | URL de commande |
| `payment_method` | `varchar2` | Mode de paiement | [ ] | filters on the platform, writable, `fields[?(@.id=='payment-method')].value` | Mode de paiement |
| `primary_contact` | `varchar2` | Contact principal | [ ] | filters on the platform, writable, `relationships.primary-contact` | Contact for Order |
| `sales_channel` | `varchar2` | Le canal de vente | [ ] | filters on the platform, writable, `fields[?(@.id=='sales-channel')].value` | Channel |
| `schemaId` | `varchar2` | Identifiant du schéma | [ ] | filters on the platform, writable, computed | Unique ID of the custom object the record belongs to. |
| `shipping_amount` | `decimal` | Montant d'expédition | [ ] | filters on the platform, writable, `fields[?(@.id=='shipping-amount')].value` | Montant d'expédition |
| `shipping_amount_currency` | `varchar2` | Frais de livraison Devise | [ ] | filters on the platform, writable, `fields[?(@.id=='shipping-amount')].currency` | Currency of the amount in column shipping_amount. |
| `shipping_method` | `varchar2` | Mode d'expédition | [ ] | filters on the platform, writable, `fields[?(@.id=='shipping-method')].value` | Mode d'expédition |
| `store_created_date` | `datetime` | Date de création du magasin | [ ] | filters on the platform, writable, `fields[?(@.id=='store-created-date')].value` | Date de création du magasin |
| `store_customer_id` | `varchar2` | Enregistrer l'identifiant client du magasin | [ ] | filters on the platform, writable, `fields[?(@.id=='store-customer-id')].value` | Store's Customer ID |
| `store_external_order_id` | `varchar2` | Enregistrer l'identifiant de commande externe | [ ] | filters on the platform, writable, `fields[?(@.id=='store-external-order-id')].value` | Store's External Order ID |
| `store_modified_date` | `datetime` | Date de modification en magasin | [ ] | filters on the platform, writable, `fields[?(@.id=='store-modified-date')].value` | Date de modification en magasin |
| `store_order_id` | `varchar2` | Référence de la commande en magasin | [ ] | filters on the platform, writable, `fields[?(@.id=='store-order-id')].value` | Store's Order ID |
| `store_status` | `varchar2` | État du magasin | [ ] | filters on the platform, writable, `fields[?(@.id=='store-status')].value` | Store's Order Status |
| `updatedTimestamp` | `datetime` | Dernière modification | [ ] | filters on the platform, writable, computed | Moment of last change. |


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

<div class="rn-item" id="ACN-27.0-D007">

##### La table ActiveCampaign.CustomObjects.Orders est ajoutée

La table comporte 60 colonnes et permet les opérations de sélection et d'insertion.

<div class="rn-chips">

- importance 3

</div>

</div>

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