ODBC Driver for HubSpot

Build 25.0.9434

ListMemberships

Represents the relationships between HubSpot lists and CRM objects (contacts, companies, deals, etc.). Each record defines a single object's membership in a specific list, enabling segmentation and targeted marketing activities.

Columns

Name Type ReadOnly References Filterable Description
ObjectId [KEY] Long False

The unique HubSpot Object identifier (recordId).

ListId [KEY] Long False True

Identifier of the HubSpot list (listId) that contains this CRM object. Required for querying specific list memberships.

ObjectTypeId String True

CRM object type identifier for this membership. Common values include '0-1' (contacts), '0-2' (companies), '0-3' (deals), or custom object IDs.

MembershipTimestamp Datetime True

UTC datetime (joinTime) indicating when the CRM object was added to the list. Useful for tracking membership history and recency.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434