Calendly V2

Calendly ETL connector for data replication

Snapshot

Features	Details
Release Status	Released
Source API Version	V2
Table Selection	Yes
Column Selection	Yes
Edit Integration	Yes
Replication Type Selection	No
Authentication Parameters	Calendly Access Token
Replication Type	Full Load
Replication Key	NA
Suggested Replication Frequency	24 hours

Tables/APIs supported

Scheduled Events	Event Invitees
Event Types	Organization Memberships
Organization Invitations

Integrate Calendly with Daton

1. Sign in to Daton

2. Select Calendly from Integrations page

3. Provide Integration Name, Replication Frequency and History. Integration name would be used in creating tables for the integration and cannot be changed later

4. Provide the Calendly access token. Follow this link to generate access token

5. Post successful authentication you will be prompted to choose from the list of available tables

6. Then select all required fields for each table

7. Submit the integration

Workflow

1. Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse

2. Users would be able to edit/pause/re-activate/delete integration anytime

3. Users can view job status and process logs from the integration details page by clicking on the integration name from the active list

Calendly Data

Scheduled Events

Purpose: This returns a list of all scheduled events of the organization

Source API Documentation: https://developer.calendly.com/api-docs/2d5ed9bbd2952-list-events

Replication: Full Replication

Replication Key: NA

Fields

Name	Data Type
uri	STRING
name	STRING
status	STRING
start_time	TIMESTAMP
end_time	TIMESTAMP
event_type	STRING
location	RECORD
invitees_counter	RECORD
created_at	TIMESTAMP
updated_at	TIMESTAMP
event_memberships	RECORD
event_guests	RECORD
cancellation	RECORD
calendar_event	RECORD

Event Invitees

Purpose: This returns a list of invitees of the scheduled events of the organization

Source API Documentation: https://developer.calendly.com/api-docs/eb8ee72701f99-list-event-invitees

Replication: Full Replication

Replication Key: NA

Fields

Name	Data Type
email	STRING
event	STRING
name	STRING
first_name	STRING
last_name	STRING
new_invitee	STRING
old_invitee	STRING
questions_and_answers	RECORD
cancel_url	STRING
reschedule_url	STRING
rescheduled	BOOLEAN
status	STRING
text_reminder_number	STRING
timezone	STRING
tracking	RECORD
created_at	TIMESTAMP
updated_at	TIMESTAMP
uri	STRING
canceled	BOOLEAN
routing_form_submission	STRING
cancellation	RECORD
payment	RECORD
no_show	RECORD
reconfirmation	RECORD

Event Types

Purpose: This returns all event types of the organization

Source API Documentation: https://developer.calendly.com/api-docs/25a4ece03c1bc-list-user-s-event-types

Replication: Full Replication

Replication Key: NA

Fields

Name	Data Type
uri	STRING
name	STRING
active	BOOLEAN
booking_method	STRING
slug	STRING
scheduling_url	STRING
duration	NUMERIC
kind	STRING
pooling_type	STRING
type	STRING
color	STRING
created_at	TIMESTAMP
updated_at	TIMESTAMP
internal_note	STRING
description_plain	STRING
description_html	STRING
profile	RECORD
secret	BOOLEAN
deleted_at	TIMESTAMP
custom_questions	RECORD

Organization Memberships

Purpose: This returns a list of the organization memberships for all users belonging to an organization

Source API Documentation: https://developer.calendly.com/api-docs/eaed2e61a6bc3-list-organization-memberships

Replication: Full Replication

Replication Key: NA

Fields

Name	Data Type
uri	STRING
role	STRING
user	RECORD
organization	STRING
created_at	TIMESTAMP
updated_at	TIMESTAMP

Organization Invitations

Purpose: This returns a list of organization invitations that were sent to the organization's members

Source API Documentation: https://developer.calendly.com/api-docs/3ad68ee2cc606-list-organization-invitations

Replication: Full Replication

Replication Key: NA

Fields

Name	Data Type
uri	STRING
organization	STRING
email	STRING
status	STRING
created_at	TIMESTAMP
updated_at	TIMESTAMP
last_sent_at	TIMESTAMP
user	STRING