PowerBuilder

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". PowerBuilder

integer li_rc
integer li_Success
oleobject loo_JsonToken
oleobject loo_Http
oleobject loo_SbResponse
oleobject loo_Json
integer li_NumEvents
integer i

li_Success = 0

// 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..
loo_JsonToken = create oleobject
li_rc = loo_JsonToken.ConnectToNewObject("Chilkat.JsonObject")
if li_rc < 0 then
    destroy loo_JsonToken
    MessageBox("Error","Connecting to COM object failed")
    return
end if
li_Success = loo_JsonToken.LoadFile("qa_data/tokens/googleCalendar.json")
if loo_JsonToken.HasMember("access_token") = 0 then
    Write-Debug "No access token found."
    destroy loo_JsonToken
    return
end if

loo_Http = create oleobject
li_rc = loo_Http.ConnectToNewObject("Chilkat.Http")

loo_Http.AuthToken = loo_JsonToken.StringOf("access_token")

// Let's get the primary calendar.  A calendar ID could have be used instead of "primary".
loo_Http.SetUrlVar("calendarId","primary")
loo_SbResponse = create oleobject
li_rc = loo_SbResponse.ConnectToNewObject("Chilkat.StringBuilder")

li_Success = loo_Http.QuickGetSb("https://www.googleapis.com/calendar/v3/calendars/{$calendarId}/events",loo_SbResponse)
if li_Success <> 1 then
    Write-Debug loo_Http.LastErrorText
    destroy loo_JsonToken
    destroy loo_Http
    destroy loo_SbResponse
    return
end if

if loo_Http.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.
    Write-Debug "Error response status: " + string(loo_Http.LastStatus)
    Write-Debug loo_SbResponse.GetAsString()
    destroy loo_JsonToken
    destroy loo_Http
    destroy loo_SbResponse
    return
end if

// 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
//    }
//   }
//  ]
// }
// 

loo_Json = create oleobject
li_rc = loo_Json.ConnectToNewObject("Chilkat.JsonObject")

loo_Json.LoadSb(loo_SbResponse)

li_NumEvents = loo_Json.SizeOfArray("items")
i = 0
do while i < li_NumEvents
    loo_Json.I = i
    Write-Debug loo_Json.StringOf("items[i].summary")
    Write-Debug loo_Json.StringOf("items[i].start.dateTime")
    Write-Debug loo_Json.StringOf("items[i].end.dateTime")
    Write-Debug "--"
    i = i + 1
loop

// 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
// --
// 


destroy loo_JsonToken
destroy loo_Http
destroy loo_SbResponse
destroy loo_Json