Companies
Manages company records in HubSpot, allowing creation, updating, and deletion of company data similar to contact management.
Table Specific Information
Companies 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 Companies table from your HubSpot Hub.
SELECT
When selecting companies, they can only be filtered by the CompanyId and only one Company at a time. Otherwise they can be selected without a filter, which will cause all companies in your HubSpot account to be listed. For example:
SELECT * FROM Companies WHERE CompanyId = '123456789'
Columns
| Name | Type | ReadOnly | References | Description |
| CompanyId [KEY] | Long | True |
Unique identifier assigned to the company record in HubSpot. | |
| IsDeleted | Boolean | True |
Boolean flag indicating whether the company record has been deleted. | |
| OtherProperties | String | True |
Additional company-specific properties dynamically retrieved at runtime based on the company's custom and standard fields configured in your HubSpot account. |