ContactLists
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.
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 |
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'. |