Sections
Retrieves all Sections accross notebooks for the authenticated user.
Table Specific Information
Select
Most filters are handled server side, but the specific fields of Id, UserId, GroupId, SiteId, 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'
SELECT * FROM Sections WHERE SiteId = 'cdata0.sharepoint.com,0a40f113-9f39-459d-a22a-9cc88b46f031,dd4add46-e9ed-4ed8-b479-d55d0721bc7f'
Insert
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')
Columns
| 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. |
| SiteId | String | False |
The Id of the Sharepoint Site. |