ListInterests
Lists individual interests belonging to a specific interest category within a list.
Table Specific Information
Select
The connector will use the Mailchimp API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the connector.
- Id supports the '=' operator.
- CategoryId supports the '=' operator.
- ListId supports the '=' operator.
SELECT * FROM ListInterests WHERE ListId = 'abc' and Id='221' SELECT * FROM ListInterests WHERE ListId = 'abc' and CategoryId='456'
Insert
The Title, CategoryId, and ListId are required for INSERTs.
INSERT INTO ListInterests (Name, CategoryId, ListID) VALUES ('myNewListInterest', 'myCategory', 'myListID')
Columns
| Name | Type | ReadOnly | 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 |
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. |