Notebooks
Retrieves all Notebooks for the authenticated user.
Table Specific Information
Select
Most filters are handled server side, but the specific fields of Id, UserId, GroupId and SiteId 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'
SELECT * FROM Notebooks WHERE SiteId = 'rssbuscrm.sharepoint.com,9839b8a3-343a-4064-996a-d2a300bc559f,2b6cda85-3573-4578-ae76-dfdde60c771b'
Insert
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')
Columns
| 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. |
| SiteId | String | False |
The Id of the Site. |