Sample code for 30+ languages & platforms
Visual Basic 6.0 Requires Chilkat v11.6.0+

Outlook Calendar: Check User and Resource Free/Busy Availability

See more Outlook Calendar Examples

For Microsoft 365 organizational accounts, query users or resource mailboxes for the next eight hours using 30-minute slots. Replace the sample SMTP addresses. Delegated personal Microsoft accounts are not supported by getSchedule. Calendar access and tenant policy determine the details returned; successful HTTP status does not mean every schedule succeeded.

Check each schedule's error before reading its availability. Keep availabilityView as text: 0 is free or working elsewhere, 1 tentative, 2 busy, and 3 out of office. A free slot does not reserve a room or guarantee that it will remain free. Check the current getSchedule limits before batching larger address lists or time ranges, and split overly dense results if the service reports too many entries.

Delegated permission: Calendars.ReadBasic.

This example loads the delegated Graph token from the existing calendar authorization example. Use a work/school mailbox. An authorized app-only service can instead target /users/{id}/calendar/getSchedule.

HTTP methods can return false for an HTTP error as well as a connection failure. The code distinguishes those cases and checks the expected status before reading JSON. For 401, refresh the access token or authorize again; for 403, check permissions, mailbox access, and tenant policy. For 429, honor Retry-After before a bounded retry. Do not automatically repeat a write after an uncertain outcome. Keep detailed errors and calendar data private.

Microsoft documentation

Chilkat Visual Basic 6.0 Downloads

Visual Basic 6.0
Dim success As Long
success = 0

'  Assumes Chilkat is unlocked. See Global Unlock Sample.
success = 0
'  Obtain a delegated Microsoft Graph token using the calendar authorization example.
'  See Authorize Outlook Calendar with OAuth2 and PKCE.
Dim token As New ChilkatJsonObject
token.Strict = 1
success = token.LoadFile("qa_data/tokens/outlookCalendar.json")
If (success <> 1) Then
    Debug.Print "Could not read the private calendar token cache."
    Exit Sub
End If

If ((token.JsonTypeOf("access_token") <> 1) Or (token.StringOfEquals("access_token","",1) = 1)) Then
    Debug.Print "Expected a nonempty access_token in the JSON."
    Exit Sub
End If

Dim http As New ChilkatHttp
http.AuthToken = token.StringOf("access_token")
http.RequireSslCertVerify = 1
http.FollowRedirects = 0
http.ConnectTimeout = 20
http.ReadTimeout = 30
http.SetRequestHeader "Accept","application/json"
Dim resp As New ChilkatHttpResponse
Dim result As New ChilkatJsonObject
result.Strict = 1
http.SetRequestHeader "Prefer","outlook.timezone=""UTC"", IdType=""ImmutableId"""
Dim body As New ChilkatJsonObject
success = body.UpdateString("schedules[0]","user@example.com")
success = body.UpdateString("schedules[1]","room@example.com")
success = body.UpdateInt("availabilityViewInterval",30)
Dim when As New CkDateTime
success = when.SetFromCurrentSystemTime()
If (success <> 1) Then
    Debug.Print "Could not get the window start."
    Exit Sub
End If

success = body.UpdateString("startTime.dateTime",when.GetAsIso8601("YYYY-MM-DDThh:mm:ss",0))
success = body.UpdateString("startTime.timeZone","UTC")
success = when.AddSeconds(28800)
If (success <> 1) Then
    Debug.Print "Could not set the eight-hour window."
    Exit Sub
End If

success = body.UpdateString("endTime.dateTime",when.GetAsIso8601("YYYY-MM-DDThh:mm:ss",0))
success = body.UpdateString("endTime.timeZone","UTC")
success = http.HttpJson("POST","https://graph.microsoft.com/v1.0/me/calendar/getSchedule",body,"application/json",resp)
'  A false result can still include an HTTP error response.
If ((success <> 1) And (resp.StatusCode = 0)) Then
    Debug.Print "No HTTP response was received. Inspect diagnostics privately; reconcile a write before retrying."
    Exit Sub
End If

If (resp.StatusCode <> 200) Then
    Debug.Print "Unexpected HTTP status: " & resp.StatusCode
    Debug.Print "Request ID: " & resp.GetHeaderField("request-id")
    If (resp.StatusCode = 429) Then
        Debug.Print "Retry-After: " & resp.GetHeaderField("Retry-After")
    End If

    If (resp.StatusCode = 401) Then
        Debug.Print "Refresh the Graph access token or authorize again."
    End If

    Exit Sub
End If

success = result.Load(resp.BodyStr)
If (success <> 1) Then
    Debug.Print "Expected a well-formed JSON response."
    Exit Sub
End If

If (result.JsonTypeOf("value") <> 4) Then
    Debug.Print "Expected schedule results."
    Exit Sub
End If

Dim i As Long
i = 0
Do While (i < result.SizeOfArray("value"))
    result.I = i
    Debug.Print "Schedule: " & result.StringOf("value[i].scheduleId")
    If (result.JsonTypeOf("value[i].error") = 3) Then
        Debug.Print "Schedule error: " & result.StringOf("value[i].error.responseCode")
    Else
        '  Keep the slot sequence as a string so leading zeroes are retained.
        Debug.Print "Availability: " & result.StringOf("value[i].availabilityView")
        Dim j As Long
        j = 0
        Do While (j < result.SizeOfArray("value[i].scheduleItems"))
            result.J = j
            Debug.Print "Status: " & result.StringOf("value[i].scheduleItems[j].status")
            Debug.Print "Start: " & result.StringOf("value[i].scheduleItems[j].start.dateTime")
            Debug.Print "End: " & result.StringOf("value[i].scheduleItems[j].end.dateTime")
            j = j + 1
        Loop
    End If

    i = i + 1
Loop