Sites
Retrieves all sites for the authenticated user.
Table Specific Information
Select
The connector 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 connector.
- 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. |