Google Calendar Data Connecter Help

Ask the Community
1

I’m attempting to ingest Google Calendar to Foundry using the built in Google Calendar Data Connection, and running into issues:

What I’ve done so far:

  • Created Google service account and enabled Google Calendar API, then shared calendars with service account using “See all event details” (read-only)

  • Configured the Foundry Google Calendar Data Connection using OAuth JWT, and setup network egress policies (googleapis.com:443)

  • Authentication succeeds (no auth / permission / network errors in logs)

  • Schemas load successfully in the source explorer

Issue:

  • I created a sync for the AllCalendars table (Snapshot)

  • The sync completes successfully, but the output dataset has 0 rows

  • Preview / Explore consistently errors with messages like:

    • At least CALENDARID or CALENDARID and PARENTEVENTID should be specified

    • INVALID_ARGUMENT (MagritteExplorer:SqlError)

I’m not sure if I missed something or if the connector is not the right way to do it or I need an intermediary. For context I have three calendars I shared to the service account.

My questions are:

  1. How do I get events to actually sync (should events show on AllCalender?)
  2. How do updates for events work (I chose snapshot since updates was unavailable)

image
image2763×1882 162 KB

2

image
image1920×1034 328 KB

Update: Was able to do it via REST API + Code Repositories, in hindsight the google calendar connector may have been intended for use as an external source to import into a repository, but I’m not sure + the REST connector works great

1 Like