Power BI Connector for Evernote

Build 21.0.7867

Notebooks

Create, update, delete and query notebooks from your Evernote account.

Table Specific Information

Select

Select all notebooks in your account:

SELECT * FROM Notebooks

Retrieve a specific notebook:

SELECT * FROM NoteBooks WHERE Guid='a0e8d9ef-1a9d-4be5-8833-ab0cefeeb4bc'

Retrieve the default notebook:

SELECT * FROM NoteBooks WHERE DefaultNotebook=true

Retrieve all accessible business notebooks:

SELECT * FROM NoteBooks WHERE AccessibleBusinessNotebooks=true

Insert

To create a notebook, you will need to specify at least the Name column.

INSERT INTO NoteBooks(Name,DefaultNotebook) VALUES ('NewNotebook',true)

Update

Notebooks may be modified by providing the GUID of the notebook and issuing an UPDATE statement.

UPDATE Notebooks SET Name='UpdatedNotebook', DefaultNotebook=false WHERE Guid='fd78fe7f-3290-4dcd-a1eb-53b3ebc24035'

Delete

Notebooks may be deleted by providing the GUID of the notebook and issuing a DELETE statement.

DELETE FROM Notebooks WHERE Guid='fd78fe7f-3290-4dcd-a1eb-53b3ebc24035'

Columns

Name Type ReadOnly Description
Guid [KEY] String False

The unique identifier of this notebook.

Name String False

A sequence of characters representing the name of the notebook. May be changed by clients, but the account may not contain two notebooks with names that are equal via a case-insensitive comparison. Can't begin or end with a space.

UpdateSequenceNum Int True

A number identifying the last transaction to modify the state of this object. The USN values are sequential within an account, and can be used to compare the order of modifications within the service.

DefaultNotebook Bool False

If true, this notebook should be used for new notes whenever the user has not (or cannot) specify a desired target notebook.

ServiceCreated Datetime True

The time when this notebook was created on the service. This will be set on the service during creation, and the service will provide this value when it returns a Notebook to a client.

ServiceUpdated Datetime True

The time when this notebook was last modified on the service. This will be set on the service during creation, and the service will provide this value when it returns a Notebook to a client.

Published Bool False

If this is set to true, then the Notebook will be accessible either to the public, or for business users to their business.

Stack String False

If this is set, then the notebook is visually contained within a stack of notebooks with this name. All notebooks in the same account with the same 'stack' field are considered to be in the same stack.

Uri String False

If this field is present, then the notebook is published for mass consumption on the Internet under the provided URI, which is relative to a defined base publishing URI defined by the service.

NotesOrder String False

When the notes are publicly displayed, they will be sorted based on the requested criteria.

使用できる値は次のとおりです。CREATED, UPDATED, RELEVANCE, UPDATE_SEQUENCE_NUMBER, TITLE

Ascending Bool False

If this is set to true, then the public notes will be displayed in ascending order (e.g. from oldest to newest).

PublicDescription String False

This field may be used to provide a short description of the notebook, which may be displayed when (e.g.) the notebook is shown in a public view. Can't begin or end with a space.

BusinessNotebookDescription String False

A short description of the notebook's content that will be displayed in the business library user interface. The description may not begin or end with whitespace.

BusinessNotebookPrivilege String False

The privileges that will be granted to users who join the notebook through the business library.

使用できる値は次のとおりです。READ_NOTEBOOK, MODIFY_NOTEBOOK_PLUS_ACTIVITY, READ_NOTEBOOK_PLUS_ACTIVITY, GROUP, FULL_ACCESS, BUSINESS_FULL_ACCESS

BusinessNotebookRecommended Bool False

Whether the notebook should be 'recommended' when displayed in the business library user interface.

ContactId Int True

The Id of the user who has been designated as the 'contact'. For notebooks created in business accounts, the server will automatically set this value to the ID of the user who created the notebook.

ContactName String True

The name of the user who has been designated as the 'contact'. For notebooks created in business accounts, the server will automatically set this value to the name of the user who created the notebook.

ContactEmail String True

The email of the user who has been designated as the 'contact'. For notebooks created in business accounts, the server will automatically set this value to the email of the user who created the notebook.

NoReadNotes Bool False

The client is not able to read notes from the service and the notebook is write-only.

NoCreateNotes Bool False

The client may not create new notes in the notebook.

NoUpdateNotes Bool False

The client may not update notes currently in the notebook.

NoExpungeNotes Bool False

The client may not expunge notes currently in the notebook.

NoShareNotes Bool False

The client may not share notes in the notebook via the shareNote or createOrUpdateSharedNotes methods.

NoEmailNotes Bool False

The client may not e-mail notes via the Evernote service by using the emailNote method.

NoSendMessageToRecipients Bool False

The client may not send messages to the share recipients of the notebook.

NoUpdateNotebook Bool False

The client may not update the Notebook object itself, for example, via the updateNotebook method.

NoExpungeNotebook Bool False

The client may not expunge the Notebook object itself, for example, via the expungeNotebook method.

NoSetDefaultNotebook Bool False

The client may not set this notebook to be the default notebook. The caller should leave Notebook.defaultNotebook unset.

NoSetNotebookStack Bool False

If the client is able to update the Notebook, the Notebook.stack value may not be set.

NoPublishToPublic Bool False

The client may not publish the notebook to the public. For example, business notebooks may not be shared publicly.

NoPublishToBusinessLibrary Bool False

The client may not publish the notebook to the business library.

NoCreateTags Bool False

The client may not complete an operation that results in a new tag being created in the owner's account.

NoUpdateTags Bool False

The client may not update tags in the owner's account.

NoExpungeTags Bool False

The client may not expunge tags in the owner's account.

NoSetParentTag Bool False

If the client is able to create or update tags in the owner's account, then they will not be able to set the parent tag. Leave the value unset.

NoCreateSharedNotebooks Bool False

The client is unable to create shared notebooks for the notebook.

UpdateWhichSharedNotebookRestrictions String False

Restrictions on which shared notebook instances can be updated. If the value is not set or null, then the client can update any of the shared notebooks associated with the notebook on which the NotebookRestrictions are defined.

使用できる値は次のとおりです。ASSIGNED, NO_SHARED_NOTEBOOKS

ExpungeWhichSharedNotebookRestrictions String False

Restrictions on which shared notebook instances can be expunged. If the value is not set or null, then the client can expunge any of the shared notebooks associated with the notebook on which the NotebookRestrictions are defined.

使用できる値は次のとおりです。ASSIGNED, NO_SHARED_NOTEBOOKS

NoShareNotesWithBusiness Bool False

The client may not share notes in the notebook via the shareNoteWithBusiness method.

NoRenameNotebook Bool False

The client may not rename this notebook

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. You may only set this value on a notebook in your business. This value will initially be unset.

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. This value will initially be unset.

InMyList Bool False

The notebook is on the recipient's notebook list (formerly, we would say that the recipient has 'joined' the notebook).

NotebookRecipientStack String False

The stack the recipient has put this notebook into. Every recipient can have their own stack value for the same notebook.

Pseudo-Columns

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

Name Type Description
AccessibleBusinessNotebooks Bool

If it is set to 'true', it retrieves all the notebooks in a business that the user has permission to access, regardless of whether the user has joined them. This includes notebooks that have been shared with the entire business as well as notebooks that have been shared directly with the user.

デフォルト値はfalseです。

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