ListMemberNotes
The last 10 notes for a specific list member, based on date created.
Table Specific Information
SELECT, INSERT, UPDATE, and DELETE are supported for ListMemberNotes.
Select
SELECT * FROM ListMemberNotes
Insert
No fields are are required when INSERTing.
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | Integer | True |
The note's ID. |
| CreatedAt | Datetime | True |
The date the note was created. |
| CreatedBy | String | True |
The author of the note. |
| UpdatedAt | Datetime | True |
The date the note was last updated |
| Note | String | False |
The content of the note. |
| ListId [KEY] | String | False |
The unique id for the list. |
| MemberId [KEY] | String | False |
The MD5 hash of the list member's email address. |
| ContactId | String | True |
As Mailchimp evolves beyond email, you may eventually have contacts without email addresses. While the email_id is the MD5 hash of their email address, this contact_id is agnostic of contact’s inclusion of an email address. |
| EmailId | String | True |
The MD5 hash of the lowercase version of the list member's email address. |