Contacts |
Catalog: ActiveCampaign
Schema: V3
Primary Keys: id
Can retrieve data and change data using insert, update and delete.
Select ActiveCampaign API URL: /contacts
Insert ActiveCampaign API URL: /contacts
Update ActiveCampaign API URL: /contacts
Delete ActiveCampaign API URL: /contacts
Field Selection Method: NotRequired
Base Path: contacts[*]
Table Function Columns
The columns of the table function Contacts 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 or update.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
adate |
datetime |
|
☐ |
|
bounced_date |
datetime |
|
☐ |
|
bounced_hard |
int64 |
|
☑ |
|
bounced_soft |
int64 |
|
☑ |
|
cdate |
datetime |
|
☐ |
|
deleted |
int64 |
|
☑ |
|
edate |
datetime |
|
☐ |
|
email_domain |
string |
|
☐ |
|
email_local |
string |
|
☐ |
|
string |
|
☐ |
|
|
firstName |
string |
|
☐ |
|
gravatar |
int64 |
|
☑ |
|
hash |
string |
|
☐ |
|
id |
int64 |
|
☑ |
|
ip |
int64 |
|
☑ |
|
lastName |
string |
|
☐ |
|
organization |
int64 |
|
☐ |
Deprecated. Do not use. |
orgid |
int64 |
|
☑ |
|
phone |
string |
|
☐ |
|
rating_tstamp |
datetime |
|
☐ |
|
segmentio_id |
int64 |
|
☐ |
|
sentcnt |
int64 |
|
☑ |
|
socialdata_lastcheck |
datetime |
|
☐ |
|
ua |
string |
|
☐ |
|
udate |
datetime |
|
☑ |
|
29-05-2022 01:06 Version 22.0.196-PROD+3400