JDBC Driver for HubSpot

Build 22.0.8462

ContactIdentityProfiles

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.

Select

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

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

Columns

Name Type References Description
ContactVID Long

Contacts.VID

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) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462