CustomFieldValues: ActiveCampaign Custom Field Values
Diese Seite ist in Ihrer Sprache noch nicht verfügbar; es wird die Originalversion angezeigt.
popular insert update delete REST
- Catalog:
ActiveCampaign - Schema:
V3 - Primary Keys:
id - Label: Custom Field Values
Can retrieve data and change data using insert, update and delete.
API Source
- Endpoint:
/fieldValues
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 264 |
| Full scan rows per minute | 13,400 |
The result can be cached on the client.
Table Columns
The columns of the table CustomFieldValues 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 | filters on the platform, writable, computed | ||
contact |
int64 |
Contact | filters on the platform, writable | ||
field |
int64 |
Custom Field | filters on the platform, writable | ||
id |
int64 |
ID | filters on the platform, writable, computed | ||
owner |
int64 |
Owner | filters on the platform, writable | ||
udate |
datetime |
Last Updated | filters on the platform, writable, computed | ||
value |
varchar2 |
Value | filters on the platform, writable |
Keys
| Key | Column | Refers to | Kind | Description |
|---|---|---|---|---|
Custom |
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
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: