(VBScript) Get Tasks for User

Demonstrates how to retrieve a list of plannertask objects assigned to a User.

See https://docs.microsoft.com/en-us/graph/api/planneruser-list-tasks?view=graph-rest-1.0 for more information.

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

Dim fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
'Create a Unicode (utf-16) output text file.
Set outFile = fso.CreateTextFile("output.txt", True, True)

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

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.Http")
set http = CreateObject("Chilkat.Http")

' The Microsoft Planner REST API requires an OAuth2 token with the Group.ReadWrite.All scope.
' Use your previously obtained access token as shown here:
'    Get Microsoft Graph OAuth2 Access Token with Group.ReadWrite.All scope.

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.JsonObject")
set jsonToken = CreateObject("Chilkat.JsonObject")
success = jsonToken.LoadFile("qa_data/tokens/msGraphGroup.json")
If (success = 0) Then
    outFile.WriteLine(jsonToken.LastErrorText)
    WScript.Quit
End If

http.AuthToken = jsonToken.StringOf("access_token")

' Send a GET request to https://graph.microsoft.com/v1.0/me/planner/tasks
strResponse = http.QuickGetStr("https://graph.microsoft.com/v1.0/me/planner/tasks")
If (http.LastMethodSuccess = 0) Then
    outFile.WriteLine(http.LastErrorText)
    WScript.Quit
End If

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.JsonObject")
set json = CreateObject("Chilkat.JsonObject")
success = json.Load(strResponse)
json.EmitCompact = 0

If (http.LastStatus <> 200) Then
    outFile.WriteLine(json.Emit())
    outFile.WriteLine("Failed, response status code = " & http.LastStatus)
    WScript.Quit
End If

outFile.WriteLine(json.Emit())

' Sample output:
' (See parsing code below..)

' {
'   "value": [
'     {
'       "createdBy": {
'         "user": {
'           "id": "6463a5ce-2119-4198-9f2a-628761df4a62"
'         }
'       },
'       "planId": "xqQg5FS2LkCp935s-FIFm2QAFkHM",
'       "bucketId": "gcrYAaAkgU2EQUvpkNNXLGQAGTtu",
'       "title": "title-value",
'       "orderHint": "9223370609546166567W",
'       "assigneePriority": "90057581\"",
'       "createdDateTime": "2015-03-25T18:36:49.2407981Z",
'       "assignments": {
'         "fbab97d0-4932-4511-b675-204639209557": {
'           "@odata.type": "#microsoft.graph.plannerAssignment",
'           "assignedBy": {
'             "user": {
'               "id": "1e9955d2-6acd-45bf-86d3-b546fdc795eb"
'             }
'           },
'           "assignedDateTime": "2015-03-25T18:38:21.956Z",
'           "orderHint": "RWk1"
'          }
'       },
'       "id":"01gzSlKkIUSUl6DF_EilrmQAKDhh"
'     }
'   ]
' }

i = 0
count_i = json.SizeOfArray("value")
Do While i < count_i
    json.I = i
    createdByUserId = json.StringOf("value[i].createdBy.user.id")
    planId = json.StringOf("value[i].planId")
    bucketId = json.StringOf("value[i].bucketId")
    title = json.StringOf("value[i].title")
    orderHint = json.StringOf("value[i].orderHint")
    assigneePriority = json.StringOf("value[i].assigneePriority")
    createdDateTime = json.StringOf("value[i].createdDateTime")

    ' jsonA is a Chilkat.JsonObject
    Set jsonA = json.ObjectOf("value[i].assignments")
    userId = jsonA.NameAt(0)
    ' jsonUserA is a Chilkat.JsonObject
    Set jsonUserA = jsonA.ObjectOf(userId)
    assignments_odataType = jsonUserA.StringOf("""@odata.type""")
    assignmentsAssignedByUserId = jsonUserA.StringOf("assignedBy.user.id")
    assignmentsAssignedDateTime = jsonUserA.StringOf("assignedDateTime")
    assignmentsOrderHint = jsonUserA.StringOf("orderHint")

    id = json.StringOf("value[i].id")
    i = i + 1
Loop

outFile.WriteLine("Success.")

outFile.Close