Hey @baitha!
I can’t speak for @tommy (he may know about some existing source code which I do not), but I’ve not heard of any available source code for piping data from: Zoom->Snowflake->Tableau (specifically).
The Zoom API is RESTful, and Python has native libraries and published modules available on [pip](https://pypi.org/project/pip/)
, such as requests, you can include as dependencies as part of your Python app, enabling your code interoperability with Zoom REST API. Using this, your app can:
- Obtain historical data about your Zoom account, within limits defined by Zoom’s Data Retention, Privacy, and other legal Policies.
- To retrieve additional object details, not exposed in the webhook event payload, where only IDs are provided in the event but your app requires more comprehensive data
Zoom Webhooks are encrypted HTTP POST requests sent to the Event Subscription URL you define for your Zoom Marketplace App -> Features -> Event Subscription (development/production). You just have to make available (either as part of your Python app, or SOA-style independent) publicly available web-server that supports TLSv1.2+ and can accept incoming HTTP POST requests (making sure to respond with an HTTP 200 when successfully received, in an async manner). Using this, your app can:
- Subscribe to a robust/growing, near-real-time Zoom events as they occur in your account
- Create dashboards from the data, or securely send to a dashboard service provider
- Eliminate your app’s need to long-poll Zoom’s REST API
- Conserve valuable API Rate Limit overhead for more critical needs
For your specific automation workflow @baitha
Using a combination of Zoom Webhooks and Zoom REST API, your Python app could:
- Subscribe to desired Zoom Events (Webhooks) in your Marketplace app
- Handle received events at your Zoom Marketplace app’s
Event Subscription URL
, then relay into Snowflake Data Lifecycle, making sure to ETL JSON Data into Snowflake
- Establish a secure connection between Tableau and Snowflake
- Build/customize/share your Tableau dashboards!
For a more drag-n-drop type automation…
Of course, there are some service providers available, such as Zapier, you can use to automate this workflow, and the list of service-automation providers is continually growing. Using these services, the trade off for reduced development time and off-loading of maintenance/support, is the cost of your usage of the service.
Zoom Policy for 3rd Party Providers
We only recommend using official, approved third party service providers, these apps have been reviewed and published by Zoom on:
!! Protect your Zoom Data !!
NEVER share or store your Zoom JWT App’s API Keys with ANY third-party!
The only exception would be Zoom Marketplace apps that are marked as “Built by: Zoom”.
Does this answer your question (I know it isn’t a turn-key solution, but this should point you in the right direction)?