Contacts
Handles HubSpot contact records, enabling full create, read, update, delete (CRUD) operations on contact data.
Table Specific Information
Contacts in HubSpot represent different contacts you are interested in keeping track of for potential marketing opportunities. Contacts are similar to companies: They both have a number of custom properties that will be dynamically determined and added to the table from your HubSpot Hub.
SELECT
When selecting contacts, they can only be filtered by the VID, Email, UserToken, ListId, or AssociatedCompanyId. However, most of these filters cannot be used at the same time. The accepted filters are illustrated below:
SELECT * FROM Contacts WHERE VID = 123456789 SELECT * FROM Contacts WHERE VID IN (123, 456) SELECT * FROM Contacts WHERE VID > 123456789 SELECT * FROM Contacts WHERE Email = '[email protected]' SELECT * FROM Contacts WHERE Email IN ('[email protected]', '[email protected]') SELECT * FROM Contacts WHERE UserToken = 'ABC123456' SELECT * FROM Contacts WHERE SearchTerms = 'Contact Name' SELECT * FROM Contacts WHERE ListId = '123456789' SELECT * FROM Contacts WHERE AssociatedCompanyId = '123456789'
UPDATE
You can update contacts, for example, Additional email addresses:
UPDATE [Contacts] SET [Additional email addresses] = '[email protected];[email protected]', [last name] = 'last name 5' WHERE VID = 123456789
Columns
| Name | Type | ReadOnly | References | Description |
| VID [KEY] | Long | True |
Unique identifier (VID) assigned to the contact in HubSpot. | |
| ListId | Long | True |
Identifier of the contact list the contact belongs to. | |
| SearchTerms | String | True |
Input-only field to specify search terms when querying contact records. | |
| CanonicalVid | Long | True |
Canonical VID representing the primary identifier for merged or deduplicated contacts. | |
| ProfileToken | String | True |
Token associated with the contact's profile, used for secure profile access. | |
| ProfileUrl | String | True |
URL directing to the contact's profile page in HubSpot. | |
| IdentityProfilesAggregate | String | True |
Aggregate string representing all identities linked to the contact, such as email addresses or social profiles. | |
| FormSubmissionsAggregate | String | True |
Aggregate string listing all forms submitted by the contact, if applicable. | |
| MergeAuditsAggregate | String | True |
Aggregate of records detailing audits related to merged contact records. | |
| MergedVidsAggregate | String | True |
Aggregate list of VIDs merged into the current contact record. | |
| OtherProperties | String | True |
Additional dynamic properties about the contact retrieved at runtime, based on the HubSpot account's configuration. |