COMPANIES_V3
- Last Updated: March 4, 2020
- 1 minute read
- DataDirect Connectors
- ODBC
- HubSpot 8.0
- Documentation
Endpoint
https://api.hubapi.com/crm/v3/objects/companies
Columns
The COMPANIES_V3 table contains the following columns. Columns marked with an asterisk comprise the primary key.
| Column Name | Data Type |
|---|---|
| ID* | BigInt |
| ARCHIVED | Boolean |
| ASSOCIATEDCONTACTS | VarChar(64) |
| ASSOCIATEDDEALS | VarChar(64) |
| CONTACTEDNOTES | VarChar(64) |
| CREATEDAT | Timestamp(9) |
| FACEBOOKCOMPANYPAGE | VarChar(82) |
| FIRSTCONTACTCREATEDATE | VarChar(64) |
| FIRSTDEALCREATEDDATE | VarChar(64) |
| HSANALYTICSFIRSTTIMESTAMP | VarChar(64) |
| HSANALYTICSNUMPAGEVIEWS | VarChar(64) |
| HSANALYTICSNUMVISITS | VarChar(64) |
| HSANALYTICSSOURCE | VarChar(64) |
| HSANALYTICSSOURCEDATA1 | VarChar(64) |
| HSANALYTICSSOURCEDATA2 | VarChar(64) |
| HSPREDICTIVECONTACTSCOREV2 | VarChar(64) |
| ISPUBLIC | VarChar(64) |
| LASTCONTACTED | VarChar(64) |
| LINKEDINCOMPANYPAGE | VarChar(123) |
| NOTES | VarChar(64) |
| PROPERTIES_ADDRESS | VarChar(64) |
| PROPERTIES_ANNUALREVENUE | Integer |
| PROPERTIES_CITY | VarChar(64) |
| PROPERTIES_COUNTRY | VarChar(64) |
| PROPERTIES_DESCRIPTION | VarChar(423) |
| PROPERTIES_DOMAIN | VarChar(64) |
| PROPERTIES_INDUSTRY | VarChar(64) |
| PROPERTIES_LIFECYCLESTAGE | VarChar(64) |
| PROPERTIES_LINKEDINBIO | VarChar(423) |
| PROPERTIES_NAME | VarChar(64) |
| PROPERTIES_NOTES_LAST_UPDATED | VarChar(64) |
| PROPERTIES_NOTES_NEXT_ACTIVITY_DATE | VarChar(64) |
| PROPERTIES_NUMBEROFEMPLOYEES | Integer |
| PROPERTIES_PHONE | VarChar(64) |
| PROPERTIES_STATE | VarChar(64) |
| PROPERTIES_TIMEZONE | VarChar(64) |
| PROPERTIES_TWITTERHANDLE | VarChar(64) |
| PROPERTIES_WEB_TECHNOLOGIES | VarChar(417) |
| PROPERTIES_WEBSITE | VarChar(64) |
| PROPERTIES_ZIP | VarChar(64) |
| UPDATEDAT | Timestamp(9) |
| YEARFOUNDED | Integer |