SQL Server
SQL Server
OneNote - List Notebooks
See more OneNote Examples
Retrieve a list of OneNote notebooks.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'
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', @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",
-- "value": [
-- {
-- "id": "0-3A33FCEB9B74CC15!7338",
-- "self": "https://graph.microsoft.com/v1.0/users/admin@chilkat.io/onenote/notebooks/0-3A33FCEB9B74CC15!7338",
-- "createdDateTime": "2019-04-26T19:05:08.567Z",
-- "displayName": "Matt's Notebook",
-- "lastModifiedDateTime": "2019-04-26T19:05:10.41Z",
-- "isDefault": true,
-- "userRole": "Owner",
-- "isShared": false,
-- "sectionsUrl": "https://graph.microsoft.com/v1.0/users/admin@chilkat.io/onenote/notebooks/0-3A33FCEB9B74CC15!7338/sections",
-- "sectionGroupsUrl": "https://graph.microsoft.com/v1.0/users/admin@chilkat.io/onenote/notebooks/0-3A33FCEB9B74CC15!7338/sectionGroups",
-- "createdBy": {
-- "user": {
-- "id": "3A33FCEB9B74CC15",
-- "displayName": "Matt Smith"
-- }
-- },
-- "lastModifiedBy": {
-- "user": {
-- "id": "3A33FCEB9B74CC15",
-- "displayName": "Matt Smith"
-- }
-- },
-- "links": {
-- "oneNoteClientUrl": {
-- "href": "onenote:https://d.docs.live.net/3a33fceb9b74cc15/Documents/Matt's%20Notebook"
-- },
-- "oneNoteWebUrl": {
-- "href": "https://onedrive.live.com/redir.aspx?cid=3a33fceb9b74cc15&page=edit&resid=3A33FCEB9B74CC15!7338"
-- }
-- }
-- },
-- {
-- "id": "0-3A33FCEB9B74CC15!20344",
-- "self": "https://graph.microsoft.com/v1.0/users/admin@chilkat.io/onenote/notebooks/0-3A33FCEB9B74CC15!20344",
-- "createdDateTime": "2020-10-22T21:59:03.137Z",
-- "displayName": "Testing Notebook",
-- "lastModifiedDateTime": "2020-10-22T21:59:05.24Z",
-- "isDefault": false,
-- "userRole": "Owner",
-- "isShared": false,
-- "sectionsUrl": "https://graph.microsoft.com/v1.0/users/admin@chilkat.io/onenote/notebooks/0-3A33FCEB9B74CC15!20344/sections",
-- "sectionGroupsUrl": "https://graph.microsoft.com/v1.0/users/admin@chilkat.io/onenote/notebooks/0-3A33FCEB9B74CC15!20344/sectionGroups",
-- "createdBy": {
-- "user": {
-- "id": "3A33FCEB9B74CC15",
-- "displayName": "Matt Smith"
-- }
-- },
-- "lastModifiedBy": {
-- "user": {
-- "id": "3A33FCEB9B74CC15",
-- "displayName": "Matt Smith"
-- }
-- },
-- "links": {
-- "oneNoteClientUrl": {
-- "href": "onenote:https://d.docs.live.net/3a33fceb9b74cc15/Documents/Testing%20Notebook"
-- },
-- "oneNoteWebUrl": {
-- "href": "https://onedrive.live.com/redir.aspx?cid=3a33fceb9b74cc15&page=edit&resid=3A33FCEB9B74CC15!20344"
-- }
-- }
-- }
-- ]
-- }
-- 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 @userRole nvarchar(4000)
DECLARE @isShared int
DECLARE @sectionsUrl nvarchar(4000)
DECLARE @sectionGroupsUrl nvarchar(4000)
DECLARE @createdByUserId nvarchar(4000)
DECLARE @createdByUserDisplayName nvarchar(4000)
DECLARE @lastModifiedByUserId nvarchar(4000)
DECLARE @lastModifiedByUserDisplayName nvarchar(4000)
DECLARE @linksOneNoteClientUrlHref nvarchar(4000)
DECLARE @linksOneNoteWebUrlHref 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', @userRole OUT, 'value[i].userRole'
EXEC sp_OAMethod @jResp, 'BoolOf', @isShared OUT, 'value[i].isShared'
EXEC sp_OAMethod @jResp, 'StringOf', @sectionsUrl OUT, 'value[i].sectionsUrl'
EXEC sp_OAMethod @jResp, 'StringOf', @sectionGroupsUrl OUT, 'value[i].sectionGroupsUrl'
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', @linksOneNoteClientUrlHref OUT, 'value[i].links.oneNoteClientUrl.href'
EXEC sp_OAMethod @jResp, 'StringOf', @linksOneNoteWebUrlHref OUT, 'value[i].links.oneNoteWebUrl.href'
SELECT @i = @i + 1
END
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @sbResponseBody
EXEC @hr = sp_OADestroy @jResp
END
GO