ListMemberNotes
Contains notes created for specific list members, showing the most recent entries by date.
Table-Specific Information
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 |
| Id | = |
| ListId | = |
| MemberId | = |
SELECT * FROM ListMemberNotes WHERE ListId = '121' AND MemberId = '11' AND Id = '456'
Insert
No fields are are required for INSERT operations.
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Integer | True |
The unique identifier of the note, used to reference or manage specific annotations associated with a subscriber. | |
| CreatedAt | Datetime | True |
The date and time when the note was originally created, recorded in ISO 8601 format for accurate tracking. | |
| CreatedBy | String | True |
The name or username of the Mailchimp user who authored the note, indicating who added the information to the subscriber's record. | |
| UpdatedAt | Datetime | True |
The date and time when the note was last edited or modified, helping maintain an audit trail of updates. | |
| Note | String | False |
The full text content of the note, typically used to store additional context, observations, or manual updates about a subscriber. | |
| ListId [KEY] | String | False |
Lists.Id |
The unique identifier of the Mailchimp audience (list) the noted subscriber belongs to. |
| MemberId [KEY] | String | False |
ListMembers.Id |
The MD5 hash of the lowercase version of the subscriber's email address, used to securely identify the list member associated with the note. |
| ContactId | String | True |
A universal identifier for the contact within Mailchimp, independent of whether they have an associated email address, enabling tracking across multiple communication channels. | |
| EmailId | String | True |
The MD5 hash of the lowercase version of the subscriber's email address, used as an alternate secure identifier for email-based contacts. |