Excel Google Calendar: Get Calendar

Back to Index

Returns an entry on the user's calendar list.
This example gets the calendar having the ID = "support@chilkatcloud.com".

Documentation: https://developers.google.com/google-apps/calendar/v3/reference/calendarList/get

Dim rest As Chilkat.Rest
Set rest = Chilkat.NewRest

'   Provide a previously obtained OAuth2 access token.
Dim oauth2 As Chilkat.OAuth2
Set oauth2 = Chilkat.NewOAuth2
oauth2.AccessToken = "OAUTH2_ACCESS_TOKEN"
success = rest.SetAuthOAuth2(oauth2)

success = rest.Connect("www.googleapis.com",443,True,True)
If (success <> True) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If

Dim sbJson As Chilkat.StringBuilder
Set sbJson = Chilkat.NewStringBuilder
success = rest.FullRequestNoBodySb("GET","/calendar/v3/users/me/calendarList/support@chilkatcloud.com",sbJson)
If (success <> True) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If

If (rest.ResponseStatusCode <> 200) Then
    Debug.Print "Received error response code: "; rest.ResponseStatusCode
    Debug.Print "Response body:"
    Debug.Print sbJson.GetAsString()
    Exit Sub
End If

Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
success = json.LoadSb(sbJson)

'  The following code parses the JSON response.
'  A sample JSON response is shown below the sample code.

kind = json.StringOf("kind")
etag = json.StringOf("etag")
id = json.StringOf("id")
summary = json.StringOf("summary")
timeZone = json.StringOf("timeZone")
colorId = json.StringOf("colorId")
backgroundColor = json.StringOf("backgroundColor")
foregroundColor = json.StringOf("foregroundColor")
selected = json.BoolOf("selected")
accessRole = json.StringOf("accessRole")
primary = json.BoolOf("primary")
i = 0
count_i = json.SizeOfArray("defaultReminders")
Do While i < count_i
    json.I = i
    method = json.StringOf("defaultReminders[i].method")
    minutes = json.IntOf("defaultReminders[i].minutes")
    i = i + 1
Loop
i = 0
count_i = json.SizeOfArray("notificationSettings.notifications")
Do While i < count_i
    json.I = i
    type = json.StringOf("notificationSettings.notifications[i].type")
    method = json.StringOf("notificationSettings.notifications[i].method")
    i = i + 1
Loop

Debug.Print "Example Completed."

Sample JSON Response Body

{
  "kind": "calendar#calendarListEntry",
  "etag": "\"1465249947472000\"",
  "id": "support@chilkatcloud.com",
  "summary": "support@chilkatcloud.com",
  "timeZone": "America/Chicago",
  "colorId": "14",
  "backgroundColor": "#9fe1e7",
  "foregroundColor": "#000000",
  "selected": true,
  "accessRole": "owner",
  "defaultReminders": [
    {
      "method": "popup",
      "minutes": 10
    }
  ],
  "notificationSettings": {
    "notifications": [
      {
        "type": "eventCreation",
        "method": "email"
      },
      {
        "type": "eventChange",
        "method": "email"
      },
      {
        "type": "eventCancellation",
        "method": "email"
      },
      {
        "type": "eventResponse",
        "method": "email"
      }
    ]
  },
  "primary": true
}