Endpoint

https://api.hubapi.com/crm/v3/objects/deals

Columns

The DEALS_V3 table contains the following columns. Columns marked with an asterisk comprise the primary key.

Column Name Data Type
ID* Integer
AMOUNTINHOMECURRENCY Double
ARCHIVED Boolean
CREATEDAT Timestamp(9)
DAYSTOCLOSE Integer
HSALLACCESSIBLETEAMI​DS Integer
HSALLOWNERIDS Integer
HSALLTEAMIDS Integer
HSCLOSEDAMOUNT Integer
HSCLOSEDAMOUNTINHOME​CURRENCY Integer
HSCREATEDATE Timestamp(9)
HSDEALSTAGEPROBABILI​TY Integer
HSPROJECTEDAMOUNT Double
HSPROJECTEDAMOUNTINH​OMECURRENCY Double
HUBSPOTOWNERASSIGNED​DATE Timestamp(9)
HUBSPOTOWNERID Integer
HUBSPOTTEAMID Integer
NUMASSOCIATEDCONTACT​S Integer
PROPERTIES​_AMOUNT Double
PROPERTIES​_CLOSEDATE Timestamp(0)
PROPERTIES​_DEALNAME VarChar(64)
UPDATEDAT Timestamp(9)