|
Chilkat • HOME • .NET Core C# • Android™ • AutoIt • C • C# • C++ • Chilkat2-Python • CkPython • Classic ASP • DataFlex • Delphi ActiveX • Delphi DLL • Go • Java • Lianja • Mono C# • Node.js • Objective-C • PHP ActiveX • PHP Extension • Perl • PowerBuilder • PowerShell • PureBasic • Ruby • SQL Server • Swift 2 • Swift 3,4,5... • Tcl • Unicode C • Unicode C++ • VB.NET • VBScript • Visual Basic 6.0 • Visual FoxPro • Xojo Plugin
(SQL Server) OneNote - Get Page HTML ContentDownload the HTML content of a OneNote page. Also iterates over the images and attachments on the OneNote page and downloads the content for each. For more information, see https://docs.microsoft.com/en-us/graph/api/page-get?view=graph-rest-1.0
-- 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) -- This example assumes the Chilkat API to have been previously unlocked. -- See Global Unlock Sample for sample code. DECLARE @http int -- Use "Chilkat_9_5_0.Http" for versions of Chilkat < 10.0.0 EXEC @hr = sp_OACreate 'Chilkat.Http', @http OUT IF @hr <> 0 BEGIN PRINT 'Failed to create ActiveX component' RETURN END DECLARE @success int -- 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 -- Use "Chilkat_9_5_0.StringBuilder" for versions of Chilkat < 10.0.0 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 -- Use "Chilkat_9_5_0.Xml" for versions of Chilkat < 10.0.0 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 -- Use "Chilkat_9_5_0.StringBuilder" for versions of Chilkat < 10.0.0 EXEC @hr = sp_OACreate 'Chilkat.StringBuilder', @sbState OUT DECLARE @url nvarchar(4000) DECLARE @bd int -- Use "Chilkat_9_5_0.BinData" for versions of Chilkat < 10.0.0 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 |
||||
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.