ListInterests
A list of this category's interests
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 id for the interest category. |
| ListId [KEY] | String | False |
The ID for the list that this interest belongs to. |
| Id [KEY] | String | True |
The ID for the interest. |
| Name | String | False |
The name of the interest. This can be shown publicly on a subscription form. |
| SubscriberCount | String | True |
The number of subscribers associated with this interest. |
| DisplayOrder | Integer | False |
Order in which the interests display. |