(Excel) OneNote - Create Page

Creates a new OneNote page with a rendered image and an attached PDF.

For more information, see https://docs.microsoft.com/en-us/graph/api/section-post-pages?view=graph-rest-1.0

Download Excel Class Modules

Chilkat Excel Class Modules

' This example assumes the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.

Dim http As Chilkat.Http
Set http = Chilkat.NewHttp

' To create a OneNote page, we want to send an HTTP request like the following:

' POST https://graph.microsoft.com/v1.0/me/onenote/sections/{section_id}/pages
' Content-length: 312
' Content-type: multipart/form-data; boundary=MyPartBoundary198374
' 
' --MyPartBoundary198374
' Content-Disposition:form-data; name="Presentation"
' Content-Type:text/html
' 
' <!DOCTYPE html>
' <html>
'   <head>
'     <title>A page with <i>rendered</i> images and an <b>attached</b> file</title>
'     <meta name="created" content="2015-07-22T09:00:00-08:00" />
'   </head>
'   <body>
'     <p>Here's an image from an online source:</p>
'     <img src="https://..." alt="an image on the page" width="500" />
'     <p>Here's an image uploaded as binary data:</p>
'     <img src="name:imageBlock1" alt="an image on the page" width="300" />
'     <p>Here's a file attachment:</p>
'     <object data-attachment="FileName.pdf" data="name:fileBlock1" type="application/pdf" />
'   </body>
' </html>
' 
' --MyPartBoundary198374
' Content-Disposition:form-data; name="imageBlock1"
' Content-Type:image/jpeg
' 
' ... binary image data ...
' 
' --MyPartBoundary198374
' Content-Disposition:form-data; name="fileBlock1"
' Content-Type:application/pdf
' 
' ... binary file data ...
' 
' --MyPartBoundary198374--

' Build the request in a Chilkat HTTP request object:
Dim req As Chilkat.HttpRequest
Set req = Chilkat.NewHttpRequest

' Our URL is https://graph.microsoft.com/v1.0/me/onenote/sections/{section_id}/pages
' The path part of the URL is "/v1.0/me/onenote/sections/{section_id}/pages"
' In this example, our section ID is "0-3A33FCEB9B74CC15!20350"
req.Path = "/v1.0/me/onenote/sections/0-3A33FCEB9B74CC15!20350/pages"

' We'll be sending a POST.
req.HttpVerb = "POST"

' The Content-Type is multipart/form-data
' Chilkat will automatically generate a boundary string.
req.ContentType = "multipart/form-data"

' When Chilkat HTTP was written many years ago, multipart requests were primarily for uploads.
' Thus the names of methods that add a multipart section end with "ForUpload".
' The multipart request we wish to build has 3 sections: text/html, image/jpeg, and application/pdf.

' ------------------------------
' Add the text/html part.
' ------------------------------
Dim sbHtml As Chilkat.StringBuilder
Set sbHtml = Chilkat.NewStringBuilder

bCrlf = True
Dim success As Boolean
success = sbHtml.AppendLine("<!DOCTYPE html>",bCrlf)
success = sbHtml.AppendLine("<html>",bCrlf)
success = sbHtml.AppendLine("  <head>",bCrlf)
success = sbHtml.AppendLine("    <title>A page with <i>rendered</i> images and an <b>attached</b> file</title>",bCrlf)
success = sbHtml.AppendLine("    <meta name=""created"" content=""TIMESTAMP_CURRENT"" />",bCrlf)
success = sbHtml.AppendLine("  </head>",bCrlf)
success = sbHtml.AppendLine("  <body>",bCrlf)
success = sbHtml.AppendLine("    <p>Here's an image from an online source:</p>",bCrlf)
success = sbHtml.AppendLine("    <img src=""https://www.chilkatsoft.com/images/starfish.jpg"" alt=""an image on the page"" width=""500"" />",bCrlf)
success = sbHtml.AppendLine("    <p>Here's an image uploaded as binary data:</p>",bCrlf)
success = sbHtml.AppendLine("    <img src=""name:imageBlock1"" alt=""an image on the page"" width=""300"" />",bCrlf)
success = sbHtml.AppendLine("    <p>Here's a file attachment:</p>",bCrlf)
success = sbHtml.AppendLine("    <object data-attachment=""FileName.pdf"" data=""name:fileBlock1"" type=""application/pdf"" />",bCrlf)
success = sbHtml.AppendLine("  </body>",bCrlf)
success = sbHtml.AppendLine("</html>",bCrlf)

Dim dtNow As Chilkat.CkDateTime
Set dtNow = Chilkat.NewCkDateTime
success = dtNow.SetFromCurrentSystemTime()

numReplaced = sbHtml.Replace("TIMESTAMP_CURRENT",dtNow.GetAsTimestamp(True))

