Create, update and query notebook share invitations from your Evernote account.
Table Specific Information
Select all share invitations for every notebook in your account:
SELECT * FROM NotebookShareInvitations
To create a share invitation about a specific notebook, you will need to specify at least the NotebookGuid, Email and Privilege column.
INSERT INTO NoteBookShareInvitations(NotebookGuid,Privilege,Email,Message) VALUES ('9c3fe790-5958-4bbf-a1de-b1ce3c8d2659','READ_NOTEBOOK_PLUS_ACTIVITY','firstname.lastname@example.org','First notebook share!')
Notebook share invitations may be modified by providing the ID of the notebook share invitation and issuing an UPDATE statement.
Update NoteBookShareInvitations SET Privilege='READ_NOTEBOOK' WHERE Id='50849'
The primary identifier of the share, which is not globally unique.
An immutable, opaque string that acts as a globally unique identifier for this shared notebook record.
The user id of the owner of the notebook.
The GUID of the notebook that has been shared.
A string containing a display name for the recipient of the share. This may be an email address, a phone number, a full name, or some other descriptive string This field is read-only to clients.
The IdentityID of the share recipient. If present, only the user who has claimed that identity may access this share.
The date that the owner first created the share with the specific email address.
The date the shared notebook was last updated on the service.
The privilege level granted to the notebook, activity stream, and invitations.
Indicates that the user wishes to receive daily e-mail notifications for reminders associated with the notebook. This may be true only for business notebooks that belong to the business of which the user is a member.
Indicates that the user wishes to receive notifications for reminders by applications that support providing such notifications. The exact nature of the notification is defined by the individual applications.
The user id of the user who shared a notebook via this shared notebook instance. This may not be the same as userId, since a user with full access to a notebook may have created a new share for that notebook. For Business, this represents the user who shared the business notebook.
The username of the user who can access this share.
The id of the user who can access this share.
The date this SharedNotebook was assigned.
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
The sharer-defined message to put in the email sent out.