(Visual FoxPro) Get all Tasks on a List

Demonstrates how to get all the tasks in a Google task list.

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

LOCAL loFac
LOCAL lcAccessToken
LOCAL loHttp
LOCAL loResp
LOCAL lcKind
LOCAL lcEtag
LOCAL i
LOCAL lnCount_i
LOCAL lcId
LOCAL lcTitle
LOCAL lcUpdated
LOCAL lcSelfLink
LOCAL lcPosition
LOCAL lcNotes
LOCAL lcStatus
LOCAL lcDue
LOCAL loJson

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

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.FileAccess')
loFac = CreateObject('Chilkat.FileAccess')
lcAccessToken = loFac.ReadEntireTextFile("qa_data/tokens/googleTasks.txt","utf-8")
IF (loFac.LastMethodSuccess <> 1) THEN
    ? loFac.LastErrorText
    RELEASE loFac
    CANCEL
ENDIF

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.Http')
loHttp = CreateObject('Chilkat.Http')

loHttp.AuthToken = lcAccessToken

* Get the tasks from the task list w/ id = MDM4MzQ4NTA3NDQwMDUxMzQ2OTQ6NzAwOTA4MDA1NzU2ODYwMzow
loHttp.SetUrlVar("tasklist","MDM4MzQ4NTA3NDQwMDUxMzQ2OTQ6NzAwOTA4MDA1NzU2ODYwMzow")

loResp = loHttp.QuickGetObj("https://www.googleapis.com/tasks/v1/lists/{$tasklist}/tasks")
IF (loHttp.LastMethodSuccess = 0) THEN
    ? loHttp.LastErrorText
    RELEASE loFac
    RELEASE loHttp
    CANCEL
ENDIF

* Show the response body.
? loResp.BodyStr

* Examine the response status code.
? "response status code: " + STR(loResp.StatusCode)

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

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.JsonObject')
loJson = CreateObject('Chilkat.JsonObject')
loJson.Load(loResp.BodyStr)

lcKind = loJson.StringOf("kind")
lcEtag = loJson.StringOf("etag")
i = 0
lnCount_i = loJson.SizeOfArray("items")
DO WHILE i < lnCount_i
    loJson.I = i
    lcKind = loJson.StringOf("items[i].kind")
    lcId = loJson.StringOf("items[i].id")
    lcEtag = loJson.StringOf("items[i].etag")
    lcTitle = loJson.StringOf("items[i].title")
    lcUpdated = loJson.StringOf("items[i].updated")
    lcSelfLink = loJson.StringOf("items[i].selfLink")
    lcPosition = loJson.StringOf("items[i].position")
    lcNotes = loJson.StringOf("items[i].notes")
    lcStatus = loJson.StringOf("items[i].status")
    lcDue = loJson.StringOf("items[i].due")
    i = i + 1
ENDDO

RELEASE loResp

* Sample response:

* {
*  "kind": "tasks#tasks",
*  "etag": "\"84_7Cubo3y98GMV9bE3zQclHxhc/LTM3Njg4MjgyNA\"",
*  "items": [
*   {
*    "kind": "tasks#task",
*    "id": "MDM4MzQ4NTA3NDQwMDUxMzQ2OTQ6NzAwOTA4MDA1NzU2ODYwMzoyMDg3OTcyMDA1MTQ5NTA0",
*    "etag": "\"84_7Cubo3y98GMV9bE3zQclHxhc/NjcyMTU4Mg\"",
*    "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": "needsAction",
*    "due": "2019-04-07T00:00:00.000Z"
*   },
*   {
*    "kind": "tasks#task",
*    "id": "MDM4MzQ4NTA3NDQwMDUxMzQ2OTQ6NzAwOTA4MDA1NzU2ODYwMzoxMTg0MzQxMTkzMjM2MDY1",
*    "etag": "\"84_7Cubo3y98GMV9bE3zQclHxhc/MTU1MjQzNDIwMQ\"",
*    "title": "Go to grocery store",
*    "updated": "2019-04-04T17:59:15.000Z",
*    "selfLink": "https://www.googleapis.com/tasks/v1/lists/MDM4MzQ4NTA3NDQwMDUxMzQ2OTQ6NzAwOTA4MDA1NzU2ODYwMzow/tasks/MDM4MzQ4NTA3NDQwMDUxMzQ2OTQ6NzAwOTA4MDA1NzU2ODYwMzoxMTg0MzQxMTkzMjM2MDY1",
*    "position": "00000000002147483647",
*    "notes": "Don't forget to buy apples.",
*    "status": "needsAction",
*    "due": "2019-04-07T00:00:00.000Z"
*   }
*  ]
* }
* 
* response status code: 200

RELEASE loFac
RELEASE loHttp
RELEASE loJson