Deals
Manages HubSpot deals used for recording sales opportunities, with capabilities for retrieval and modification.
Table Specific Information
Deals in HubSpot represent different organizations you are interested in keeping track of for potential marketing opportunities. They are treated similarly like contacts and have a number of custom properties that will be dynamically determined and added to the Deals table from your HubSpot Hub.
SELECT
When selecting deals, they can only be filtered by the DealId and only one Deal at a time. Otherwise they can be selected without a filter, which will cause all deals in your HubSpot account to be listed. For example:
SELECT * FROM Deals WHERE DealId = '123456789'
Columns
| Name | Type | ReadOnly | References | Description |
| DealId [KEY] | Long | True |
Unique identifier assigned to the deal in HubSpot. | |
| DealName | String | True |
The name assigned to the deal. | |
| IsDeleted | Boolean | True |
Boolean flag indicating whether the deal has been deleted. | |
| AssociatedCompanyIds | String | True |
Comma-separated list of company IDs associated with the deal. | |
| AssociatedDealIds | String | True |
Comma-separated list of other deal IDs linked to this deal. | |
| AssociatedVids | String | True |
Comma-separated list of contact IDs (VIDs) associated with this deal. |