(Excel) Create Task

Demonstrates how to create a new plannerTask.

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

Download Excel Class Modules Chilkat Excel Class Modules

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

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

' 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 Chilkat.JsonObject
Set jsonToken = Chilkat.NewJsonObject

success = jsonToken.LoadFile("qa_data/tokens/msGraphGroup.json")
If (success = False) Then
    Debug.Print jsonToken.LastErrorText
    Exit Sub
End If

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

' Create a JSON body for the HTTP POST
' Use this online tool to generate the code from sample JSON: 
' Generate Code to Create JSON

' {
'   "planId": "xqQg5FS2LkCp935s-FIFm2QAFkHM",
'   "bucketId": "hsOf2dhOJkqyYYZEtdzDe2QAIUCR",
'   "title": "Update client list",
'   "assignments": {
'     "fbab97d0-4932-4511-b675-204639209557": {
'       "@odata.type": "#microsoft.graph.plannerAssignment",
'       "orderHint": " !"
'     }
'   },
' }

Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
success = json.UpdateString("planId","xqQg5FS2LkCp935s-FIFm2QAFkHM")
success = json.UpdateString("bucketId","hsOf2dhOJkqyYYZEtdzDe2QAIUCR")
success = json.UpdateString("title","Update client list")
success = json.UpdateString("assignments.fbab97d0-4932-4511-b675-204639209557.""@odata.type""","#microsoft.graph.plannerAssignment")
success = json.UpdateString("assignments.fbab97d0-4932-4511-b675-204639209557.orderHint"," !")

' POST the JSON to https://graph.microsoft.com/v1.0/planner/tasks


Set resp = http.PostJson3("https://graph.microsoft.com/v1.0/planner/tasks","application/json",json)
If (http.LastMethodSuccess = False) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

success = json.Load(resp.BodyStr)
json.EmitCompact = False

If (resp.StatusCode <> 200) Then
    Debug.Print json.Emit()
    Debug.Print "Failed, response status code = "; resp.StatusCode

    Exit Sub
End If

Debug.Print json.Emit()

' A sample response:
' (See code for parsing this response below..)

' {
'   "createdBy": {
'     "user": {
'       "id": "6463a5ce-2119-4198-9f2a-628761df4a62"
'     }
'   },
'   "planId": "xqQg5FS2LkCp935s-FIFm2QAFkHM",
'   "bucketId": "hsOf2dhOJkqyYYZEtdzDe2QAIUCR",
'   "title": "Update client list",
'   "orderHint": "85752723360752+",
'   "createdDateTime": "2015-03-25T18:36:49.2407981Z",
'   "assignments": {
'     "fbab97d0-4932-4511-b675-204639209557": {
'       "@odata.type": "#microsoft.graph.plannerAssignment",
'       "assignedBy": {
'         "user": {
'           "id": "6463a5ce-2119-4198-9f2a-628761df4a62"
'         }
'       },
'       "assignedDateTime": "2015-03-25T18:36:49.2407981Z",
'       "orderHint": "RWk1"
'     }
'   },
'   "id":"01gzSlKkIUSUl6DF_EilrmQAKDhh"
' }

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


createdByUserId = json.StringOf("createdBy.user.id")

planId = json.StringOf("planId")

bucketId = json.StringOf("bucketId")

title = json.StringOf("title")

orderHint = json.StringOf("orderHint")

createdDateTime = json.StringOf("createdDateTime")

assignments_odataType = json.StringOf("assignments.fbab97d0-4932-4511-b675-204639209557.""@odata.type""")

assignmentsAssignedByUserId = json.StringOf("assignments.fbab97d0-4932-4511-b675-204639209557.assignedBy.user.id")

assignmentsAssignedDateTime = json.StringOf("assignments.fbab97d0-4932-4511-b675-204639209557.assignedDateTime")

assignmentsOrderHint = json.StringOf("assignments.fbab97d0-4932-4511-b675-204639209557.orderHint")

id = json.StringOf("id")

Debug.Print "Success."