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

ActiveCampaign Modèle de données

ActiveCampaign is cloud software to automate the marketing, sales and support process of prospects, leads and customers. ActiveCampaign includes email campaigns, sales management, website integration, chat and advanced automatic workflows.

Authentication Authentication can be done using using a token. An API token can be generated from the ActiveCampaign menu: 'Settings' > 'Developer' > 'Key', as described on https://developers.activecampaign.com/reference#authentication.

Configurez cette plateforme dans Invantive Cloud : https://cloud.invantive.com/activecampaign

Les comparaisons de texte sur cette plateforme tiennent compte de la casse.

Plate-forme

  • Utilisable depuis : Invantive Cloud et les produits Invantive installés sur votre ordinateur ou votre serveur.
  • Type : une application accessible via son API.
  • Les données sont regroupées par catégorie, par exemple par entreprise ou par administration.
  • Les données peuvent être aussi bien écrites que lues.
  • Invantive Cloud plans: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
  • Status of the platform: https://status.activecampaign.com/.

Chiffres

Figure Count
Tables 100
Columns 1,738
Tableaux avec insert 46
Tables avec mise à jour 31
Tables avec la clause DELETE 38
Tableaux documentés 7

Affiche sur le modèle de données

PDF, 1 feuille A0

Sur une table de l'affiche : Zoom avant et arrière, les touches fléchées permettent de se déplacer, la touche 0 permet de revenir à la taille normale.

