ADO.NET Provider for HubSpot

Build 24.0.9062

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 = '[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

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.

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