ContactAut |
Catalog: ActiveCampaign
Schema: Views
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 ContactAut are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
|---|---|---|---|---|
adddate |
datetime |
|
☑ |
|
automation |
int64 |
Automation |
☑ |
|
batchid |
varchar2 |
Batch ID |
☐ |
|
completed |
int64 |
Completed |
☑ |
|
completedElements |
int64 |
|
☑ |
|
completeValue |
int64 |
|
☑ |
|
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 |
☐ |
|
contact |
int64 |
Contact |
☑ |
|
id |
int64 |
ID |
☑ |
|
lastblock |
int64 |
Last Block |
☑ |
|
lastdate |
datetime |
Last Date |
☑ |
|
lastlogid |
int64 |
Last Log ID |
☑ |
|
remdate |
datetime |
|
☐ |
|
seriesid |
int64 |
Series ID |
☑ |
|
startid |
int64 |
Start ID |
☑ |
|
status |
int64 |
Status |
☑ |
|
timespan |
int64 |
Timespan |
☐ |
|
totalElements |
int64 |
Total Elements |
☑ |
|