ContactLists
Manages contact lists used to group and target contacts based on shared attributes or behavior.
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.
SELECT
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)
Columns
| Name | Type | ReadOnly | References | Description |
| ListId [KEY] | Long | True |
Unique identifier assigned to the contact list. | |
| Name | String | False |
Name of the contact list as displayed in HubSpot. | |
| CreatedAt | Datetime | True |
Timestamp indicating when the contact list was created. | |
| UpdatedAt | Datetime | True |
Timestamp indicating when the contact list was last updated. | |
| IsDynamic | Boolean | False |
Boolean flag indicating whether the contact list is static or dynamic (auto-updating based on criteria). | |
| FiltersAggregate | String | False |
Aggregate string of filters used by a dynamic contact list to determine contact inclusion. | |
| InternalListId | Long | True |
Internal system identifier for the contact list, used for backend processing. | |
| LastProcessingStateChangeAt | Datetime | True |
Timestamp indicating when the list's processing state was last updated. | |
| ProcessingState | String | True |
Current processing state of the contact list, such as processing, up-to-date, or error. | |
| LastSizeChangeAt | Datetime | True |
Timestamp indicating when the size of the contact list was last updated. | |
| ListSize | Long | True |
Current size of the contact list, representing the total number of contacts. | |
| ExtraUrlParameters | String | True |
Optional input-only property to specify additional query parameters when retrieving contact list data. Format: 'param1=value1, param2=value2, param3=value3'. |