(Visual Basic 6.0) List Plans for a Group

Demonstrates how to retrieve a list of plannerPlan objects owned by a group object.

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

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

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

Dim http As New ChilkatHttp

' 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.

Dim jsonToken As New ChilkatJsonObject
Dim success As Long
success = jsonToken.LoadFile("qa_data/tokens/msGraphGroup.json")
If (success = 0) Then
    Debug.Print jsonToken.LastErrorText
    Exit Sub
End If

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

' Send a GET request to https://graph.microsoft.com/v1.0/groups/{group-id}/planner/plans
Dim strResponse As String
strResponse = http.QuickGetStr("https://graph.microsoft.com/v1.0/groups/{group-id}/planner/plans")
If (http.LastMethodSuccess = 0) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Dim json As New ChilkatJsonObject
success = json.Load(strResponse)
json.EmitCompact = 0

If (http.LastStatus <> 200) Then
    Debug.Print json.Emit()
    Debug.Print "Failed, response status code = " & http.LastStatus
    Exit Sub
End If

Debug.Print json.Emit()

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

' {
'   "value": [
'     {
'       "createdBy": {
'         "application": {
'           "id": "95e27074-6c4a-447a-aa24-9d718a0b86fa"
'         },
'         "user": {
'           "id": "ebf3b108-5234-4e22-b93d-656d7dae5874"
'         }
'       },
'       "createdDateTime": "2015-03-30T18:36:49.2407981Z",
'       "owner": "ebf3b108-5234-4e22-b93d-656d7dae5874",
'       "title": "title-value",
'       "id": "xqQg5FS2LkCp935s-FIFm2QAFkHM"
'     }
'   ]
' }

' Use this online tool to generate parsing code from sample JSON: 
' Generate Parsing Code from JSON

Dim i As Long
Dim count_i As Long
Dim createdByApplicationId As String
Dim createdByUserId As String
Dim createdDateTime As String
Dim owner As String
Dim title As String
Dim id As String

i = 0
count_i = json.SizeOfArray("value")
Do While i < count_i
    json.I = i
    createdByApplicationId = json.StringOf("value[i].createdBy.application.id")
    createdByUserId = json.StringOf("value[i].createdBy.user.id")
    createdDateTime = json.StringOf("value[i].createdDateTime")
    owner = json.StringOf("value[i].owner")
    title = json.StringOf("value[i].title")
    id = json.StringOf("value[i].id")
    i = i + 1
Loop

Debug.Print "Success."