Visual FoxPro

Get all Tasks on a List

See more Google Tasks Examples

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

LOCAL lnSuccess
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

lnSuccess = 0

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

loFac = CreateObject('Chilkat.FileAccess')
lcAccessToken = loFac.ReadEntireTextFile("qa_data/tokens/googleTasks.txt","utf-8")
IF (loFac.LastMethodSuccess = 0) THEN
    ? loFac.LastErrorText
    RELEASE loFac
    CANCEL
ENDIF

loHttp = CreateObject('Chilkat.Http')

loHttp.AuthToken = lcAccessToken

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

loResp = CreateObject('Chilkat.HttpResponse')
lnSuccess = loHttp.HttpNoBody("GET","https://www.googleapis.com/tasks/v1/lists/{$tasklist}/tasks",loResp)
IF (lnSuccess = 0) THEN
    ? loHttp.LastErrorText
    RELEASE loFac
    RELEASE loHttp
    RELEASE loResp
    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

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

*  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 loResp
RELEASE loJson