ListInterestCategories
Returns the interest categories for a Mailchimp audience list.
Table-Specific Information
SELECT, INSERT, UPDATE, and DELETE are supported for ListInterestCategories.
Select
The add-in 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 add-in.
| Column | Supported Operators |
| ListId | = |
| Type | = |
SELECT * FROM ListInterestCategories WHERE ListId = 'abc' AND Type = 'dropdown'
Insert
The Title, Type, and ListId columns are required for INSERT operations.
INSERT INTO ListInterestCategories (Name, Type, ListId) VALUES ('myNewListInterestCategory', 'myType', 'myListId')
Columns
| Name | Type | ReadOnly | References | Description |
| ListId [KEY] | String | False |
Lists.Id |
The Id of the list that this category belongs to. |
| Id [KEY] | String | True |
The unique identifier for the interest category. | |
| Title | String | False |
The text description of this category. This field is displayed on signup forms and is often phrased as a question. | |
| DisplayOrder | Integer | False |
The order in which the categories display in the list. Lower numbers display first. | |
| Type | String | False |
The display format for this category's interests on signup forms. The allowed values are checkboxes, dropdown, radio, hidden. |