Pages
Retrieves all Pages accross notebooks for the authenticated user.
Table Specific Information
Select
Most filters are handled server side, but the specific fields of Id, ParentSectionId, UserId or GroupId will change the endpoint we use to retrieve the data. They must be specified with an '=' or IN condition.
For example:
SELECT * FROM Pages WHERE Id = '1-e8992fa8e5254df387d062d04e75a6e7!6-e8341f6e-75b1-4811-8bb4-d2069c7f7a2d'
SELECT * FROM Pages WHERE Id IN ('1193-dsdda-9392-4706514c636b', '1193-dsdda-9392-sdfasdw33324')
SELECT * FROM Pages WHERE ParentSectionId = '1-e8341f6e-75b1-4811-8bb4-d2069c7f7a2d'
SELECT * FROM Pages WHERE ParentSectionId = '1-e8341f6e-75b1-4811-8bb4-d2069c7f7a2d' AND UserId = '92dfdfc6-f1d4-4965-9f71-30e4da4fa7fe'
SELECT * FROM Pages WHERE ParentSectionId = '1-e8341f6e-75b1-4811-8bb4-d2069c7f7a2d' AND GroupId = '1772bb5a-f8e9-405d-a90b-eac11b0b9b9a'
SELECT * FROM Pages WHERE GroupId = 'acabe397-8370-4c31-aeb7-2d7ae6b8cda1'
SELECT * FROM Pages WHERE UserId = '92dfdfc6-f1d4-4965-9f71-30e4da4fa7fe'
Columns
| Name | Type | Description |
| id [KEY] | String | The id of the page. |
| self | String | The self of the page. |
| createdDateTime | Datetime | The createdDateTime of the page. |
| contentUrl | String | The contentUrl of the page. |
| createdByAppId | String | The createdByAppId of the page. |
| lastModifiedDateTime | Datetime | The lastModifiedDateTime of the page. |
| level | Int | The level of the page. |
| links_oneNoteClientUrl_href | String | The links_oneNoteClientUrl_href of the page |
| order | Int | The order of the page. |
| title | String | The title of the page. |
| userTags | String | The userTags of the page. |
| ParentSectionId | String | The ParentSectionId of the page. |
| UserId | String | The userId that the authenticated user is impersonating. |
| GroupId | String | The groupId that the authenticated user is impersonating. |