Please enable JavaScript to view this site.

Navigation: Schema: V3 > Tables

Deals

Catalog: ActiveCampaign

Schema: V3

Primary Keys: id

Can retrieve data and change data using insert, update and delete.

Select ActiveCampaign API URL: /deals

Insert ActiveCampaign API URL: /deals

Update ActiveCampaign API URL: /deals

Delete ActiveCampaign API URL: /deals

Field Selection Method: NotRequired

Base Path: deals[*]

Table Columns

The columns of the table Deals 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

account

int64

 

Reference to the account.

activitycount

int64

 

 

cdate

datetime

 

Creation date.

contact

int64

 

ID of the primary contact.

currency

string

 

Currency code for the money value.

customerAccount

int64

 

 

description

string(1000)

 

Description of the deal.

edate

datetime

 

 

group

int64

 

ID of the pipeline.

id

int64

 

 

isDisabled

boolean

 

 

mdate

datetime

 

Last modified date.

nextdate

datetime

 

 

nextdealid

int64

 

 

nexttaskid

int64

 

 

organization

int64

 

Deprecated. Do not use.

owner

int64

 

ID of the user owning the deal.

percent

decimal

 

Percentage of the deal.

stage

int64

 

ID of the stage.

status

int64

 

0 is Open, 1 is Won and 2 is Lost.

title

string

 

Title of the deal.

value

int64

 

Values for the field. For currency fields in cents.

winProbability

int64

 

 

winProbabilityMdate

datetime

 

 

 

29-05-2022 01:06 Version 22.0.196-PROD+3400