Reference

Endpoint List Webinar Registrants

Name

list_webinar_registrants

Description

Use this API to list all the users that have registered for a webinar. [API reference]

Related Tables

WebinarRegistrants

Parameters

Parameter Required Options
Name: WebinarId

Label: WebinarId

The Webinar ID for which you want to get details. 		YES
Name: page_size

Label: PageSize

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
id DT_WSTR nvarchar(255) 255
first_name DT_WSTR nvarchar(255) 255
last_name DT_WSTR nvarchar(255) 255
email DT_WSTR nvarchar(255) 255
address DT_WSTR nvarchar(255) 255
city DT_WSTR nvarchar(100) 100
country DT_WSTR nvarchar(100) 100
zip DT_WSTR nvarchar(100) 100
state DT_WSTR nvarchar(100) 100
phone DT_WSTR nvarchar(100) 100
industry DT_WSTR nvarchar(100) 100
org DT_WSTR nvarchar(255) 255
job_title DT_WSTR nvarchar(255) 255
purchasing_time_frame DT_WSTR nvarchar(255) 255
role_in_purchase_process DT_WSTR nvarchar(255) 255
no_of_employees DT_WSTR nvarchar(255) 255
comments DT_WSTR nvarchar(4000) 4000
custom_questions DT_NTEXT nvarchar(MAX)
status DT_WSTR nvarchar(100) 100
create_time DT_DBTIMESTAMP datetime
join_url DT_WSTR nvarchar(2000) 2000
If the column you are looking for is missing, consider customizing Zoom Connector.

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length 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 or in API Destination SSIS Data Flow components to read or write data.

API Source

This Endpoint belongs to the WebinarRegistrants table, therefore it is better to use it, instead of accessing the endpoint directly:

API Source - Zoom
Read and write Zoom data effortlessly. Integrate, manage, and automate meetings, users, accounts, and invitations — almost no coding required.
Zoom
WebinarRegistrants
Required Parameters
WebinarId Fill-in the parameter...
SSIS API Source - Read from table or endpoint

API Destination

This Endpoint belongs to the WebinarRegistrants table, therefore it is better to use it, instead of accessing the endpoint directly. Use this table and table-operation pair to list webinar registrants:

API Destination - Zoom
Read and write Zoom data effortlessly. Integrate, manage, and automate meetings, users, accounts, and invitations — almost no coding required.
Zoom
WebinarRegistrants
Select
Required Parameters
WebinarId Fill-in the parameter...
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Read webinar registrants

<p>Reads the list of people registered for a specific webinar. This includes their contact details and answers to any registration questions.</p> <p>Query the <code>WebinarRegistrants</code> table using the <code>WebinarId</code>.</p> 

SELECT * FROM WebinarRegistrants
WITH(
  WebinarId='123456'
)

list_webinar_registrants endpoint belongs to WebinarRegistrants 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:

Read webinar registrants

<p>Reads the list of people registered for a specific webinar. This includes their contact details and answers to any registration questions.</p> <p>Query the <code>WebinarRegistrants</code> table using the <code>WebinarId</code>.</p> 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM WebinarRegistrants
WITH(
  WebinarId=''123456''
)';

EXEC (@MyQuery) AT [LS_TO_ZOOM_IN_GATEWAY];

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