VBScript

Outlook Calendar List Events

See more Outlook Calendar Examples

Retrieve a list of events in a calendar. VBScript

Dim fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
'Create a Unicode (utf-16) output text file.
Set outFile = fso.CreateTextFile("output.txt", True, True)

success = 0

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

set http = CreateObject("Chilkat.Http")

' Use your previously obtained access token here: Get Outlook Calendar OAuth2 Access Token (Azure AD v2.0 Endpoint).

set jsonToken = CreateObject("Chilkat.JsonObject")
success = jsonToken.LoadFile("qa_data/tokens/outlookCalendar.json")
If (success = 0) Then
    outFile.WriteLine(jsonToken.LastErrorText)
    WScript.Quit
End If

http.AuthToken = jsonToken.StringOf("access_token")

' Specify the ID of the calendar to list.
calendarId = "AQMkADAwATM0MDAAMS1iNTcwLWI2NTEtMDACLTAwCgBGAAADsVyfxjDU406Ic4X7ill8xAcA5_vF7TKKdE6bGCRqXyl2PQAAAgEGAAAA5_vF7TKKdE6bGCRqXyl2PQAAAiCsAAAA"

success = http.SetUrlVar("id",calendarId)

' To list the events in the default calendar, use the following URL: https://graph.microsoft.com/v1.0/me/calendars/events

set resp = CreateObject("Chilkat.HttpResponse")
success = http.HttpNoBody("GET","https://graph.microsoft.com/v1.0/me/calendars/{$id}/events",resp)
If (success = 0) Then
    outFile.WriteLine(http.LastErrorText)
    WScript.Quit
End If

outFile.WriteLine("Response status code = " & resp.StatusCode)

' The HTTP request succeeded if the response status code = 200.
If (resp.StatusCode <> 200) Then
    outFile.WriteLine(resp.BodyStr)
    outFile.WriteLine("Failed")
    WScript.Quit
End If

set json = CreateObject("Chilkat.JsonObject")
success = json.Load(resp.BodyStr)
json.EmitCompact = 0
outFile.WriteLine(json.Emit())

' Here is a sample response:

' Use this online tool to generate parsing code from sample JSON: 
' Generate Parsing Code from JSON

' {
'   "value": [
'     {
'       "originalStartTimeZone": "originalStartTimeZone-value",
'       "originalEndTimeZone": "originalEndTimeZone-value",
'       "responseStatus": {
'         "response": "",
'         "time": "datetime-value"
'       },
'       "iCalUId": "iCalUId-value",
'       "reminderMinutesBeforeStart": 99,
'       "isReminderOn": true
'     }
'   ]
' }

i = 0
count_i = json.SizeOfArray("value")
Do While i < count_i
    json.I = i
    originalStartTimeZone = json.StringOf("value[i].originalStartTimeZone")
    originalEndTimeZone = json.StringOf("value[i].originalEndTimeZone")
    responseStatusResponse = json.StringOf("value[i].responseStatus.response")
    responseStatusTime = json.StringOf("value[i].responseStatus.time")
    iCalUId = json.StringOf("value[i].iCalUId")
    reminderMinutesBeforeStart = json.IntOf("value[i].reminderMinutesBeforeStart")
    isReminderOn = json.BoolOf("value[i].isReminderOn")
    i = i + 1
Loop

outFile.Close