Power BI Connector for Microsoft OneNote

Build 23.0.8839

SectionGroups

Retrieves all SectionGroups 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 and ParentNotebookId will change the endpoint we use to retrieve the data. They must be specified with an '=' or IN condition. For example:

SELECT * FROM SectionGroups WHERE Id = '1-56e2fc02-f3dd-4f82-82fb-519bc4807935'
SELECT * FROM SectionGroups WHERE ParentNotebookId = '1-2342423-1234-3424-82fb-519bc4807935'
SELECT * FROM SectionGroups WHERE Id IN ('1-56e2fc02-f3dd-4f82-82fb-519bc4807935', '1-sdcgw3324-f3dd-5678-derf-519bc4807935')
SELECT * FROM SectionGroups WHERE ParentNotebookId IN ('1-56e2fc02-f3dd-4f82-82fb-519bc4807935', '1-sdcgw3324-f3dd-5678-derf-519bc4807935')
SELECT * FROM SectionGroups WHERE UserId = '9525a3f1-aa40-4f17-a97b-68606d118adf'
SELECT * FROM SectionGroups WHERE GroupId = '044d385d-6ca8-4d81-800d-223124b651db'
SELECT * FROM SectionGroups 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 SectionGroups 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 SectionGroups:

INSERT INTO SectionGroups (DisplayName, ParentNotebookId) VALUES ('Getting started', '1-5c57790b-73c3-4996-940e-07c3f2157571')
INSERT INTO SectionGroups (DisplayName, ParentNotebookId, UserId) VALUES ('Getting started', '1-5c57790b-73c3-4996-940e-07c3f2157571', '9525a3f1-aa40-4f17-a97b-68606d118adf')
INSERT INTO SectionGroups (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 group.

self String False

The self of the section group.

createdDateTime Datetime False

The createdDateTime of the section group.

createdBy_application_displayName String False

The createdBy_application_displayName of the section group.

createdBy_application_id String False

The createdBy_application_id of the section group.

displayName String False

The displayName of the section group.

lastModifiedBy_application_displayName String False

The lastModifiedBy_application_displayName of the section group.

lastModifiedBy_application_id String False

The lastModifiedBy_application_id of the section group.

lastModifiedDateTime Datetime False

The lastModifiedDateTime of the section group.

sectionGroupsUrl String False

The sectionGroupsUrl of the section group.

sectionsUrl String False

The sectionsUrl of the section group.

ParentNotebookId String False

The ParentNotebookId of the section group.

ParentSectionGroupId String False

The ParentSectionGroupId of the section group.

createdBy_user_displayName String False

The createdBy_user_displayName of the section group.

createdBy_user_id String False

The createdBy_user_id of the section group.

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839