ZappySys Google Calendar Connector 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' )`