SQL Server
SQL Server
OneNote - List Pages
See more OneNote Examples
Retrieve a list of OneNote page objects.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/pages \
-- -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/pages', @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/pages",
-- "value": [
-- {
-- "id": "0-dbd4707e211744b29e3f1ba975c33e27!100-3A33FCEB9B74CC15!20349",
-- "self": "https://graph.microsoft.com/v1.0/users/admin@chilkat.io/onenote/pages/0-dbd4707e211744b29e3f1ba975c33e27!100-3A33FCEB9B74CC15!20349",
-- "createdDateTime": "2020-10-22T22:40:11Z",
-- "title": "",
-- "createdByAppId": "",
-- "contentUrl": "https://graph.microsoft.com/v1.0/users/admin@chilkat.io/onenote/pages/0-dbd4707e211744b29e3f1ba975c33e27!100-3A33FCEB9B74CC15!20349/content",
-- "lastModifiedDateTime": "2020-10-22T22:40:11Z",
-- "links": {
-- "oneNoteClientUrl": {
-- "href": "onenote:https://d.docs.live.net/3a33fceb9b74cc15/Documents/Testing%20Notebook/Ccc.one#§ion-id=8529f2bb-4c5b-45eb-a076-0fd20ae34f96&page-id=3920f5fa-0cb6-4329-a9d7-956447af44c1&end"
-- },
-- "oneNoteWebUrl": {
-- "href": "https://onedrive.live.com/redir.aspx?cid=3a33fceb9b74cc15&page=edit&resid=3A33FCEB9B74CC15!20344&parId=3A33FCEB9B74CC15!187&wd=target%28Ccc.one%7C8529f2bb-4c5b-45eb-a076-0fd20ae34f96%2F%7C3920f5fa-0cb6-4329-a9d7-956447af44c1%2F%29"
-- }
-- },
-- "parentSection@odata.context": "https://graph.microsoft.com/v1.0/$metadata#users('admin%40chilkat.io')/onenote/pages('0-dbd4707e211744b29e3f1ba975c33e27%21100-3A33FCEB9B74CC15%2120349')/parentSection/$entity",
-- "parentSection": {
-- "id": "0-3A33FCEB9B74CC15!20349",
-- "displayName": "Ccc",
-- "self": "https://graph.microsoft.com/v1.0/users/admin@chilkat.io/onenote/sections/0-3A33FCEB9B74CC15!20349"
-- }
-- },
-- {
-- "id": "0-dbd4707e211744b29e3f1ba975c33e27!14-3A33FCEB9B74CC15!20347",
-- "self": "https://graph.microsoft.com/v1.0/users/admin@chilkat.io/onenote/pages/0-dbd4707e211744b29e3f1ba975c33e27!14-3A33FCEB9B74CC15!20347",
-- "createdDateTime": "2020-10-22T22:39:57Z",
-- "title": "",
-- "createdByAppId": "",
-- "contentUrl": "https://graph.microsoft.com/v1.0/users/admin@chilkat.io/onenote/pages/0-dbd4707e211744b29e3f1ba975c33e27!14-3A33FCEB9B74CC15!20347/content",
-- "lastModifiedDateTime": "2020-10-22T22:39:57Z",
-- "links": {
-- "oneNoteClientUrl": {
-- "href": "onenote:https://d.docs.live.net/3a33fceb9b74cc15/Documents/Testing%20Notebook/Aaa.one#§ion-id=21a7fa55-d7bb-4465-830e-5a1249daa2a9&page-id=534625c2-a982-4a72-a2f3-1032aa191d18&end"
-- },
-- "oneNoteWebUrl": {
-- "href": "https://onedrive.live.com/redir.aspx?cid=3a33fceb9b74cc15&page=edit&resid=3A33FCEB9B74CC15!20344&parId=3A33FCEB9B74CC15!187&wd=target%28Aaa.one%7C21a7fa55-d7bb-4465-830e-5a1249daa2a9%2F%7C534625c2-a982-4a72-a2f3-1032aa191d18%2F%29"
-- }
-- },
-- "parentSection@odata.context": "https://graph.microsoft.com/v1.0/$metadata#users('admin%40chilkat.io')/onenote/pages('0-dbd4707e211744b29e3f1ba975c33e27%2114-3A33FCEB9B74CC15%2120347')/parentSection/$entity",
-- "parentSection": {
-- "id": "0-3A33FCEB9B74CC15!20347",
-- "displayName": "Aaa",
-- "self": "https://graph.microsoft.com/v1.0/users/admin@chilkat.io/onenote/sections/0-3A33FCEB9B74CC15!20347"
-- }
-- }
-- ]
-- }
-- 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 @title nvarchar(4000)
DECLARE @createdByAppId nvarchar(4000)
DECLARE @contentUrl nvarchar(4000)
DECLARE @lastModifiedDateTime nvarchar(4000)
DECLARE @linksOneNoteClientUrlHref nvarchar(4000)
DECLARE @linksOneNoteWebUrlHref nvarchar(4000)
DECLARE @parentSectionodata_context nvarchar(4000)
DECLARE @parentSectionId nvarchar(4000)
DECLARE @parentSectionDisplayName nvarchar(4000)
DECLARE @parentSectionSelf 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', @title OUT, 'value[i].title'
EXEC sp_OAMethod @jResp, 'StringOf', @createdByAppId OUT, 'value[i].createdByAppId'
EXEC sp_OAMethod @jResp, 'StringOf', @contentUrl OUT, 'value[i].contentUrl'
EXEC sp_OAMethod @jResp, 'StringOf', @lastModifiedDateTime OUT, 'value[i].lastModifiedDateTime'
EXEC sp_OAMethod @jResp, 'StringOf', @linksOneNoteClientUrlHref OUT, 'value[i].links.oneNoteClientUrl.href'
EXEC sp_OAMethod @jResp, 'StringOf', @linksOneNoteWebUrlHref OUT, 'value[i].links.oneNoteWebUrl.href'
EXEC sp_OAMethod @jResp, 'StringOf', @parentSectionodata_context OUT, 'value[i]."parentSection@odata.context"'
EXEC sp_OAMethod @jResp, 'StringOf', @parentSectionId OUT, 'value[i].parentSection.id'
EXEC sp_OAMethod @jResp, 'StringOf', @parentSectionDisplayName OUT, 'value[i].parentSection.displayName'
EXEC sp_OAMethod @jResp, 'StringOf', @parentSectionSelf OUT, 'value[i].parentSection.self'
SELECT @i = @i + 1
END
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @sbResponseBody
EXEC @hr = sp_OADestroy @jResp
END
GO