ODBC Driver for HubSpot

Build 23.0.8839


List of Contact's Identity profiles

Table Specific Information

A list of objects representing the identities of the contact. Each identity represents an identifier for the object, many records will only have a single identity, but merged records may have multiple.


Contact identity profiles can only be filtered by the unique contact id. For example:

SELECT * FROM ContactIdentityProfiles  
SELECT * FROM ContactIdentityProfiles WHERE ContactVID = '123456'


Name Type References Description
ContactVID Long


The unique id for the contact.
Type String The type of the identity, one of EMAIL or LEAD_GUID.
Value String The value of the identity.
Timestamp Datetime Time when the identity was created.
SavedAt Datetime Time when the identity was last updated.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839