Contacts
Your contacts in HubSpot may be used for marketing campaigns and can be retrieved, inserted, updated, and deleted from this table.
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 = 'username@email.com'
SELECT * FROM Contacts WHERE Email IN ('username@email.com', 'user2@email.com')
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] = 'testwork40@example.com;testwork41@example.com', [last name] = 'last name 5' WHERE VID = 123456789
Columns
| Name | Type | ReadOnly | References | Description |
| VID [KEY] | Long | True |
The unique id for the contact. | |
| ListId | Long | True |
The list id the contact is a part of. | |
| SearchTerms | String | True |
An input only field representing potential searchterms you would like to specify when selecting contacts. | |
| CanonicalVid | Long | True |
The cannonical vid associated with the contact. | |
| ProfileToken | String | True |
A token for the profile of the contact. | |
| ProfileUrl | String | True |
A url to the profile of the contact. | |
| IdentityProfilesAggregate | String | True |
An aggregate of identities associated with this contact if any. | |
| FormSubmissionsAggregate | String | True |
An aggregate of forms submitted by this contact if any. | |
| MergeAuditsAggregate | String | True |
An aggregate of merged audits associated with this contact. | |
| MergedVidsAggregate | String | True |
An aggregate of merged vids associated with this contact. | |
| OtherProperties | String | True |
Other properties about the contact will dynamically obtained at runtime and will vary depending on the contact properties specific to your HubSpot HUB. |