ODBC guide

List events

This example lists events from a specified calendar. Supply the calendar ID to target a calendar; for a single event you can filter by event ID in the WHERE clause or use the EventId parameter.

Tip: Combine with time range parameters (StartTime, EndTime) for filtered results.

SELECT * FROM Events
WITH (CalendarId='MyCalendarId')  -- Specify the calendar ID to list events from

--Get single event by Id
--SELECT * FROM Events WHERE Id='MyEventId'  -- Filter by event ID in WHERE clause
--SELECT * FROM Events WITH(EventId='MyEventId')  -- Use EventId parameter for direct lookup