ODBC Driver for HubSpot

Build 23.0.8839


Contact lists in HubSpot can be used to group together contacts with similar characteristics.

Table Specific Information

Contact lists represent lists that contacts can be added to in order to more easily sort them. They can be either manual lists or dynamic lists. Contacts will be added to the list automatically when they are added to HubSpot based on some criteria.


Contact lists can be filtered by ListId or by whether or not they are dynamic. For example:

SELECT * FROM ContactLists WHERE ListId = '123456789'
SELECT * FROM ContactLists WHERE IsDynamic = 'false'

Multiple ListIds may be specified together with an IN operator:

SELECT * FROM ContactLists WHERE ListId IN (1, 2, 3)


Name Type ReadOnly References Description
ListId [KEY] Long True

The unique id of the list.

Name String False

The name of the contact list.

CreatedAt Datetime True

When the contact list was created.

UpdatedAt Datetime True

When the contact list was last updated.

IsDynamic Boolean False

A boolean indicating if the contact list is dynamic.

FiltersAggregate String False

An aggregate of filters that a dynamic contact list uses to determine if a newly created contact should be added to the list.

InternalListId Long True

An internal id for the contact list.

LastProcessingStateChangeAt Datetime True

Metadata describing when the last processing state was changed.

ProcessingState String True

Metadata indicating the current stage of processing.

LastSizeChangeAt Datetime True

Metadata describing when the last time the contact list size was changed.

ListSize Long True

Metadata indicating the size of the contact list.

ExtraUrlParameters String True

An input only property for specifying additional parameters when selecting data from HubSpot. Specify the parameters as name=value pairs in a comma separated list. For instance, 'param1=value1,param2=value2,param3=value3'.

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