List events from all calendars
This example lists events from all calendars accessible to the user. For OAuth, it uses the authenticated user's calendars. For service accounts, specify UserId to impersonate another user (requires domain-wide delegation).
Note: This may return a large dataset; use filters like StartTime to limit results.
SELECT * FROM EventsAll -- Lists events from all accessible calendars
--WITH (CalendarId='primary',
-- StartTime='<<today,FUN_TO_DATETIME>>-05:00',
-- EndTime='<<today+7d,FUN_TO_DATETIME>>-05:00')
--OR--
--SELECT * FROM EventsAll WITH(UserId='me') -- for OAuth authenticated user
--SELECT * FROM EventsAll WITH(UserId='someuser@email.com') -- for specific user (requires domain-wide delegation for service accounts)
--SELECT * FROM EventsAll WITH(ContinueOn404Error='False') -- Fail on 404 errors when accessing calendars