Excel Add-In for OneNote

Build 21.0.8011


Retrieves all Sections accross notebooks for the authenticated user.

Table Specific Information


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

SELECT * FROM Sections WHERE Id = '1-56e2fc02-f3dd-4f82-82fb-519bc4807935'
SELECT * FROM Sections WHERE ParentNotebookId = '1-56e2fc02-f3dd-4f82-82fb-519bc4807935'
SELECT * FROM Sections WHERE ParentSectionGroupId = '1-56e2fc02-f3dd-4f82-82fb-519bc4807935'
SELECT * FROM Sections WHERE Id IN ('1-56e2fc02-f3dd-4f82-82fb-519bc4807935','1-23423-f3dd-rtsd-gfds-4353423fsdf')
SELECT * FROM Sections WHERE ParentNotebookId IN ('1-56e2fc02-f3dd-4f82-82fb-519bc4807935','1-23423-f3dd-rtsd-gfds-4353423fsdf')
SELECT * FROM Sections WHERE ParentSectionGroupId IN ('1-56e2fc02-f3dd-4f82-82fb-519bc4807935','1-23423-f3dd-rtsd-gfds-4353423fsdf')
SELECT * FROM Sections WHERE UserId = '9525a3f1-aa40-4f17-a97b-68606d118adf'
SELECT * FROM Sections WHERE GroupId = '044d385d-6ca8-4d81-800d-223124b651db'


The columns required to perform an Insert operation on Sections table is DisplayName and ParentNotebookId. 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 Sections:

INSERT INTO Sections (DisplayName, ParentNotebookId) VALUES ('Getting started','1-5c57790b-73c3-4996-940e-07c3f2157571')
INSERT INTO Sections (DisplayName, ParentNotebookId, UserId) VALUES ('Getting started','1-5c57790b-73c3-4996-940e-07c3f2157571', '9525a3f1-aa40-4f17-a97b-68606d118adf')
INSERT INTO Sections (DisplayName, ParentNotebookId, GroupId) VALUES ('Getting started','1-5c57790b-73c3-4996-940e-07c3f2157571', '044d385d-6ca8-4d81-800d-223124b651db')


Name Type ReadOnly Description
id [KEY] String True

The id of the section.

self String False

The self of the section.

createdDateTime Datetime False

The createdDateTime of the section.

createdBy_application_displayName String False

The createdBy_application_displayName of the section.

createdBy_application_id String False

The createdBy_application_id of the section.

displayName String False

The displayName of the section.

lastModifiedBy_application_displayName String False

The lastModifiedBy_application_displayName of the section.

lastModifiedBy_application_id String False

The lastModifiedBy_application_id of the section.

lastModifiedDateTime Datetime False

The lastModifiedDateTime of the section.

isDefault Bool False

The isDefault of the section.

links_oneNoteClientUrl_href String False

The links_oneNoteClientUrl_href of the section.

pagesUrl String False

The pagesUrl of the section.

ParentNotebookId String False

The ParentNotebookId of the section.

ParentSectionGroupId String False

The ParentSectionGroupId of the section.

createdBy_user_displayName String False

The createdBy_user_displayName of the section.

createdBy_user_id String False

The createdBy_user_id of the section.

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.8011