Lianja

List Events on a Specified Google Calendar

See more Google Calendar Examples

Demonstrates how to fetch the list of events on a particular Google Calendar. The calendar can be referenced by the calendar ID, or by the keyword "primary". Lianja

llSuccess = .F.

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

// This example uses a previously obtained access token having permission for the 
// Google Calendar scope.

// In this example, Get Google Calendar OAuth2 Access Token, the access
// token was saved to a JSON file.  This example fetches the access token from the file..
loJsonToken = createobject("CkJsonObject")
llSuccess = loJsonToken.LoadFile("qa_data/tokens/googleCalendar.json")
if (loJsonToken.HasMember("access_token") = .F.) then
    ? "No access token found."
    release loJsonToken
    return
endif

loHttp = createobject("CkHttp")
loHttp.AuthToken = loJsonToken.StringOf("access_token")

// Let's get the primary calendar.  A calendar ID could have be used instead of "primary".
loHttp.SetUrlVar("calendarId","primary")
loSbResponse = createobject("CkStringBuilder")
llSuccess = loHttp.QuickGetSb("https://www.googleapis.com/calendar/v3/calendars/{$calendarId}/events",loSbResponse)
if (llSuccess <> .T.) then
    ? loHttp.LastErrorText
    release loJsonToken
    release loHttp
    release loSbResponse
    return
endif

if (loHttp.LastStatus <> 200) then
    // Note: If a 401 unauthorized response is received, it likely means that the OAuth2 access token needs
    // to be refreshed or re-fetched.
    ? "Error response status: " + str(loHttp.LastStatus)
    ? loSbResponse.GetAsString()
    release loJsonToken
    release loHttp
    release loSbResponse
    return
endif

// A sample JSON response:
// (Code for parsing the Google Calendar events is shown below.)

// {
//  "kind": "calendar#events",
//  "etag": "\"p32cfpufit76da0g\"",
//  "summary": "support@chilkatcloud.com",
//  "updated": "2017-08-10T14:00:27.199Z",
//  "timeZone": "America/Chicago",
//  "accessRole": "owner",
//  "defaultReminders": [
//   {
//    "method": "popup",
//    "minutes": 10
//   }
//  ],
//  "nextSyncToken": "CJj8-fLpzNUCEJj8-fLpzNUCGAU=",
//  "items": [
//   {
//    "kind": "calendar#event",
//    "etag": "\"3004746854620000\"",
//    "id": "5jt9fopfg3rr9eftegiuq7gc5k",
//    "status": "confirmed",
//    "htmlLink": "https://www.google.com/calendar/event?eid=NWp0OWZvcGZnM3JyOWVmdGVnaXVxN2djNWsgc3VwcG9ydEBjaGlsa2F0Y2xvdWQuY29t",
//    "created": "2017-08-10T13:57:07.000Z",
//    "updated": "2017-08-10T13:57:07.310Z",
//    "summary": "Run 10 miles",
//    "creator": {
//     "email": "support@chilkatcloud.com",
//     "self": true
//    },
//    "organizer": {
//     "email": "support@chilkatcloud.com",
//     "self": true
//    },
//    "start": {
//     "dateTime": "2017-08-10T12:00:00-05:00"
//    },
//    "end": {
//     "dateTime": "2017-08-10T13:00:00-05:00"
//    },
//    "iCalUID": "5jt9fopfg3rr9eftegiuq7gc5k@google.com",
//    "sequence": 0,
//    "hangoutLink": "https://plus.google.com/hangouts/_/chilkatcloud.com/support?hceid=c3VwcG9ydEBjaGlsa2F0Y2xvdWQuY29t.5jt9fopfg3rr9eftegiuq7gc5k",
//    "reminders": {
//     "useDefault": true
//    }
//   },
//   {
//    "kind": "calendar#event",
//    "etag": "\"3004746898118000\"",
//    "id": "7dvh49vd219r3sq7jdueieu8rc",
//    "status": "confirmed",
//    "htmlLink": "https://www.google.com/calendar/event?eid=N2R2aDQ5dmQyMTlyM3NxN2pkdWVpZXU4cmMgc3VwcG9ydEBjaGlsa2F0Y2xvdWQuY29t",
//    "created": "2017-08-10T13:57:29.000Z",
//    "updated": "2017-08-10T13:57:29.059Z",
//    "summary": "Eat Giordano's Pizza",
//    "creator": {
//     "email": "support@chilkatcloud.com",
//     "self": true
//    },
//    "organizer": {
//     "email": "support@chilkatcloud.com",
//     "self": true
//    },
//    "start": {
//     "dateTime": "2017-08-10T15:00:00-05:00"
//    },
//    "end": {
//     "dateTime": "2017-08-10T16:00:00-05:00"
//    },
//    "iCalUID": "7dvh49vd219r3sq7jdueieu8rc@google.com",
//    "sequence": 0,
//    "hangoutLink": "https://plus.google.com/hangouts/_/chilkatcloud.com/support?hceid=c3VwcG9ydEBjaGlsa2F0Y2xvdWQuY29t.7dvh49vd219r3sq7jdueieu8rc",
//    "reminders": {
//     "useDefault": true
//    }
//   },
//   {
//    "kind": "calendar#event",
//    "etag": "\"3004746915224000\"",
//    "id": "5btd89ljn07bg3tlgpimcaqrro",
//    "status": "confirmed",
//    "htmlLink": "https://www.google.com/calendar/event?eid=NWJ0ZDg5bGpuMDdiZzN0bGdwaW1jYXFycm8gc3VwcG9ydEBjaGlsa2F0Y2xvdWQuY29t",
//    "created": "2017-08-10T13:57:37.000Z",
//    "updated": "2017-08-10T13:57:37.612Z",
//    "summary": "Nap",
//    "creator": {
//     "email": "support@chilkatcloud.com",
//     "self": true
//    },
//    "organizer": {
//     "email": "support@chilkatcloud.com",
//     "self": true
//    },
//    "start": {
//     "dateTime": "2017-08-10T16:30:00-05:00"
//    },
//    "end": {
//     "dateTime": "2017-08-10T17:30:00-05:00"
//    },
//    "iCalUID": "5btd89ljn07bg3tlgpimcaqrro@google.com",
//    "sequence": 0,
//    "hangoutLink": "https://plus.google.com/hangouts/_/chilkatcloud.com/support?hceid=c3VwcG9ydEBjaGlsa2F0Y2xvdWQuY29t.5btd89ljn07bg3tlgpimcaqrro",
//    "reminders": {
//     "useDefault": true
//    }
//   }
//  ]
// }
// 

loJson = createobject("CkJsonObject")
loJson.LoadSb(loSbResponse)

lnNumEvents = loJson.SizeOfArray("items")
i = 0
do while i < lnNumEvents
    loJson.I = i
    ? loJson.StringOf("items[i].summary")
    ? loJson.StringOf("items[i].start.dateTime")
    ? loJson.StringOf("items[i].end.dateTime")
    ? "--"
    i = i + 1
enddo

// Sample output:

// Run 10 miles
// 2017-08-10T12:00:00-05:00
// 2017-08-10T13:00:00-05:00
// --
// Eat Giordano's Pizza
// 2017-08-10T15:00:00-05:00
// 2017-08-10T16:00:00-05:00
// --
// Nap
// 2017-08-10T16:30:00-05:00
// 2017-08-10T17:30:00-05:00
// --
// 


release loJsonToken
release loHttp
release loSbResponse
release loJson