invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

ContactWithCustomFieldValues: ActiveCampaign Contact Custom Fields

Esta página aún no está disponible en tu idioma; se muestra la versión original.

read only REST

  • Catalog: ActiveCampaign
  • Schema: V3
  • Primary Keys: id
  • Label: Contact Custom Fields

Can only retrieve data.

API Source

  • Endpoint: /contacts?include=fieldValues

Performance Characteristics

Characteristic Value
Average access latency (ms) 471
Full scan rows per minute 89,800

The result can be cached on the client.

Table Columns

The columns of the table ContactWithCustomFieldValues are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
cdate datetime Created writable, computed
contact int64 Contact writable Contact ID.
created_by varchar2 Created by writable, computed
field int64 Custom Field filters on the platform, writable
id int64 ID writable, computed Unique ID.
udate datetime Last Updated writable, computed
updated_by varchar2 Updated by writable, computed
value varchar2 Value filters on the platform, writable For datetime custom fields, the value is returned in UTC timezone with format YYYY-MM-DD HH24:MI:SS.

Keys

Key Column Refers to Kind Description
ContactWithCustomFieldValues_field_cnd field CustomFields.id Candidate 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.

Sample 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

Notas de la Versión

Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: