Calendly to BigQuery

The Calendly kit uses the Calendly API to connect, list all events of a specific organization and all users, and load the data into your data warehouse.

This Kit includes…

• Action river to connect to the Calendly “List Event” endpoint

• Action river to connect to the Calendly “List Organization Memberships” endpoint

• Source to Target river to load the Calendly event data into BigQuery

• Source to Target river to load the Calendly organization membership data into BigQuery

• Logic river to orchestrate and schedule the Calendly ingestion

Configuring this Kit for use

Before using this kit, you need to get your Calendly access token: https://developer.calendly.com/how-to-authenticate-with-personal-access-tokens

Environment Variables

In this Kit, there are 3 environment variables that are used to make for dynamic use of target configuration. 

• {calendly_dataset_id} is used in all Target configurations and queries as the target database id.

• {calendly_organization} is used in the 2 action rivers and allows to retrieve all events and users for this organization – it requires admin/owner privilege (ex: https://api.calendly.com/organizations/ARPDEEDZMDUSIWO1)

• {Calendly_Alert_Group} is used as the alert email address(es) for when a river fails (optional).

Go to the Variables menu on the left side navigation bar and create variables for calendly_dataset_id, and calendly_organization. Fill in the values for the BigQuery Database ID you'd like the data to land.

Connections

Kits are imported with ‘blank’ source and target connections. In order to use the template, you have two options:

• Swap out blank connections with existing connections

• Add credentials to the blank connections that come with the imported template.

This kit requires a connection with the key "token" and its value

Have questions about this Kit or want more endpoints?

Send an email to helpme@rivery.io with the title “Help – Calendly to BigQuery Kit”