ActiveCampaign Modèle de données, Page 1 sur 1ActiveCampaign Modèle de donnéesà utiliser avec Invantive UniversalSQLCommuniqué 27.1.3-BETA+6294 · 01-11-2026V3 · Accounts · V3 · Connections · V3 · CustomFieldsPage 1 sur 1 · documentation.invantive.euV3 · Accounts×2ActiveCampaign.V3.AccountCustomFieldValues: Account Custom Field ValuesAccountCustomFieldValuesActiveCampaign.V3.AccountCustomFields: Account Custom FieldsAccountCustomFieldsActiveCampaign.V3.AccountWithCustomFieldValues: Account Custom FieldsAccountWithCustomFieldValuesActiveCampaign.V3.Accounts: AccountsAccountsActiveCampaign.V3.Associations: Account ContactsAssociationsActiveCampaign.V3.Automations: AutomationsAutomationsActiveCampaign.V3.ContactAutomations: Contact AutomationsContactAutomationsActiveCampaign.V3.ContactWithAccountContacts: Contact with Account ContactsContactWithAccountContactsActiveCampaign.V3.ContactWithTags: Contact TagsContactWithTagsActiveCampaign.V3.DealCustomFieldValues: Deal Custom Field ValuesDealCustomFieldValuesActiveCampaign.V3.DealCustomFields: Deal Custom FieldsDealCustomFieldsActiveCampaign.V3.DealWithActivities: Deal ActivitiesDealWithActivitiesActiveCampaign.V3.Deals: DealsDealsActiveCampaign.V3.PipelineWithStages: Pipeline with StagesPipelineWithStagesActiveCampaign.V3.Pipelines: PipelinesPipelinesActiveCampaign.V3.SecondaryContacts: Secondary ContactsSecondaryContactsActiveCampaign.V3.Stages: StagesStagesActiveCampaign.V3.Tags: TagsTagsActiveCampaign.V3.TaskTypes: Task TypesTaskTypesActiveCampaign.V3.Tasks: TasksTasksActiveCampaign.V3.Users: UsersUsersV3 · ConnectionsActiveCampaign.V3.Connections: ConnectionsConnectionsActiveCampaign.V3.eComCustomers: eCommerce CustomerseComCustomersActiveCampaign.V3.eComOrderProducts: eCommerce Order ProductseComOrderProductsActiveCampaign.V3.eComOrders: eCommerce OrderseComOrdersV3 · CustomFieldsActiveCampaign.V3.ContactWithCustomFieldValues: Contact Custom FieldsContactWithCustomFieldValuesActiveCampaign.V3.CustomFieldOptions: Custom Field OptionsCustomFieldOptionsActiveCampaign.V3.CustomFieldValues: Custom Field ValuesCustomFieldValuesActiveCampaign.V3.CustomFields: Custom FieldsCustomFieldsCustomObjectsActiveCampaign.CustomObjects.AccountMyTags: Account My TagsAccountMyTagsActiveCampaign.CustomObjects.BrowseAbandonments: Browse AbandonmentsBrowseAbandonmentsActiveCampaign.CustomObjects.ContactCars: Contact CarsContactCarsActiveCampaign.CustomObjects.DealMyTags: Deal My TagsDealMyTagsActiveCampaign.CustomObjects.Orders: OrdersOrdersActiveCampaign.CustomObjects.Products: ProductsProductsActiveCampaign.CustomObjects.RecurringPayments: Recurring PaymentsRecurringPaymentsNativeActiveCampaign.Native.NATIVEPLATFORMSCALARREQUESTS: Native Platform Scalar RequestsNATIVEPLATFORMSCALARREQUESTSV3ActiveCampaign.V3.Addresses: AddressesAddressesActiveCampaign.V3.Brandings: BrandingsBrandingsActiveCampaign.V3.Calendars: CalendarsCalendarsActiveCampaign.V3.Campaigns: CampaignsCampaignsActiveCampaign.V3.ContactWithBounceLogs: Contact Bounce LogsContactWithBounceLogsActiveCampaign.V3.ContactWithScoreValues: Contact with Score ValuesContactWithScoreValuesActiveCampaign.V3.CustomFieldRelations: Custom Field RelationsCustomFieldRelationsActiveCampaign.V3.CustomObjectSchemas: Custom Object SchemasCustomObjectSchemasActiveCampaign.V3.DealRoles: Deal RolesDealRolesActiveCampaign.V3.DealWithContacts: Deal ContactsDealWithContactsActiveCampaign.V3.DealWithNotes: Deal NotesDealWithNotesActiveCampaign.V3.DealWithTasks: Deal TasksDealWithTasksActiveCampaign.V3.EmailActivities: Email ActivitiesEmailActivitiesActiveCampaign.V3.EventTracking: Event TrackingEventTrackingActiveCampaign.V3.Events: EventsEventsActiveCampaign.V3.Forms: FormsFormsActiveCampaign.V3.GroupLimits: Group LimitsGroupLimitsActiveCampaign.V3.Groups: GroupsGroupsActiveCampaign.V3.Lists: ListsListsActiveCampaign.V3.Me: MeMeActiveCampaign.V3.Messages: MessagesMessagesActiveCampaign.V3.Notes: NotesNotesActiveCampaign.V3.OutstandingImports: Outstanding ImportsOutstandingImportsActiveCampaign.V3.RecentlyCompletedImports: Recently Completed ImportsRecentlyCompletedImportsActiveCampaign.V3.SavedResponses: Saved ResponsesSavedResponsesActiveCampaign.V3.Scores: ScoresScoresActiveCampaign.V3.Segments: SegmentsSegmentsActiveCampaign.V3.SiteTracking: Site TrackingSiteTrackingActiveCampaign.V3.SiteTrackingWhitelistedDomains: Site Tracking DomainsSiteTrackingWhitelistedDomainsActiveCampaign.V3.TrackEvents: Track EventTrackEventsActiveCampaign.V3.WebhookEvents: Webhook EventsWebhookEventsActiveCampaign.V3.Webhooks: WebhooksWebhooksVuesActiveCampaign.Views.ContactAut: Contact AutContactAutActiveCampaign.Views.ContactAutomationEntryCounts: Contact Automation Entry CountsContactAutomationEntryCountsActiveCampaign.Views.ContactBounceLogs: Contact Bounce LogsContactBounceLogsActiveCampaign.Views.ContactGeoIps: Contact AutomationsContactGeoIpsActiveCampaign.Views.ContactNotes: Contact NotesContactNotesActiveCampaign.Views.ContactTrackingLogs: Contact Tracking LogsContactTrackingLogsActiveCampaign.Views.DealActivitiesNonEmail: Deal Activities Non EmailDealActivitiesNonEmailActiveCampaignAuthentication Authentication can be done using using a token.An API token can be generated from the ActiveCampaignmenu: 'Settings' > 'Developer' > 'Key', as described onhttps://developers.activecampaign.com/reference#authentication.Dictionnaire de donnéesChaque table et chaque colonne de ce Modèle de données sont décrites dans la documentationdisponible sur documentation.invantive.eu, où cette documentation est également accessibledans d'autres langues.NotesLes boîtes sont regroupées par thème et identifiées par une couleur selon leur catégorie. Unerelation est établie dans la rubrique du tableau contenant la clé ; une Box de couleur gris pâle estdéfinie dans une autre rubrique.SujetsV3 · Accounts1V3 · Connections1V3 · CustomFields1Tables sans relations1LégendeTransactionnelSetupTechniqueValeurs codées en durDéfini dans une autre rubriqueClé déclaréeRelation décrite avec des motsCandidat dérivé des noms de colonnesEn gras : une table très appréciée+Bulk, +Read : la Table existe également sous ces variantes: n clés entre les mêmes tablesGénéré à partir des métadonnées d'Invantive UniversalSQL 27.1.3-BETA+6294 le 01-11-2026. Chaque tablerenvoie vers sa page présentant les colonnes, les clés et des exemples de requêtes.documentation.invantive.eu/fr/datamodels/activecampaign
L'affiche sous forme de texte : tableaux par thème et leurs relations

