Notes: ActiveCampaign Notes
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_ |
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. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver:
Changes of This Table, 26.0 to 27.0
Table ActiveCampaign.V3.Notes is added
The table has 10 columns and can select, insert, update.
- importance 3