Create, update, delete and query notebooks from your Evernote account.
Table Specific Information
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
To create a notebook, you will need to specify at least the Name column.
INSERT INTO NoteBooks(Name,DefaultNotebook) VALUES ('NewNotebook',true)
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'
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'
The unique identifier of this notebook.
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.
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.
If true, this notebook should be used for new notes whenever the user has not (or cannot) specify a desired target notebook.
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.
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.
If this is set to true, then the Notebook will be accessible either to the public, or for business users to their business.
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.
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.
When the notes are publicly displayed, they will be sorted based on the requested criteria.
使用できる値は次のとおりです。CREATED, UPDATED, RELEVANCE, UPDATE_SEQUENCE_NUMBER, TITLE
If this is set to true, then the public notes will be displayed in ascending order (e.g. from oldest to newest).
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.
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.
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
Whether the notebook should be 'recommended' when displayed in the business library user interface.
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.
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.
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.
The client is not able to read notes from the service and the notebook is write-only.
The client may not create new notes in the notebook.
The client may not update notes currently in the notebook.
The client may not expunge notes currently in the notebook.
The client may not share notes in the notebook via the shareNote or createOrUpdateSharedNotes methods.
The client may not e-mail notes via the Evernote service by using the emailNote method.
The client may not send messages to the share recipients of the notebook.
The client may not update the Notebook object itself, for example, via the updateNotebook method.
The client may not expunge the Notebook object itself, for example, via the expungeNotebook method.
The client may not set this notebook to be the default notebook. The caller should leave Notebook.defaultNotebook unset.
If the client is able to update the Notebook, the Notebook.stack value may not be set.
The client may not publish the notebook to the public. For example, business notebooks may not be shared publicly.
The client may not publish the notebook to the business library.
The client may not complete an operation that results in a new tag being created in the owner's account.
The client may not update tags in the owner's account.
The client may not expunge tags in the owner's account.
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.
The client is unable to create shared notebooks for the notebook.
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.
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.
The client may not share notes in the notebook via the shareNoteWithBusiness method.
The client may not rename this notebook
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.
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.
The notebook is on the recipient's notebook list (formerly, we would say that the recipient has 'joined' the notebook).
The stack the recipient has put this notebook into. Every recipient can have their own stack value for the same notebook.
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
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.