How do I retrieve all invitees of my Calendly events?

[forums]

Using the new free SQL-driver for Calendly on Invantive Cloud it is easy to retrieve the invitees of events scheduled for the future or some time period.

This can easily be done using a query such as below for all events after 3 months ago:

select event_name
,      email
,      event_start_time
,      event_end_time
from   EventInvitees@cly
where  event_start_time >= add_months(trunc(sysdateutc), -3)

with results such as (after obfuscation):

This data can also be replicated into a database or ERP-system using a statement such as:

create or replace table TargetDataModel@InMemoryStorage
as
select event_name
,      email
,      event_start_time
,      event_end_time
from   EventInvitees@cly
where  event_start_time >= add_months(trunc(sysdateutc), -3)

synchronize TargetDataModel@InMemoryStorage
to          TargetTable@SqlServerOrAlike
identified
by          event_name
,           email
,           event_start_time