CData BizTalk Adapter for HubSpot 2019 - Online Help
Questions / Feedback?

Contacts

CData BizTalk Adapter for HubSpot 2019 - Build 19.0.7424

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'

Columns

Name Type ReadOnly References Description
VID [KEY] String True

The unique id for the contact.

ListId Integer True

The list id the contact is a part of.

SearchTerms Integer True

An input only field representing potential searchterms you would like to specify when selecting contacts.

CanonicalVid Integer 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) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7424.0