Table Webinars
Description
No description available
Supported Operations
Below section contains supported CRUD operations. Each operation is executed by some EndPoint behind the scene.| Method | Supported | Reference EndPoint |
|---|---|---|
| SELECT | list_webinars | |
| INSERT | ||
| UPDATE | ||
| UPSERT | ||
| DELETE | ||
| LOOKUP | get_webinar |
Examples
SSIS
Use Zoom Connector in API Source component to read data or in API Destination component to read/write data:
Read from Webinars table using API Source
| Required Parameters | |
|---|---|
| UserId | Fill-in the parameter... |
Read/write to Webinars table using API Destination
| Required Parameters | |
|---|---|
| UserId | Fill-in the parameter... |
ODBC application
Use these SQL queries in your ODBC application data source:
Read webinars
<p>Reads all webinars scheduled by a user. Webinars are distinct from meetings and typically involve a host broadcasting to a larger audience.</p> <p>The <code>Webinars</code> table lists these events. Use <code>UserId='me'</code> or specify another user's ID.</p>
SELECT * FROM Webinars
WITH(
UserId='me' -- enter user id or email
)
Read webinar by ID
<p>Reads detailed configuration for a specific webinar. Use this to retrieve settings like approval type, audio options, and alternative hosts.</p> <p>Use the <code>WHERE id=...</code> clause on the <code>Webinars</code> table to locate a specific webinar record.</p>
SELECT * FROM Webinars WHERE id=1234
SQL Server
Use these SQL queries in SQL Server after you create a data source in Data Gateway:
Read webinars
<p>Reads all webinars scheduled by a user. Webinars are distinct from meetings and typically involve a host broadcasting to a larger audience.</p> <p>The <code>Webinars</code> table lists these events. Use <code>UserId='me'</code> or specify another user's ID.</p>
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Webinars
WITH(
UserId=''me'' -- enter user id or email
)';
EXEC (@MyQuery) AT [LS_TO_ZOOM_IN_GATEWAY];
Read webinar by ID
<p>Reads detailed configuration for a specific webinar. Use this to retrieve settings like approval type, audio options, and alternative hosts.</p> <p>Use the <code>WHERE id=...</code> clause on the <code>Webinars</code> table to locate a specific webinar record.</p>
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Webinars WHERE id=1234';
EXEC (@MyQuery) AT [LS_TO_ZOOM_IN_GATEWAY];