ListInterestCategories
A listing of this list's interest categories.
Table Specific Information
SELECT, INSERT, UPDATE, and DELETE are supported for ListInterestCategories.
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.
- 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. |