COMPANIES
- Last Updated: March 4, 2020
- 1 minute read
- DataDirect Connectors
- ODBC
- HubSpot 8.0
- Documentation
Endpoint
https://api.hubapi.com/companies/v2/companies/{CompanyId}
Columns
The COMPANIES table contains the following columns. Columns marked with an asterisk comprise the primary key.
| Column Name | Data Type |
|---|---|
| COMPANYID* | BigInt |
| ALLOWNERIDS | Integer |
| ANALYTICSFIRSTTIMESTAMP | Date |
| ANALYTICSNOOFPAGEVIEWS | Integer |
| ANALYTICSSOURCE | VarChar(64) |
| ANALYTICSSOURCEDATA1 | VarChar(64) |
| ANALYTICSSOURCEDATA2 | VarChar(64) |
| ANNUALREVENUE | BigInt |
| CITY | VarChar(64) |
| CLOSEDATE | Date |
| DATECREATED | Date |
| DAYSTOCLOSE | Integer |
| DESCRIPTION | VarChar(64) |
| DOMAIN | VarChar(64) |
| FILEMANAGERKEY | VarChar(82) |
| FIRSTCONTACTCREATEDATE | Date |
| FIRSTDEALCREATEDDATE | Date |
| HUBSPOTOWNERASSIGNDATE | Date |
| HUBSPOTOWNERID | Integer |
| INDUSTRY | VarChar(64) |
| ISDELETED | Boolean |
| LASTCONTACTED | Date |
| LASTMODIFIEDDATE | Date |
| LASTUPDATED | Date |
| LIFECYCLESTAGE | VarChar(64) |
| LINKEDPAGELINK | VarChar(64) |
| NAME | VarChar(64) |
| NOOFANALYTICSVISITS | Integer |
| NOOFASSOCIATEDCONTACTS | Integer |
| NOOFASSOCIATEDDEALS | Integer |
| NOOFCHILDREN | Integer |
| NOOFCONTACTEDNOTES | Integer |
| NOOFEMPLOYEES | Integer |
| NOOFNOTES | Integer |
| NOTESNEXTACTIVITYDATE | Date |
| OBJECTID | BigInt |
| PARENTCOMPANYID | BigInt |
| PHONENO | VarChar(64) |
| PORTALID | Integer |
| PREDICTIVECONTACTSSCORE | Double |
| RECENTDEALAMOUNT | Integer |
| RECENTDEALCLOSEDATE | Date |
| STATE | VarChar(64) |
| TIMEZONE | VarChar(64) |
| TOTALREVENUE | Integer |
| TYPE | VarChar(64) |
| WEBSITE | VarChar(64) |
| YEARFOUNDED | Integer |
| ZIP | VarChar(64) |