ListMemberNotes
Contains notes created for specific list members, showing the most recent entries by date.
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.
- ListId supports the '=' operator.
- MemberId supports the '=' operator.
SELECT * FROM ListMemberNotes WHERE ListId = '121' and MemberId = '11' and Id='456'
Insert
No fields are are required when INSERTing.
Columns
| Name | Type | ReadOnly | 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 |
The unique identifier of the Mailchimp audience (list) the noted subscriber belongs to. |
| MemberId [KEY] | String | False |
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. |