Endpoint

https://api.hubapi.com/contacts/v1/contact/vid/{vid}/profile

Columns

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

Column Name Data Type
VID* Integer
ADDRESS VarChar(64)
CALCULATEDPHONENO VarChar(64)
CALCULATEDPHONENOCOU​NTRYCODE VarChar(64)
CITY VarChar(64)
DATECREATED Timestamp(3)
EMAIL VarChar(64)
FIRSTNAME VarChar(64)
HSANALYTICSAVERAGEPA​GEVIEWS Integer
HSANALYTICSFIRSTTIME​STAMP BigInt
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 Integer
HSEMAILDOMAIN VarChar(64)
HSEMAILOPTOUT VarChar(64)
HSEMAILOPTOUT6841412 VarChar(64)
HSEMAILOPTOUT6841413 VarChar(64)
HSEMAILOPTOUT6841782 VarChar(64)
HSEMAILOPTOUT6841830 VarChar(64)
HSEMAILQUARANTINED VarChar(64)
HSISCONTACT VarChar(64)
HSLIFECYCLESTAGESUBS​CRIBERDATE Date
HSOBJECTID Integer
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 VarChar(64)
HSSOCIALTWITTERCLICK​S Integer
ISCONTACT Boolean
LASTMODIFIEDDATE Timestamp(3)
LASTNAME VarChar(64)
LIFECYCLESTAGE VarChar(64)
NUMCONVERSIONEVENTS Integer
NUMUNIQUECONVERSIONE​VENTS Integer
PHONENO VarChar(64)
PORTALID Integer
PROFILEURL VarChar(78)
PROPERTIES​_HS​_SOCIAL​_NUM​_BROADCAST​_CLICKS​_VALUE Integer
STATE VarChar(64)
ZIP Integer