ListMemberNotes
Contains notes created for specific list members, showing the most recent entries by date.
Table Specific Information
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.
- 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. |