SQL Server
SQL Server
OneNote - Get Page HTML Content
See more OneNote Examples
Download the HTML content of a OneNote page. Also iterates over the images and attachments on the OneNote page and downloads the content for each.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
DECLARE @iTmp0 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/{id}/content?includeIDs=true \
-- -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, 'page_id', '0-d2298668edd74dccac7f821fa378bf64!41-3A33FCEB9B74CC15!20350'
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/{$page_id}/content?includeIDs=true', @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
PRINT 'HTML content:'
EXEC sp_OAMethod @sbResponseBody, 'GetAsString', @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
RETURN
END
-- Let's get the images and attached files.
-- Here's sample HTML content with 2 images and one PDF attachment:
-- <html lang="en-US">
-- <head>
-- <title>A page with rendered images and an attached file</title>
-- <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
-- <meta name="created" content="2020-10-23T12:00:00.0000000" />
-- </head>
-- <body data-absolute-enabled="true" style="font-family:Calibri;font-size:11pt">
-- <div id="div:{b130eb6c-638a-4f97-8f7e-b6d9e2e88bf9}{32}" data-id="_default" style="position:absolute;left:48px;top:120px;width:624px">
-- <p id="p:{b130eb6c-638a-4f97-8f7e-b6d9e2e88bf9}{39}" style="margin-top:5.5pt;margin-bottom:5.5pt">Here's an image from an online source:</p>
-- <img id="img:{ee18fe8d-b219-4baf-9b4d-4fc680579f0d}{1}" alt="an image on the page" width="500" height="500" src="https://graph.microsoft.com/v1.0/users('admin@chilkat.io')/onenote/resources/0-e71b45b763484921b4200e32c2439a47!1-3A33FCEB9B74CC15!20350/$value" data-src-type="image/jpeg" data-fullres-src="https://graph.microsoft.com/v1.0/users('admin@chilkat.io')/onenote/resources/0-e71b45b763484921b4200e32c2439a47!1-3A33FCEB9B74CC15!20350/$value" data-fullres-src-type="image/jpeg" />
-- <p id="p:{b130eb6c-638a-4f97-8f7e-b6d9e2e88bf9}{43}" style="margin-top:5.5pt;margin-bottom:5.5pt">Here's an image uploaded as binary data:</p>
-- <img id="img:{ee18fe8d-b219-4baf-9b4d-4fc680579f0d}{3}" alt="an image on the page" width="300" height="225" src="https://graph.microsoft.com/v1.0/users('admin@chilkat.io')/onenote/resources/0-a60516b962b842f2ae9bec75c16b31de!1-3A33FCEB9B74CC15!20350/$value" data-src-type="image/jpeg" data-fullres-src="https://graph.microsoft.com/v1.0/users('admin@chilkat.io')/onenote/resources/0-a60516b962b842f2ae9bec75c16b31de!1-3A33FCEB9B74CC15!20350/$value" data-fullres-src-type="image/jpeg" />
-- <p id="p:{b130eb6c-638a-4f97-8f7e-b6d9e2e88bf9}{47}" style="margin-top:5.5pt;margin-bottom:5.5pt">Here's a file attachment:</p>
-- <object data-attachment="FileName.pdf" type="application/pdf" data="https://graph.microsoft.com/v1.0/users('admin@chilkat.io')/onenote/resources/0-9e685efb33a24a6a8de1b9c707d28385!1-3A33FCEB9B74CC15!20350/$value" />
-- </div>
-- </body>
-- </html>
DECLARE @xml int
EXEC @hr = sp_OACreate 'Chilkat.Xml', @xml OUT
EXEC sp_OAMethod @xml, 'LoadSb', @success OUT, @sbResponseBody, 1
-- Iterate over each element in the XML. Each time we find an "img" or "object", download the data.
-- (The sbState is an object used to keep track of the current state of the traversal.)
DECLARE @sbState int
EXEC @hr = sp_OACreate 'Chilkat.StringBuilder', @sbState OUT
DECLARE @url nvarchar(4000)
DECLARE @bd int
EXEC @hr = sp_OACreate 'Chilkat.BinData', @bd OUT
EXEC sp_OAMethod @xml, 'NextInTraversal2', @iTmp0 OUT, @sbState
WHILE @iTmp0 <> 0
BEGIN
EXEC sp_OAMethod @xml, 'TagEquals', @iTmp0 OUT, 'img'
IF @iTmp0 = 1
BEGIN
EXEC sp_OAMethod @xml, 'GetAttrValue', @sTmp0 OUT, 'id'
PRINT 'img id: ' + @sTmp0
EXEC sp_OAMethod @xml, 'GetAttrValue', @url OUT, 'src'
EXEC sp_OAMethod @bd, 'Clear', @success OUT
EXEC sp_OAMethod @http, 'QuickGetBd', @success OUT, @url, @bd
IF @success = 0
BEGIN
EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT
PRINT @sTmp0
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @sbResponseBody
EXEC @hr = sp_OADestroy @xml
EXEC @hr = sp_OADestroy @sbState
EXEC @hr = sp_OADestroy @bd
RETURN
END
PRINT 'Downloaded from ' + @url
PRINT '----'
-- If desired, bd.WriteFile to save the contents of bd to a file..
END
EXEC sp_OAMethod @xml, 'TagEquals', @iTmp0 OUT, 'object'
IF @iTmp0 = 1
BEGIN
EXEC sp_OAMethod @xml, 'GetAttrValue', @sTmp0 OUT, 'data-attachment'
PRINT 'data-attachment: ' + @sTmp0
EXEC sp_OAMethod @xml, 'GetAttrValue', @sTmp0 OUT, 'type'
PRINT 'type: ' + @sTmp0
EXEC sp_OAMethod @xml, 'GetAttrValue', @url OUT, 'data'
EXEC sp_OAMethod @bd, 'Clear', @success OUT
EXEC sp_OAMethod @http, 'QuickGetBd', @success OUT, @url, @bd
IF @success = 0
BEGIN
EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT
PRINT @sTmp0
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @sbResponseBody
EXEC @hr = sp_OADestroy @xml
EXEC @hr = sp_OADestroy @sbState
EXEC @hr = sp_OADestroy @bd
RETURN
END
PRINT 'Downloaded from ' + @url
PRINT '----'
-- If desired, bd.WriteFile to save the contents of bd to a file..
END
END
PRINT 'Success.'
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @sbResponseBody
EXEC @hr = sp_OADestroy @xml
EXEC @hr = sp_OADestroy @sbState
EXEC @hr = sp_OADestroy @bd
END
GO