V3 · Accounts

AccountCustomFieldValues, AccountCustomFields, AccountWithCustomFieldValues, Accounts, Associations, Automations, ContactAutomations, ContactWithAccountContacts, ContactWithTags, DealCustomFieldValues, DealCustomFields, DealWithActivities, Deals, PipelineWithStages, Pipelines, SecondaryContacts, Stages, Tags, TaskTypes, Tasks, Users

V3 · Connections

Connections, eComCustomers, eComOrderProducts, eComOrders

V3 · CustomFields

ContactWithCustomFieldValues, CustomFieldOptions, CustomFieldValues, CustomFields

CustomObjects (sans relations)

AccountMyTags, BrowseAbandonments, ContactCars, DealMyTags, Orders, Products, RecurringPayments

Native (sans relations)

NATIVEPLATFORMSCALARREQUESTS

V3 (sans relations)

Addresses, Brandings, Calendars, Campaigns, ContactWithBounceLogs, ContactWithScoreValues, CustomFieldRelations, CustomObjectSchemas, DealRoles, DealWithContacts, DealWithNotes, DealWithTasks, EmailActivities, EventTracking, Events, Forms, GroupLimits, Groups, Lists, Me, Messages, Notes, OutstandingImports, RecentlyCompletedImports, SavedResponses, Scores, Segments, SiteTracking, SiteTrackingWhitelistedDomains, TrackEvents, WebhookEvents, Webhooks

Vues (sans relations)

ContactAut, ContactAutomationEntryCounts, ContactBounceLogs, ContactGeoIps, ContactNotes, ContactTrackingLogs, DealActivitiesNonEmail

