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
A ListId and EmailId are required to retrieve data from this table. If none are specified in the WHERE clause, the first ones available for your account will be used.
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 | True |
The unique id for the list. |
| MemberId [KEY] | String | True |
The MD5 hash of the list member's email address. |