Endpoint

https://api.hubapi.com/crm/v3/objects/contacts

Columns

The CONTACTS_V3 table contains the following columns. Columns marked with an asterisk comprise the primary key.

Column Name Data Type
ID* Integer
ARCHIVED Boolean
CREATEDAT Timestamp(9)
HSANALYTICSAVERAGEPA​GEVIEWS Integer
HSANALYTICSFIRSTTIME​STAMP Timestamp(9)
HSANALYTICSFIRSTTOUC​HCONVERTINGCAMPAIGN VarChar(64)
HSANALYTICSFIRSTVISI​TTIMESTAMP VarChar(64)
HSANALYTICSLASTTIMES​TAMP VarChar(64)
HSANALYTICSLASTTOUCH​CONVERTINGCAMPAIGN VarChar(64)
HSANALYTICSLASTVISIT​TIMESTAMP VarChar(64)
HSANALYTICSNUMEVENTC​OMPLETIONS Integer
HSANALYTICSNUMPAGEVI​EWS Integer
HSANALYTICSNUMVISITS Integer
HSANALYTICSREVENUE Double
HSANALYTICSSOURCE VarChar(64)
HSANALYTICSSOURCEDAT​A1 VarChar(64)
HSANALYTICSSOURCEDAT​A2 VarChar(64)
HSCALCULATEDPHONENUM​BER VarChar(64)
HSCALCULATEDPHONENUM​BERCOUNTRYCODE VarChar(64)
HSEMAILDOMAIN VarChar(64)
HSEMAILOPTOUT VarChar(64)
HSEMAILOPTOUT6841412 VarChar(64)
HSEMAILOPTOUT6841413 VarChar(64)
HSEMAILOPTOUT6841782 VarChar(64)
HSEMAILOPTOUT6841830 VarChar(64)
HSEMAILQUARANTINED VarChar(64)
HSEMAILRECIPIENTFATI​GUERECOVERYTIME VarChar(64)
HSISCONTACT VarChar(64)
HSLIFECYCLESTAGESUBS​CRIBERDATE Timestamp(9)
HSPREDICTIVECONTACTS​COREV2 Double
HSPREDICTIVESCORINGT​IER VarChar(64)
HSSEARCHABLECALCULAT​EDPHONENUMBER BigInt
HSSOCIALFACEBOOKCLIC​KS Integer
HSSOCIALGOOGLEPLUSCL​ICKS Integer
HSSOCIALLASTENGAGEME​NT VarChar(64)
HSSOCIALLINKEDINCLIC​KS Integer
HSSOCIALNUMBROADCAST​CLICKS Integer
HSSOCIALTWITTERCLICK​S Integer
NUMCONVERSIONEVENTS Integer
NUMUNIQUECONVERSIONE​VENTS Integer
PROPERTIES​_ADDRESS VarChar(64)
PROPERTIES​_ASSOCIATEDCOMPANYID VarChar(64)
PROPERTIES​_CITY VarChar(64)
PROPERTIES​_EMAIL VarChar(64)
PROPERTIES​_FIRSTNAME VarChar(64)
PROPERTIES​_LASTNAME VarChar(64)
PROPERTIES​_LIFECYCLESTAGE VarChar(64)
PROPERTIES​_PHONE VarChar(64)
PROPERTIES​_STATE VarChar(64)
PROPERTIES​_ZIP Integer
UPDATEDAT Timestamp(9)