invantive documentation
Invantive SupportforenAnmelden / Eintragen

Notes: ActiveCampaign Notes

Diese Seite ist in Ihrer Sprache noch nicht verfügbar; es wird die Originalversion angezeigt.

insert update REST

  • Catalog: ActiveCampaign
  • Schema: V3
  • Primary Keys: id
  • Label: Notes

Can retrieve data and change data using insert and update.

API Source

  • Endpoint: /notes

Performance Characteristics

Characteristic Value
Average access latency (ms) 264
Full scan rows per minute 6,510

The result can be cached on the client.

Table Columns

The columns of the table Notes 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 Moment of creation.
id int64 ID filters on the platform, writable, computed Unique ID.
is_draft int64 Is Draft filters on the platform, writable, computed Whether the note has not been finished yet.
listId int64 List ID filters on the platform, writable List the note is limited to. Can be given when a note on a contact is recorded and is never answered back, so it is always empty when read.
mdate datetime Last Modified filters on the platform, writable, computed Moment of last change.
note varchar2 Note filters on the platform, writable Text of the note.
relid int64 Relationship ID filters on the platform, writable ID of the record the note belongs to.
reltype varchar2 Relationship Type filters on the platform, writable Kind of record the note belongs to, such as Subscriber for a contact, Deal, CustomerAccount or Activity.
user int64 User filters on the platform, writable, computed ID of the user that wrote the note.
userid int64 User ID filters on the platform, writable, computed ID of the user that wrote the note.

Anmerkungen zu dieser Version

Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert:

Änderungen an dieser Tabelle, 26.0 bis 27.0

Die Tabelle ActiveCampaign.V3.Notes wurde hinzugefügt

Die Tabelle verfügt über 10 Spalten und unterstützt die Befehle „select“, „insert“ und „update“.

  • Bedeutung 3

Alle Treiberwechsel, 26.0 bis 27.0