Visual FoxPro

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. Visual FoxPro

LOCAL lnSuccess
LOCAL loJsonToken
LOCAL loHttp
LOCAL loSbUrl
LOCAL loReq
LOCAL loDt
LOCAL loSbResponse
LOCAL loJson
LOCAL lnNumEvents
LOCAL i

lnSuccess = 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..
loJsonToken = CreateObject('Chilkat.JsonObject')
lnSuccess = loJsonToken.LoadFile("qa_data/tokens/googleCalendar.json")
IF (loJsonToken.HasMember("access_token") = 0) THEN
    ? "No access token found."
    RELEASE loJsonToken
    CANCEL
ENDIF

loHttp = CreateObject('Chilkat.Http')
loHttp.AuthToken = loJsonToken.StringOf("access_token")

* We'll want to build a URL with the query params..
loSbUrl = CreateObject('Chilkat.StringBuilder')
loSbUrl.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..
loReq = CreateObject('Chilkat.HttpRequest')

* Find events with the word "pizza".
loReq.AddParam("q","pizza")

* Get events for the current date/time or later.
loDt = CreateObject('Chilkat.CkDateTime')
loDt.SetFromCurrentSystemTime()
loReq.AddParam("timeMin",loDt.GetAsTimestamp(0))

* Add these query params to the URL:
loSbUrl.Append(loReq.GetUrlEncodedParams())

* Examine the URL..
? "URL: " + loSbUrl.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".
loHttp.SetUrlVar("calendarId","primary")
loSbResponse = CreateObject('Chilkat.StringBuilder')
lnSuccess = loHttp.QuickGetSb(loSbUrl.GetAsString(),loSbResponse)
IF (lnSuccess <> 1) THEN
    ? loHttp.LastErrorText
    RELEASE loJsonToken
    RELEASE loHttp
    RELEASE loSbUrl
    RELEASE loReq
    RELEASE loDt
    RELEASE loSbResponse
    CANCEL
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 loSbUrl
    RELEASE loReq
    RELEASE loDt
    RELEASE loSbResponse
    CANCEL
ENDIF

? loSbResponse.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
*    }
*   }
*  ]
* }
* 
* 

loJson = CreateObject('Chilkat.JsonObject')
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:

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

RELEASE loJsonToken
RELEASE loHttp
RELEASE loSbUrl
RELEASE loReq
RELEASE loDt
RELEASE loSbResponse
RELEASE loJson