ListInterests
Lists individual interests belonging to a specific interest category within a list.
Table Specific Information
Select
The add-in 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 add-in.
- 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. |