(Visual Basic 6.0) Google Calendar Search Events (List Events with Optional Query Parameters)

See more Google Calendar Examples

Demonstrates how to specify optional query parameters for listing events. This example uses the "q" parameter to free-text search for events, and uses the "timeMin" parameter to specify a lower bound for an event's end time.

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

' 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..
Dim jsonToken As New ChilkatJsonObject
Dim success As Long
success = jsonToken.LoadFile("qa_data/tokens/googleCalendar.json")
If (jsonToken.HasMember("access_token") = 0) Then
    Debug.Print "No access token found."
    Exit Sub
End If

Dim http As New ChilkatHttp
http.AuthToken = jsonToken.StringOf("access_token")

' We'll want to build a URL with the query params..
Dim sbUrl As New ChilkatStringBuilder
success = sbUrl.Append("https://www.googleapis.com/calendar/v3/calendars/{$calendarId}/events?")

' Use the HTTP request object as a helper for creating the URL encoded query param list..
Dim req As New ChilkatHttpRequest

' Find events with the word "pizza".
req.AddParam "q","pizza"

' Get events for the current date/time or later.
Dim dt As New CkDateTime
success = dt.SetFromCurrentSystemTime()
req.AddParam "timeMin",dt.GetAsTimestamp(0)

' Add these query params to the URL:
success = sbUrl.Append(req.GetUrlEncodedParams())

' Examine the URL..
Debug.Print "URL: " & sbUrl.GetAsString()

' The URL looks like this:
' https://www.googleapis.com/calendar/v3/calendars/{$calendarId}/events?q=pizza&timeMin=2017-08-11T13%3A35%3A28Z

' Let's get events in the primary calendar.  A calendar ID could have be used instead of "primary".
success = http.SetUrlVar("calendarId","primary")
Dim sbResponse As New ChilkatStringBuilder
success = http.QuickGetSb(sbUrl.GetAsString(),sbResponse)
If (success <> 1) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

If (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.
    Debug.Print "Error response status: " & http.LastStatus
    Debug.Print sbResponse.GetAsString()
    Exit Sub
End If

Debug.Print sbResponse.GetAsString()

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

' {
'  "kind": "calendar#events",
'  "etag": "\"p32cafkumkb7ta0g\"",
'  "summary": "support@chilkatcloud.com",
'  "updated": "2017-08-11T13:19:48.143Z",
'  "timeZone": "America/Chicago",
'  "accessRole": "owner",
'  "defaultReminders": [
'   {
'    "method": "popup",
'    "minutes": 10
'   }
'  ],
'  "nextSyncToken": "CJin09aiz9UCEJin09aiz9UCGAU=",
'  "items": [
'   {
'    "kind": "calendar#event",
'    "etag": "\"3004915160212000\"",
'    "id": "02pv1cpdp7vm11htnfi3ii7iie",
'    "status": "confirmed",
'    "htmlLink": "https://www.google.com/calendar/event?eid=MDJwdjFjcGRwN3ZtMTFodG5maTNpaTdpaWUgc3VwcG9ydEBjaGlsa2F0Y2xvdWQuY29t",
'    "created": "2017-08-11T13:19:40.000Z",
'    "updated": "2017-08-11T13:19:40.106Z",
'    "summary": "Eat Lou Malnati's Pizza",
'    "creator": {
'     "email": "support@chilkatcloud.com",
'     "self": true
'    },
'    "organizer": {
'     "email": "support@chilkatcloud.com",
'     "self": true
'    },
'    "start": {
'     "dateTime": "2017-08-12T12:00:00-05:00"
'    },
'    "end": {
'     "dateTime": "2017-08-12T13:00:00-05:00"
'    },
'    "iCalUID": "02pv1cpdp7vm11htnfi3ii7iie@google.com",
'    "sequence": 0,
'    "hangoutLink": "https://plus.google.com/hangouts/_/chilkatcloud.com/support?hceid=c3VwcG9ydEBjaGlsa2F0Y2xvdWQuY29t.02pv1cpdp7vm11htnfi3ii7iie",
'    "reminders": {
'     "useDefault": true
'    }
'   }
'  ]
' }
' 
' 

Dim json As New ChilkatJsonObject
success = json.LoadSb(sbResponse)

Dim numEvents As Long
numEvents = json.SizeOfArray("items")
Dim i As Long
i = 0
Do While i < numEvents
    json.I = i
    Debug.Print json.StringOf("items[i].summary")
    Debug.Print json.StringOf("items[i].start.dateTime")
    Debug.Print json.StringOf("items[i].end.dateTime")
    Debug.Print "--"
    i = i + 1
Loop

' Sample output:

' Eat Lou Malnati's Pizza
' 2017-08-12T12:00:00-05:00
' 2017-08-12T13:00:00-05:00
' --