(Excel) Update a Task's Status to "completed"

Demonstrates how to update a Google task's status to "completed".

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.

' Get the previously obtained access token.
' See Get Google Tasks Access Token.

Dim fac As Chilkat.FileAccess
Set fac = Chilkat.NewFileAccess

accessToken = fac.ReadEntireTextFile("qa_data/tokens/googleTasks.txt","utf-8")
If (fac.LastMethodSuccess <> True) Then
    Debug.Print fac.LastErrorText
    Exit Sub
End If

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

http.AuthToken = accessToken


taskId = "MDM4MzQ4NTA3NDQwMDUxMzQ2OTQ6NzAwOTA4MDA1NzU2ODYwMzoyMDg3OTcyMDA1MTQ5NTA0"

' Create the JSON to update the task status to completed.
Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
success = json.UpdateString("id",taskId)
success = json.UpdateString("status","completed")

' Specify the ID's for both the task list and the task.
success = http.SetUrlVar("tasklist","MDM4MzQ4NTA3NDQwMDUxMzQ2OTQ6NzAwOTA4MDA1NzU2ODYwMzow")
success = http.SetUrlVar("task",taskId)


url = "https://www.googleapis.com/tasks/v1/lists/{$tasklist}/tasks/{$task}"

Set resp = http.PText("PUT",url,json.Emit(),"utf-8","application/json",False,False)
If (http.LastMethodSuccess = False) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

' Show the response body.
Debug.Print resp.BodyStr

' Examine the response status code.
Debug.Print "response status code: "; resp.StatusCode

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

' 
' {
'  "kind": "tasks#task",
'  "id": "MDM4MzQ4NTA3NDQwMDUxMzQ2OTQ6NzAwOTA4MDA1NzU2ODYwMzoyMDg3OTcyMDA1MTQ5NTA0",
'  "etag": "\"84_7Cubo3y98GMV9bE3zQclHxhc/MTQyMDUzMzQ4MA\"",
'  "title": "Get haircut",
'  "updated": "2019-04-04T18:07:58.000Z",
'  "selfLink": "https://www.googleapis.com/tasks/v1/lists/MDM4MzQ4NTA3NDQwMDUxMzQ2OTQ6NzAwOTA4MDA1NzU2ODYwMzow/tasks/MDM4MzQ4NTA3NDQwMDUxMzQ2OTQ6NzAwOTA4MDA1NzU2ODYwMzoyMDg3OTcyMDA1MTQ5NTA0",
'  "position": "00000000001610612734",
'  "notes": "Check in online first.",
'  "status": "completed",
'  "completed": "2019-04-04T18:38:56.000Z"
' }
' 
' response status code: 200