DEALS
- Last Updated: May 13, 2025
- 1 minute read
- DataDirect Connectors
- JDBC
- HubSpot 6.0
- Documentation
Endpoint
https://api.hubapi.com/deals/v1/deal/{DealId}
Columns
The DEALS table contains the following columns. Columns marked with an asterisk comprise the primary key.
| Column Name | Data Type |
|---|---|
| DEALID* | Integer |
| ALLACCESSIBLETEAMIDS | Integer |
| ALLOWNERIDS | Integer |
| ALLTEAMIDS | Integer |
| AMOUNT | Double |
| AMOUNTINHOMECURRENCY | Double |
| CLOSEDATE | Date |
| CLOSEDDEALAMOUNT | Integer |
| CLOSEDDEALAMOUNTINHOMECURRENCY | Integer |
| CREATEDATE | Date |
| DAYSTOCLOSE | Integer |
| DEALNAME | VarChar(64) |
| DEALSTAGEPROBABILITY | Integer |
| HUBSPOTCREATEDATE | Date |
| HUBSPOTOBJECTID | Integer |
| HUBSPOTOWNERID | Integer |
| HUBSPOTTEAMID | Integer |
| ISDELETED | Boolean |
| LASTMODIFIEDDATE | Date |
| NUMBEROFCONTACTS | Integer |
| OWNERASSIGNEDDATE | Date |
| PORTALID | Integer |
| PROJECTEDDEALAMOUNT | Double |
| PROJECTEDDEALAMOUNTINHOMECURRENCY | Double |