Sites
Retrieves all sites for the authenticated user.
Table Specific Information
Select
The add-in will use the Microsoft OneNote API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the add-in.
- SiteId supports the '='.
- WebId supports the '='.
- SiteName supports the '='.
- Title supports the '='.
- Description supports the '='.
- Author supports the '='.
- FileExtension supports the '='.
- SecondaryFileExtension supports the '='.
- FileType supports the '='.
- DocId supports the '='.
- Importance supports the '='.
- IsContainer supports the '='.
- IsDocument supports the '='.
- Path supports the '='.
- ViewsLifeTime supports the '='.
- ViewsRecent supports the '='.
- WebTemplate supports the '='.
For example:
SELECT * FROM Sites WHERE SiteId = 'b68ddac7-df6d-4649-ad63-d7f22f8535a4' SELECT * FROM Sites WHERE WebId = '577cb6eb-6b89-4638-9bdc-1f92e62af1a5'
Columns
| Name | Type | Description |
| Id [KEY] | String | The full identifier of the site. |
| SiteId | String | The unique identifier of the site collection. |
| WebId | String | The Web Id of the site. |
| SiteName | String | The name of the site. |
| Title | String | The title of the site. |
| SiteDescription | String | The description of the site. |
| Description | String | The description of the item. |
| CreatedDateTime | Datetime | Date and time the site was created. |
| LastModifiedDateTime | Datetime | Date and time the site was last modified. |
| SPWebUrl | String | URL that displays the resource in the browser. |
| Author | String | The author of the site. |
| DocumentSignature | String | The document signature of the site. |
| FileExtension | String | The extension of the site's file. |
| SecondaryFileExtension | String | The secondary extension of the site's file. |
| FileType | String | The file type of the site. |
| DocId | Long | The unique identifier of the site within a geo location. |
| GeoLocationSource | String | The geo location of the site. |
| HitHighlightedSummary | String | The heighted summary of the site. |
| Importance | Long | The importance of the site. |
| IsContainer | Bool | Specifies whether the site is a folder. |
| IsDocument | Bool | Specifies whether the site is a document. |
| OriginalPath | String | The original site path. |
| Path | String | The current site path. |
| Rank | Double | The rank of the site. |
| RenderTemplateId | String | The site's control render template name. |
| SiteLogo | String | The URI of the site's logo. |
| ViewsLifeTime | Long | The total view count since the site was created. |
| ViewsRecent | Long | The total view count of the site in the last 14 days. |
| WebTemplate | String | The web temple from which the site is created. |