ListInterestCategories
Returns the interest categories for a Mailchimp audience list.
Table-Specific Information
SELECT, INSERT, UPDATE, and DELETE are supported for ListInterestCategories.
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 |
| 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. |