ListMemberNotes
The last 10 notes for a specific list member, based on date created.
Table Specific Information
Select
The driver 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 driver.
- 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 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. |