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. |