ListInterestCategories
A listing of this list's interest categories.
Table Specific Information
SELECT, INSERT, UPDATE, and DELETE are supported for ListInterestCategories.
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.
- ListId supports the '=' operator.
- Type supports the '=' operator.
SELECT * FROM ListInterestCategories WHERE ListId = 'abc' and Type='dropdown'
Insert
The Title, Type, and ListId are required for INSERTs.
INSERT INTO ListInterestCategories (Name, Type, ListID) VALUES ('myNewListInterestCategory', 'myType', 'myListID')
Columns
| Name | Type | ReadOnly | Description |
| ListId [KEY] | String | False |
The ID for the list that this category belongs to. |
| Id [KEY] | String | True | |
| 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 |
Order in which the categories display in the list. Lower numbers display first. |
| Type | String | False |
Determines how this category's interests are displayed on signup forms. |