(Visual Basic 6.0) OneNote - List Sections

Retrieve a list of sections from the specified notebook.

For more information, see https://docs.microsoft.com/en-us/graph/api/notebook-list-sections?view=graph-rest-1.0&tabs=http

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

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

Dim http As New ChilkatHttp
Dim success As Long

' 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.
http.AuthToken = "ACCESS_TOKEN"

success = http.SetUrlVar("id","0-3A33FCEB9B74CC15!20344")

Dim sbResponseBody As New ChilkatStringBuilder
success = http.QuickGetSb("https://graph.microsoft.com/v1.0/me/onenote/notebooks/{$id}/sections",sbResponseBody)
If (success = 0) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Dim jResp As New ChilkatJsonObject
success = jResp.LoadSb(sbResponseBody)
jResp.EmitCompact = 0

Debug.Print "Response Body:"
Debug.Print jResp.Emit()

Dim respStatusCode As Long
respStatusCode = http.LastStatus
Debug.Print "Response Status Code = " & respStatusCode
If (respStatusCode >= 400) Then
    Debug.Print "Response Header:"
    Debug.Print http.LastHeader
    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/notebooks('0-3A33FCEB9B74CC15%2120344')/sections",
'   "value": [
'     {
'       "id": "0-3A33FCEB9B74CC15!20347",
'       "self": "https://graph.microsoft.com/v1.0/users/admin@chilkat.io/onenote/sections/0-3A33FCEB9B74CC15!20347",
'       "createdDateTime": "2020-10-22T22:39:58.247Z",
'       "displayName": "Aaa",
'       "lastModifiedDateTime": "2020-10-22T22:40:00.363Z",
'       "isDefault": false,
'       "pagesUrl": "https://graph.microsoft.com/v1.0/users/admin@chilkat.io/onenote/sections/0-3A33FCEB9B74CC15!20347/pages",
'       "createdBy": {
'         "user": {
'           "id": "3A33FCEB9B74CC15",
'           "displayName": "Matt Smith"
'         }
'       },
'       "lastModifiedBy": {
'         "user": {
'           "id": "3A33FCEB9B74CC15",
'           "displayName": "Matt Smith"
'         }
'       },
'       "parentNotebook@odata.context": "https://graph.microsoft.com/v1.0/$metadata#users('admin%40chilkat.io')/onenote/notebooks('0-3A33FCEB9B74CC15%2120344')/sections('0-3A33FCEB9B74CC15%2120347')/parentNotebook/$entity",
'       "parentNotebook": {
'         "id": "0-3A33FCEB9B74CC15!20344",
'         "displayName": "Testing Notebook",
'         "self": "https://graph.microsoft.com/v1.0/users/admin@chilkat.io/onenote/notebooks/0-3A33FCEB9B74CC15!20344"
'       },
'       "parentSectionGroup@odata.context": "https://graph.microsoft.com/v1.0/$metadata#users('admin%40chilkat.io')/onenote/notebooks('0-3A33FCEB9B74CC15%2120344')/sections('0-3A33FCEB9B74CC15%2120347')/parentSectionGroup/$entity",
'       "parentSectionGroup": null
'     },
'     {
'       "id": "0-3A33FCEB9B74CC15!20348",
'       "self": "https://graph.microsoft.com/v1.0/users/admin@chilkat.io/onenote/sections/0-3A33FCEB9B74CC15!20348",
'       "createdDateTime": "2020-10-22T22:40:09.227Z",
'       "displayName": "Bbb",
'       "lastModifiedDateTime": "2020-10-22T22:40:12.21Z",
'       "isDefault": false,
'       "pagesUrl": "https://graph.microsoft.com/v1.0/users/admin@chilkat.io/onenote/sections/0-3A33FCEB9B74CC15!20348/pages",
'       "createdBy": {
'         "user": {
'           "id": "3A33FCEB9B74CC15",
'           "displayName": "Matt Smith"
'         }
'       },
'       "lastModifiedBy": {
'         "user": {
'           "id": "3A33FCEB9B74CC15",
'           "displayName": "Matt Smith"
'         }
'       },
'       "parentNotebook@odata.context": "https://graph.microsoft.com/v1.0/$metadata#users('admin%40chilkat.io')/onenote/notebooks('0-3A33FCEB9B74CC15%2120344')/sections('0-3A33FCEB9B74CC15%2120348')/parentNotebook/$entity",
'       "parentNotebook": {
'         "id": "0-3A33FCEB9B74CC15!20344",
'         "displayName": "Testing Notebook",
'         "self": "https://graph.microsoft.com/v1.0/users/admin@chilkat.io/onenote/notebooks/0-3A33FCEB9B74CC15!20344"
'       },
'       "parentSectionGroup@odata.context": "https://graph.microsoft.com/v1.0/$metadata#users('admin%40chilkat.io')/onenote/notebooks('0-3A33FCEB9B74CC15%2120344')/sections('0-3A33FCEB9B74CC15%2120348')/parentSectionGroup/$entity",
'       "parentSectionGroup": null
'     },
'     {
'       "id": "0-3A33FCEB9B74CC15!20349",
'       "self": "https://graph.microsoft.com/v1.0/users/admin@chilkat.io/onenote/sections/0-3A33FCEB9B74CC15!20349",
'       "createdDateTime": "2020-10-22T22:40:12.517Z",
'       "displayName": "Ccc",
'       "lastModifiedDateTime": "2020-10-22T22:40:14.367Z",
'       "isDefault": false,
'       "pagesUrl": "https://graph.microsoft.com/v1.0/users/admin@chilkat.io/onenote/sections/0-3A33FCEB9B74CC15!20349/pages",
'       "createdBy": {
'         "user": {
'           "id": "3A33FCEB9B74CC15",
'           "displayName": "Matt Smith"
'         }
'       },
'       "lastModifiedBy": {
'         "user": {
'           "id": "3A33FCEB9B74CC15",
'           "displayName": "Matt Smith"
'         }
'       },
'       "parentNotebook@odata.context": "https://graph.microsoft.com/v1.0/$metadata#users('admin%40chilkat.io')/onenote/notebooks('0-3A33FCEB9B74CC15%2120344')/sections('0-3A33FCEB9B74CC15%2120349')/parentNotebook/$entity",
'       "parentNotebook": {
'         "id": "0-3A33FCEB9B74CC15!20344",
'         "displayName": "Testing Notebook",
'         "self": "https://graph.microsoft.com/v1.0/users/admin@chilkat.io/onenote/notebooks/0-3A33FCEB9B74CC15!20344"
'       },
'       "parentSectionGroup@odata.context": "https://graph.microsoft.com/v1.0/$metadata#users('admin%40chilkat.io')/onenote/notebooks('0-3A33FCEB9B74CC15%2120344')/sections('0-3A33FCEB9B74CC15%2120349')/parentSectionGroup/$entity",
'       "parentSectionGroup": null
'     }
'   ]
' }

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

