ContactNotes: ActiveCampaign Contact Notes |
Catalog: ActiveCampaign
Schema: Views
Label: Contact Notes
This is a read-only view. The ActiveCampaign API may not support changing the data or the Invantive UniversalSQL driver for ActiveCampaign does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the ActiveCampaign API.
View Columns
The columns of the view ContactNotes are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
|---|---|---|---|---|
cdate |
datetime |
Created |
☑ |
|
contact_adate |
datetime |
|
☐ |
|
contact_bounced_date |
datetime |
Bounced Date |
☐ |
|
contact_bounced_hard |
int64 |
Bounced Hard |
☑ |
|
contact_bounced_soft |
int64 |
Bounced Soft |
☑ |
|
contact_cdate |
datetime |
Created |
☐ |
|
contact_deleted |
int64 |
Deleted |
☑ |
|
contact_edate |
datetime |
|
☐ |
|
contact_email_domain |
varchar2 |
|
☐ |
|
contact_email_local |
varchar2 |
|
☐ |
|
contact_email |
varchar2 |
Email Address |
☐ |
|
contact_firstName |
varchar2 |
First Name |
☐ |
|
contact_gravatar |
int64 |
Gravatar |
☑ |
|
contact_hash |
varchar2 |
Hash |
☐ |
|
contact_id |
int64 |
ID |
☑ |
|
contact_ip |
int64 |
IP Address |
☑ |
|
contact_lastName |
varchar2 |
Last Name |
☐ |
|
contact_organization |
int64 |
Account |
☐ |
Deprecated. Do not use. |
contact_orgid |
int64 |
Organisation ID |
☑ |
|
contact_phone |
varchar2 |
Phone |
☐ |
|
contact_rating_tstamp |
datetime |
Rating Date |
☐ |
|
contact_segmentio_id |
int64 |
|
☐ |
|
contact_sentcnt |
int64 |
|
☑ |
|
contact_socialdata_lastcheck |
datetime |
Social Data Last Check |
☐ |
|
contact_ua |
varchar2 |
|
☐ |
|
contact_udate |
datetime |
Last Updated |
☐ |
|
id |
int64 |
ID |
☑ |
|
is_draft |
int64 |
|
☑ |
|
mdate |
datetime |
Last Modified |
☑ |
|
note |
varchar2 |
Note |
☑ |
|
owner_id |
int64 |
Owner ID |
☑ |
|
owner_type |
varchar2 |
Owner Type |
☑ |
|
relid |
int64 |
Relationship ID |
☑ |
|
reltype |
varchar2 |
Relationship Type |
☑ |
|
user |
int64 |
User |
☑ |
|
userid |
int64 |
User ID |
☑ |
|