Excel Add-In for OneNote

Build 21.0.7930


Retrieves all Notebooks for the authenticated user.

Table Specific Information


Most filters are handled server side, but the specific fields of Id, UserId, and GroupId will change the endpoint we use to retrieve the data. They must be specified with an '=' or IN condition. For example:

SELECT * FROM Notebooks WHERE Id = '1-56e2fc02-f3dd-4f82-82fb-519bc4807935'
SELECT * FROM Notebooks WHERE Id IN ('1-56e2fc02-f3dd-4f82-82fb-519bc4807935', '1-56e2fc02-f3dd-4f82-fvgf-dfsdf4807935')
SELECT * FROM Notebooks WHERE UserId = '9525a3f1-aa40-4f17-a97b-68606d118adf'
SELECT * FROM Notebooks WHERE GroupId = '044d385d-6ca8-4d81-800d-223124b651db'


The column required to perform an Insert operation on Notebooks table is DisplayName. If the INSERT operation is done on behalf of a group or user then UserId or GroupId should also be specified. The following examples illustrate an Insert operation on Notebooks:

INSERT INTO Notebooks (DisplayName) VALUES ('Getting started')
INSERT INTO Notebooks (DisplayName, UserId) VALUES ('Getting started','9525a3f1-aa40-4f17-a97b-68606d118adf')
INSERT INTO Notebooks (DisplayName, GroupId) VALUES ('Getting started','044d385d-6ca8-4d81-800d-223124b651db')


Name Type ReadOnly Description
id [KEY] String True

The id of the notebook.

self String False

The self of the notebook.

createdDateTime Datetime False

The created DateTime of the notebook.

createdBy_application_displayName String False

The createdBy_application_displayName of the notebook.

createdBy_application_id String False

The createdBy_application_id of the notebook.

displayName String False

The display name of the notebook.

lastModifiedBy_application_displayName String False

The lastModifiedBy_application_displayName of the notebook.

lastModifiedBy_application_id String False

The lastModifiedBy_application_id of the notebook.

lastModifiedDateTime Datetime False

The lastModified DateTime of the notebook.

isDefault Bool False

Indicator if notebook is default.

isShared Bool False

Indicator if notebook is shared.

links_oneNoteClientUrl_href String False

The links_oneNoteClientUrl_href of the notebook.

sectionGroupsUrl String False

The sectionGroups Url of the notebook.

sectionsUrl String False

The sectionsUrl of the notebook.

userRole String False

The userRole of the notebook.

createdBy_user_displayName String False

The createdBy user displayName of the notebook

createdBy_user_id String False

The createdBy user id of the notebook

UserId String False

The userId that the authenticated user is impersonating.

GroupId String False

The groupId that the authenticated user is impersonating.

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