SQL Server
SQL Server
OneNote - List Sections
See more OneNote Examples
Retrieve a list of sections from the specified notebook.Chilkat SQL Server Downloads
-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
DECLARE @hr int
-- Important: Do not use nvarchar(max). See the warning about using nvarchar(max).
DECLARE @sTmp0 nvarchar(4000)
DECLARE @success int
SELECT @success = 0
-- This example assumes the Chilkat API to have been previously unlocked.
-- See Global Unlock Sample for sample code.
DECLARE @http int
EXEC @hr = sp_OACreate 'Chilkat.Http', @http OUT
IF @hr <> 0
BEGIN
PRINT 'Failed to create ActiveX component'
RETURN
END
-- Implements the following CURL command:
-- curl -X GET https://graph.microsoft.com/v1.0/me/onenote/notebooks \
-- -H 'authorization: Bearer ACCESS_TOKEN'
-- Use the following online tool to generate HTTP code from a CURL command
-- Convert a cURL Command to HTTP Source Code
-- Adds the "Authorization: Bearer ACCESS_TOKEN" header.
EXEC sp_OASetProperty @http, 'AuthToken', 'ACCESS_TOKEN'
EXEC sp_OAMethod @http, 'SetUrlVar', @success OUT, 'id', '0-3A33FCEB9B74CC15!20344'
DECLARE @sbResponseBody int
EXEC @hr = sp_OACreate 'Chilkat.StringBuilder', @sbResponseBody OUT
EXEC sp_OAMethod @http, 'QuickGetSb', @success OUT, 'https://graph.microsoft.com/v1.0/me/onenote/notebooks/{$id}/sections', @sbResponseBody
IF @success = 0
BEGIN
EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT
PRINT @sTmp0
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @sbResponseBody
RETURN
END
DECLARE @jResp int
EXEC @hr = sp_OACreate 'Chilkat.JsonObject', @jResp OUT
EXEC sp_OAMethod @jResp, 'LoadSb', @success OUT, @sbResponseBody
EXEC sp_OASetProperty @jResp, 'EmitCompact', 0
PRINT 'Response Body:'
EXEC sp_OAMethod @jResp, 'Emit', @sTmp0 OUT
PRINT @sTmp0
DECLARE @respStatusCode int
EXEC sp_OAGetProperty @http, 'LastStatus', @respStatusCode OUT
PRINT 'Response Status Code = ' + @respStatusCode
IF @respStatusCode >= 400
BEGIN
PRINT 'Response Header:'
EXEC sp_OAGetProperty @http, 'LastHeader', @sTmp0 OUT
PRINT @sTmp0
PRINT 'Failed.'
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @sbResponseBody
EXEC @hr = sp_OADestroy @jResp
RETURN
END
-- Sample JSON response:
-- (Sample code for parsing the JSON response is shown below)
-- {
-- "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#users('admin%40chilkat.io')/onenote/notebooks('0-3A33FCEB9B74CC15%2120344')/sections",
-- "value": [
-- {
-- "id": "0-3A33FCEB9B74CC15!20347",
-- "self": "https://graph.microsoft.com/v1.0/users/admin@chilkat.io/onenote/sections/0-3A33FCEB9B74CC15!20347",
-- "createdDateTime": "2020-10-22T22:39:58.247Z",
-- "displayName": "Aaa",
-- "lastModifiedDateTime": "2020-10-22T22:40:00.363Z",
-- "isDefault": false,
-- "pagesUrl": "https://graph.microsoft.com/v1.0/users/admin@chilkat.io/onenote/sections/0-3A33FCEB9B74CC15!20347/pages",
-- "createdBy": {
-- "user": {
-- "id": "3A33FCEB9B74CC15",
-- "displayName": "Matt Smith"
-- }
-- },
-- "lastModifiedBy": {
-- "user": {
-- "id": "3A33FCEB9B74CC15",
-- "displayName": "Matt Smith"
-- }
-- },
-- "parentNotebook@odata.context": "https://graph.microsoft.com/v1.0/$metadata#users('admin%40chilkat.io')/onenote/notebooks('0-3A33FCEB9B74CC15%2120344')/sections('0-3A33FCEB9B74CC15%2120347')/parentNotebook/$entity",
-- "parentNotebook": {
-- "id": "0-3A33FCEB9B74CC15!20344",
-- "displayName": "Testing Notebook",
-- "self": "https://graph.microsoft.com/v1.0/users/admin@chilkat.io/onenote/notebooks/0-3A33FCEB9B74CC15!20344"
-- },
-- "parentSectionGroup@odata.context": "https://graph.microsoft.com/v1.0/$metadata#users('admin%40chilkat.io')/onenote/notebooks('0-3A33FCEB9B74CC15%2120344')/sections('0-3A33FCEB9B74CC15%2120347')/parentSectionGroup/$entity",
-- "parentSectionGroup": null
-- },
-- {
-- "id": "0-3A33FCEB9B74CC15!20348",
-- "self": "https://graph.microsoft.com/v1.0/users/admin@chilkat.io/onenote/sections/0-3A33FCEB9B74CC15!20348",
-- "createdDateTime": "2020-10-22T22:40:09.227Z",
-- "displayName": "Bbb",
-- "lastModifiedDateTime": "2020-10-22T22:40:12.21Z",
-- "isDefault": false,
-- "pagesUrl": "https://graph.microsoft.com/v1.0/users/admin@chilkat.io/onenote/sections/0-3A33FCEB9B74CC15!20348/pages",
-- "createdBy": {
-- "user": {
-- "id": "3A33FCEB9B74CC15",
-- "displayName": "Matt Smith"
-- }
-- },
-- "lastModifiedBy": {
-- "user": {
-- "id": "3A33FCEB9B74CC15",
-- "displayName": "Matt Smith"
-- }
-- },
-- "parentNotebook@odata.context": "https://graph.microsoft.com/v1.0/$metadata#users('admin%40chilkat.io')/onenote/notebooks('0-3A33FCEB9B74CC15%2120344')/sections('0-3A33FCEB9B74CC15%2120348')/parentNotebook/$entity",
-- "parentNotebook": {
-- "id": "0-3A33FCEB9B74CC15!20344",
-- "displayName": "Testing Notebook",
-- "self": "https://graph.microsoft.com/v1.0/users/admin@chilkat.io/onenote/notebooks/0-3A33FCEB9B74CC15!20344"
-- },
-- "parentSectionGroup@odata.context": "https://graph.microsoft.com/v1.0/$metadata#users('admin%40chilkat.io')/onenote/notebooks('0-3A33FCEB9B74CC15%2120344')/sections('0-3A33FCEB9B74CC15%2120348')/parentSectionGroup/$entity",
-- "parentSectionGroup": null
-- },
-- {
-- "id": "0-3A33FCEB9B74CC15!20349",
-- "self": "https://graph.microsoft.com/v1.0/users/admin@chilkat.io/onenote/sections/0-3A33FCEB9B74CC15!20349",
-- "createdDateTime": "2020-10-22T22:40:12.517Z",
-- "displayName": "Ccc",
-- "lastModifiedDateTime": "2020-10-22T22:40:14.367Z",
-- "isDefault": false,
-- "pagesUrl": "https://graph.microsoft.com/v1.0/users/admin@chilkat.io/onenote/sections/0-3A33FCEB9B74CC15!20349/pages",
-- "createdBy": {
-- "user": {
-- "id": "3A33FCEB9B74CC15",
-- "displayName": "Matt Smith"
-- }
-- },
-- "lastModifiedBy": {
-- "user": {
-- "id": "3A33FCEB9B74CC15",
-- "displayName": "Matt Smith"
-- }
-- },
-- "parentNotebook@odata.context": "https://graph.microsoft.com/v1.0/$metadata#users('admin%40chilkat.io')/onenote/notebooks('0-3A33FCEB9B74CC15%2120344')/sections('0-3A33FCEB9B74CC15%2120349')/parentNotebook/$entity",
-- "parentNotebook": {
-- "id": "0-3A33FCEB9B74CC15!20344",
-- "displayName": "Testing Notebook",
-- "self": "https://graph.microsoft.com/v1.0/users/admin@chilkat.io/onenote/notebooks/0-3A33FCEB9B74CC15!20344"
-- },
-- "parentSectionGroup@odata.context": "https://graph.microsoft.com/v1.0/$metadata#users('admin%40chilkat.io')/onenote/notebooks('0-3A33FCEB9B74CC15%2120344')/sections('0-3A33FCEB9B74CC15%2120349')/parentSectionGroup/$entity",
-- "parentSectionGroup": null
-- }
-- ]
-- }
-- Sample code for parsing the JSON response...
-- Use the following online tool to generate parsing code from sample JSON:
-- Generate Parsing Code from JSON
DECLARE @id nvarchar(4000)
DECLARE @self nvarchar(4000)
DECLARE @createdDateTime nvarchar(4000)
DECLARE @displayName nvarchar(4000)
DECLARE @lastModifiedDateTime nvarchar(4000)
DECLARE @isDefault int
DECLARE @pagesUrl nvarchar(4000)
DECLARE @createdByUserId nvarchar(4000)
DECLARE @createdByUserDisplayName nvarchar(4000)
DECLARE @lastModifiedByUserId nvarchar(4000)
DECLARE @lastModifiedByUserDisplayName nvarchar(4000)
DECLARE @parentNotebookodata_context nvarchar(4000)
DECLARE @parentNotebookId nvarchar(4000)
DECLARE @parentNotebookDisplayName nvarchar(4000)
DECLARE @parentNotebookSelf nvarchar(4000)
DECLARE @parentSectionGroupodata_context nvarchar(4000)
DECLARE @parentSectionGroup nvarchar(4000)
DECLARE @odata_context nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @odata_context OUT, '"@odata.context"'
DECLARE @i int
SELECT @i = 0
DECLARE @count_i int
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'value'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
EXEC sp_OAMethod @jResp, 'StringOf', @id OUT, 'value[i].id'
EXEC sp_OAMethod @jResp, 'StringOf', @self OUT, 'value[i].self'
EXEC sp_OAMethod @jResp, 'StringOf', @createdDateTime OUT, 'value[i].createdDateTime'
EXEC sp_OAMethod @jResp, 'StringOf', @displayName OUT, 'value[i].displayName'
EXEC sp_OAMethod @jResp, 'StringOf', @lastModifiedDateTime OUT, 'value[i].lastModifiedDateTime'
EXEC sp_OAMethod @jResp, 'BoolOf', @isDefault OUT, 'value[i].isDefault'
EXEC sp_OAMethod @jResp, 'StringOf', @pagesUrl OUT, 'value[i].pagesUrl'
EXEC sp_OAMethod @jResp, 'StringOf', @createdByUserId OUT, 'value[i].createdBy.user.id'
EXEC sp_OAMethod @jResp, 'StringOf', @createdByUserDisplayName OUT, 'value[i].createdBy.user.displayName'
EXEC sp_OAMethod @jResp, 'StringOf', @lastModifiedByUserId OUT, 'value[i].lastModifiedBy.user.id'
EXEC sp_OAMethod @jResp, 'StringOf', @lastModifiedByUserDisplayName OUT, 'value[i].lastModifiedBy.user.displayName'
EXEC sp_OAMethod @jResp, 'StringOf', @parentNotebookodata_context OUT, 'value[i]."parentNotebook@odata.context"'
EXEC sp_OAMethod @jResp, 'StringOf', @parentNotebookId OUT, 'value[i].parentNotebook.id'
EXEC sp_OAMethod @jResp, 'StringOf', @parentNotebookDisplayName OUT, 'value[i].parentNotebook.displayName'
EXEC sp_OAMethod @jResp, 'StringOf', @parentNotebookSelf OUT, 'value[i].parentNotebook.self'
EXEC sp_OAMethod @jResp, 'StringOf', @parentSectionGroupodata_context OUT, 'value[i]."parentSectionGroup@odata.context"'
EXEC sp_OAMethod @jResp, 'StringOf', @parentSectionGroup OUT, 'value[i].parentSectionGroup'
SELECT @i = @i + 1
END
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @sbResponseBody
EXEC @hr = sp_OADestroy @jResp
END
GO