Dim id As String
Dim self As String
Dim createdDateTime As String
Dim displayName As String
Dim lastModifiedDateTime As String
Dim isDefault As Long
Dim pagesUrl As String
Dim createdByUserId As String
Dim createdByUserDisplayName As String
Dim lastModifiedByUserId As String
Dim lastModifiedByUserDisplayName As String
Dim parentNotebookodata_context As String
Dim parentNotebookId As String
Dim parentNotebookDisplayName As String
Dim parentNotebookSelf As String
Dim parentSectionGroupodata_context As String
Dim parentSectionGroup As String

Dim odata_context As String
odata_context = jResp.StringOf("""@odata.context""")
Dim i As Long
i = 0
Dim count_i As Long
count_i = jResp.SizeOfArray("value")
Do While i < count_i
    jResp.I = i
    id = jResp.StringOf("value[i].id")
    self = jResp.StringOf("value[i].self")
    createdDateTime = jResp.StringOf("value[i].createdDateTime")
    displayName = jResp.StringOf("value[i].displayName")
    lastModifiedDateTime = jResp.StringOf("value[i].lastModifiedDateTime")
    isDefault = jResp.BoolOf("value[i].isDefault")
    pagesUrl = jResp.StringOf("value[i].pagesUrl")
    createdByUserId = jResp.StringOf("value[i].createdBy.user.id")
    createdByUserDisplayName = jResp.StringOf("value[i].createdBy.user.displayName")
    lastModifiedByUserId = jResp.StringOf("value[i].lastModifiedBy.user.id")
    lastModifiedByUserDisplayName = jResp.StringOf("value[i].lastModifiedBy.user.displayName")
    parentNotebookodata_context = jResp.StringOf("value[i].""parentNotebook@odata.context""")
    parentNotebookId = jResp.StringOf("value[i].parentNotebook.id")
    parentNotebookDisplayName = jResp.StringOf("value[i].parentNotebook.displayName")
    parentNotebookSelf = jResp.StringOf("value[i].parentNotebook.self")
    parentSectionGroupodata_context = jResp.StringOf("value[i].""parentSectionGroup@odata.context""")
    parentSectionGroup = jResp.StringOf("value[i].parentSectionGroup")
    i = i + 1
Loop