Google Calendar Connector
Google Calendar Connector Help
Version 4
ZappySys Logo File Version: v4
Supported Engine: 4

Examples


On this page you will find some SQL examples which can be used for API ODBC Driver or Data Gateway API Connector.
Example Query
List calendars
SELECT * FROM Calendars
List events
SELECT * FROM Events
  WITH (CalendarId='MyCalendarId')
Get event
SELECT * FROM get_event
  WITH (CalendarId='MyCalendarId'
       ,EventId='MyEventId')
Create event
INSERT INTO Events(StartsAt, StartsInTimeZone, EndsAt, EndsInTimeZone, Summary,
  Attendees, Description, Location, Status, Transparency, Visibility)
  VALUES ('2021-11-26T16:30:50', 'Europe/Vilnius', '2021-11-27T16:30:50','Europe/Vilnius', 'This is an event',
          null, 'My Description', 'Vilnius', 'confirmed', 'opaque', 'default')
  WITH (CalendarId='YourCalendarId')
Get event
DELETE FROM Events
    WITH (CalendarId='MyCalendarId',
    EventId='MyEventId')
Move event to a different calendar
UPDATE move_event
  WITH (SourceCalendarId='MySourceCalendarId',
  TargetCalendarId='MyTargetCalendarId',
  EventId='MyEventId'
  )