success = req.AddStringForUpload2("Presentation","",sbHtml.GetAsString(),"utf-8","text/html")

' ------------------------------
' Add the JPG image.
' ------------------------------
success = req.AddFileForUpload2("imageBlock1","qa_data/jpg/penguins2.jpg","image/jpeg")
If (success = False) Then
    Debug.Print req.LastErrorText
    Exit Sub
End If

' ------------------------------
' Add the PDF attachment.
' ------------------------------
Dim bdPdf As Chilkat.BinData
Set bdPdf = Chilkat.NewBinData
success = bdPdf.LoadFile("qa_data/pdf/helloWorld.pdf")
If (success = False) Then
    Debug.Print "Failed to load PDF file."
    Exit Sub
End If

success = req.AddBdForUpload("fileBlock1","FileName.pdf",bdPdf,"application/pdf")
If (success = False) Then
    Debug.Print req.LastErrorText
    Exit Sub
End If

' Adds the "Authorization: Bearer ACCESS_TOKEN" header.
http.AuthToken = "ACCESS_TOKEN"

' POST to https://graph.microsoft.com/v1.0/me/onenote/sections/{section_id}/pages
' The path part of the URL is already specified in the req object.
' We only need to specify the domain and the fact that we're doing "https" (SSL/TLS).

Set resp = http.SynchronousRequest("graph.microsoft.com",443,True,req)
If (http.LastMethodSuccess = False) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Dim sbResponseBody As Chilkat.StringBuilder
Set sbResponseBody = Chilkat.NewStringBuilder
success = resp.GetBodySb(sbResponseBody)
Dim jResp As Chilkat.JsonObject
Set jResp = Chilkat.NewJsonObject
success = jResp.LoadSb(sbResponseBody)
jResp.EmitCompact = False

Debug.Print "Response status code: "; resp.StatusCode
Debug.Print "Response Body:"
Debug.Print jResp.Emit()


respStatusCode = resp.StatusCode
Debug.Print "Response Status Code = "; respStatusCode
If (respStatusCode >= 400) Then
    Debug.Print "Response Header:"
    Debug.Print resp.Header
    Debug.Print "Failed."

    Exit Sub
End If

' 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/sections('0-3A33FCEB9B74CC15%2120350')/pages/$entity",
'   "id": "0-18ac61117a664f7e946bcceaeebd6f57!36-3A33FCEB9B74CC15!20350",
'   "self": "https://graph.microsoft.com/v1.0/users/admin@chilkat.io/onenote/pages/0-18ac61117a664f7e946bcceaeebd6f57!36-3A33FCEB9B74CC15!20350",
'   "createdDateTime": "2020-10-22T19:02:12Z",
'   "title": "A page with rendered images and an attached file",
'   "createdByAppId": "WLID-00000000441C9990",
'   "contentUrl": "https://graph.microsoft.com/v1.0/users/admin@chilkat.io/onenote/pages/0-18ac61117a664f7e946bcceaeebd6f57!36-3A33FCEB9B74CC15!20350/content",
'   "lastModifiedDateTime": "2020-10-23T00:02:13.3254289Z",
'   "links": {
'     "oneNoteClientUrl": {
'       "href": "onenote:https://d.docs.live.net/3a33fceb9b74cc15/Documents/Testing%20Notebook/Ddd.one#A%20page%20with%20rendered%20images%20and%20an%20attached%20file&section-id=9d78c221-486e-45f8-8355-1810e475f6c0&page-id=36cd1982-1ef1-4b11-b5a1-30b3dbc43d05&end"
'     },
'     "oneNoteWebUrl": {
'       "href": "https://onedrive.live.com/redir.aspx?cid=3a33fceb9b74cc15&page=edit&resid=3A33FCEB9B74CC15!20344&parId=3A33FCEB9B74CC15!187&wd=target%28Ddd.one%7C9d78c221-486e-45f8-8355-1810e475f6c0%2FA%20page%20with%20rendered%20images%20and%20an%20attached%20file%7C36cd1982-1ef1-4b11-b5a1-30b3dbc43d05%2F%29"
'     }
'   }
' }

' Sample code for parsing the JSON response...
' Use the following online tool to generate parsing code from sample JSON:
' Generate Parsing Code from JSON


odata_context = jResp.StringOf("""@odata.context""")

id = jResp.StringOf("id")

self = jResp.StringOf("self")

createdDateTime = jResp.StringOf("createdDateTime")

title = jResp.StringOf("title")

createdByAppId = jResp.StringOf("createdByAppId")

contentUrl = jResp.StringOf("contentUrl")

lastModifiedDateTime = jResp.StringOf("lastModifiedDateTime")

linksOneNoteClientUrlHref = jResp.StringOf("links.oneNoteClientUrl.href")

linksOneNoteWebUrlHref = jResp.StringOf("links.oneNoteWebUrl.href")