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