Relations

  • AccountCustomFieldValues → AccountCustomFields (candidat): Follows from the name of the column and held in every filled row of the sandbox on 2026-10-31; not stated by ActiveCampaign in the places read.
  • AccountCustomFieldValues → Accounts (candidat): Follows from the name of the column and held in every filled row of the sandbox on 2026-10-31; not stated by ActiveCampaign in the places read.
  • AccountWithCustomFieldValues → AccountCustomFields (candidat): Follows from the name of the column and held in every filled row of the sandbox on 2026-10-31; not stated by ActiveCampaign in the places read.
  • AccountWithCustomFieldValues → Accounts (candidat): Follows from the name of the column and held in every filled row of the sandbox on 2026-10-31; not stated by ActiveCampaign in the places read.
  • Associations → Accounts (candidat): Follows from the name of the column and held in every filled row of the sandbox on 2026-10-31; not stated by ActiveCampaign in the places read.
  • ContactAutomations → Automations (candidat, 2 keys): Follows from the name of the column and held in every filled row of the sandbox on 2026-10-31; not stated by ActiveCampaign in the places read.
  • ContactWithAccountContacts → Accounts (candidat): Follows from the name of the column and held in every filled row of the sandbox on 2026-10-31; not stated by ActiveCampaign in the places read.
  • ContactWithCustomFieldValues → CustomFields (candidat): Follows from the name of the column and held in every filled row of the sandbox on 2026-10-31; not stated by ActiveCampaign in the places read.
  • ContactWithTags → Tags (candidat): Follows from the name of the column and held in every filled row of the sandbox on 2026-10-31; not stated by ActiveCampaign in the places read.
  • CustomFieldOptions → CustomFields (candidat): Follows from the name of the column and held in every filled row of the sandbox on 2026-10-31; not stated by ActiveCampaign in the places read.
  • CustomFieldValues → CustomFields (candidat): Follows from the name of the column and held in every filled row of the sandbox on 2026-10-31; not stated by ActiveCampaign in the places read.
  • DealCustomFieldValues → DealCustomFields (candidat): Follows from the name of the column and held in every filled row of the sandbox on 2026-10-31; not stated by ActiveCampaign in the places read.
  • DealCustomFieldValues → Deals (candidat): Follows from the name of the column and held in every filled row of the sandbox on 2026-10-31; not stated by ActiveCampaign in the places read.
  • DealWithActivities → Deals (candidat): Follows from the name of the column and held in every filled row of the sandbox on 2026-10-31; not stated by ActiveCampaign in the places read.
  • DealWithActivities → Stages (candidat): Follows from the name of the column and held in every filled row of the sandbox on 2026-10-31; not stated by ActiveCampaign in the places read.
  • Deals → Accounts (clé)
  • Deals → Accounts (candidat): Follows from the name of the column and held in every filled row of the sandbox on 2026-10-31; not stated by ActiveCampaign in the places read.
  • Deals → Pipelines (clé)
  • Deals → Stages (clé)
  • Deals → Users (clé)
  • PipelineWithStages → Pipelines (candidat): Follows from the name of the column and held in every filled row of the sandbox on 2026-10-31; not stated by ActiveCampaign in the places read.
  • SecondaryContacts → Deals (candidat): Follows from the name of the column and held in every filled row of the sandbox on 2026-10-31; not stated by ActiveCampaign in the places read.
  • Stages → Pipelines (clé)
  • Tasks → TaskTypes (candidat): Follows from the name of the column and held in every filled row of the sandbox on 2026-10-31; not stated by ActiveCampaign in the places read.
  • eComOrderProducts → Connections (candidat): Follows from the name of the column and held in every filled row of the sandbox on 2026-10-31; not stated by ActiveCampaign in the places read.
  • eComOrderProducts → eComOrders (candidat): Follows from the name of the column and held in every filled row of the sandbox on 2026-10-31; not stated by ActiveCampaign in the places read.
  • eComOrders → Connections (candidat): Follows from the name of the column and held in every filled row of the sandbox on 2026-10-31; not stated by ActiveCampaign in the places read.
  • eComOrders → eComCustomers (candidat): Follows from the name of the column and held in every filled row of the sandbox on 2026-10-31; not stated by ActiveCampaign in the places read.

Tableaux

ActiveCampaign.CustomObjects

ActiveCampaign.Native

ActiveCampaign.V3

ActiveCampaign.Views

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

Attributs

The attributes of this platform are on the page Attributes.

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 :