ContactsInList

Retrieves contacts associated with specific HubSpot lists, with the ability to add or remove list members. Deprecated as of September 30, 2025.

Table Specific Information

Contacts in a given list can be selected, inserted, and removed from that list using this table.

When selecting from ContactsInList, the ListId must be specified in order to retrieve any results. For example:

SELECT * FROM ContactsInList WHERE ListId = '123456789'


Name	Type	ReadOnly	References	Description
VID [KEY]	Long	False		Unique identifier (visitor ID) assigned to the contact in HubSpot.
ListId [KEY]	Long	False		Identifier of the contact list the contact belongs to.
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.