Please enable JavaScript to view this site.

Navigation: Schema: V3 > Tables

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

 

 

email

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