ListInterests
Lists individual interests belonging to a specific interest category within a list.
Table-Specific Information
Select
The provider uses the Mailchimp API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the provider.
| Column | Supported Operators |
| Id | = |
| CategoryId | = |
| ListId | = |
SELECT * FROM ListInterests WHERE ListId = 'abc' AND Id = '221'
SELECT * FROM ListInterests WHERE ListId = 'abc' AND CategoryId = '456'
Insert
The Title, CategoryId, and ListId columns are required for INSERT operations.
INSERT INTO ListInterests (Name, CategoryId, ListId) VALUES ('myNewListInterest', 'myCategory', 'myListId')
Columns
| Name | Type | ReadOnly | References | Description |
| CategoryId [KEY] | String | False |
The unique identifier of the interest category this interest belongs to, linking the interest to a specific group within a list's segmentation structure. | |
| ListId [KEY] | String | False |
Lists.Id |
The unique identifier of the Mailchimp audience (list) that includes this interest, allowing segmentation and targeted campaign delivery. |
| Id [KEY] | String | True |
The unique identifier for the specific interest, used to reference or modify it via the Mailchimp API. | |
| Name | String | False |
The name of the interest, typically shown publicly on signup forms to let subscribers select topics, products, or preferences relevant to them. | |
| SubscriberCount | String | True |
The total number of subscribers currently associated with this interest, helping measure engagement or segment size. | |
| DisplayOrder | Integer | False |
The numeric position that determines how this interest appears on signup forms, with lower numbers appearing earlier in the list. |