Power BI Connector for Evernote

Build 21.0.7867

NotebookShareInvitations

Create, update and query notebook share invitations from your Evernote account.

Table Specific Information

Select

Select all share invitations for every notebook in your account:

SELECT * FROM NotebookShareInvitations

Insert

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','testdrivercdata@gmail.com','First notebook share!')

Update

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'

Columns

Name Type ReadOnly Description
Id [KEY] Long True

The primary identifier of the share, which is not globally unique.

GlobalId String True

An immutable, opaque string that acts as a globally unique identifier for this shared notebook record.

UserId Int True

The user id of the owner of the notebook.

NotebookGuid String False

The GUID of the notebook that has been shared.

Email String False

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.

RecipientIdentityId Long True

The IdentityID of the share recipient. If present, only the user who has claimed that identity may access this share.

ServiceCreated Datetime True

The date that the owner first created the share with the specific email address.

ServiceUpdated Datetime True

The date the shared notebook was last updated on the service.

Privilege String False

The privilege level granted to the notebook, activity stream, and invitations.

ReminderNotifyEmail Bool False

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.

ReminderNotifyInApp Bool False

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.

SharerUserId Int True

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.

RecipientUsername String False

The username of the user who can access this share.

RecipientUserId Int True

The id of the user who can access this share.

ServiceAssigned Datetime True

The date this SharedNotebook was assigned.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
Message String

The sharer-defined message to put in the email sent out.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7867