Endpoint

List Webinars

Name

list_webinars

Description

Use this API to list all the webinars scheduled by or on-behalf a user (webinar host). For user-level apps, pass the me value instead of the userId parameter. [API reference]

Related Tables

Webinars

Parameters

Parameter	Label	Required	Options	Description
UserId	UserId	YES		The user ID or email address of the user. For user-level apps, pass the me value.
page_size	PageSize	NO

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
id	`DT_I8`	`bigint`		`False`
host_id	`DT_WSTR`	`nvarchar(255)`	255	`False`
topic	`DT_WSTR`	`nvarchar(500)`	500	`False`
type	`DT_I8`	`bigint`		`False`
start_time	`DT_DBTIMESTAMP`	`datetime`		`False`
duration	`DT_I8`	`bigint`		`False`
timezone	`DT_WSTR`	`nvarchar(100)`	100	`False`
created_at	`DT_DBTIMESTAMP`	`datetime`		`False`
join_url	`DT_WSTR`	`nvarchar(1000)`	1000	`False`
uuid	`DT_WSTR`	`nvarchar(100)`	100	`False`

If the column you are looking for is missing, consider customizing Zoom Connector.

Input Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw	Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.

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 Destination

This Endpoint belongs to Webinars table, therefore you cannot work with it directly. Use this table and table-operation pair instead:

Zoom

Webinars

Select

SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

List webinars

SELECT * FROM list_webinars
WHERE id = 'me'

List Webinars

Lists all available Webinars for a selected User with webinars access rights

SELECT *  FROM Webinars
				
				WITH(
					  UserId='test' -- enter user id or email
				)
				--You can get UserId by selecting from 'list_users' endpoint and also this value available as dropdown value for UserId parameter.

Get Webinar

Select a webinar from the list_webinars by providing webinar id

SELECT * FROM Webinars Where id=1234
				--You can get id by selecting from 'list_webinars' endpoint and also this value available as dropdown value for WebinarId parameter.

list_webinars endpoint belongs to Webinars table(s), and can therefore be used via those table(s).

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

List webinars

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM list_webinars
WHERE id = ''me''';

EXEC (@MyQuery) AT [LS_TO_ZOOM_IN_GATEWAY];

List Webinars

Lists all available Webinars for a selected User with webinars access rights

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT *  FROM Webinars
				
				WITH(
					  UserId=''test'' -- enter user id or email
				)
				--You can get UserId by selecting from ''list_users'' endpoint and also this value available as dropdown value for UserId parameter.';

EXEC (@MyQuery) AT [LS_TO_ZOOM_IN_GATEWAY];

Get Webinar

Select a webinar from the list_webinars by providing webinar id

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Webinars Where id=1234
				--You can get id by selecting from ''list_webinars'' endpoint and also this value available as dropdown value for WebinarId parameter.';

EXEC (@MyQuery) AT [LS_TO_ZOOM_IN_GATEWAY];

list_webinars endpoint belongs to Webinars table(s), and can therefore be used via those table(s).