Zoom Connector
Documentation
Version: 1
Documentation
Endpoint

List Meeting Registrants


Name

list_meeting_registrants

Description

A host or a user with admin permission can require registration for a Zoom meeting. Use this API to list users that have registered for a meeting. [API reference]

Related Tables

MeetingRegistrants

Parameters

Parameter Label Required Options Description
UserId UserId YES Only Used to list Meetings in the UI
MeetingId MeetingId YES The Meeting ID for which you want to get details.
page_size PageSize NO

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
id DT_WSTR nvarchar(255) 255 False
first_name DT_WSTR nvarchar(255) 255 False
last_name DT_WSTR nvarchar(255) 255 False
email DT_WSTR nvarchar(255) 255 False
address DT_WSTR nvarchar(255) 255 False
city DT_WSTR nvarchar(100) 100 False
country DT_WSTR nvarchar(100) 100 False
zip DT_WSTR nvarchar(100) 100 False
state DT_WSTR nvarchar(100) 100 False
phone DT_WSTR nvarchar(100) 100 False
industry DT_WSTR nvarchar(100) 100 False
org DT_WSTR nvarchar(255) 255 False
job_title DT_WSTR nvarchar(255) 255 False
purchasing_time_frame DT_WSTR nvarchar(255) 255 False
role_in_purchase_process DT_WSTR nvarchar(255) 255 False
no_of_employees DT_WSTR nvarchar(255) 255 False
comments DT_WSTR nvarchar(4000) 4000 False
custom_questions DT_NTEXT nvarchar(MAX) False
status DT_WSTR nvarchar(100) 100 False
create_time DT_DBTIMESTAMP datetime False
join_url DT_WSTR nvarchar(2000) 2000 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 MeetingRegistrants table using API Destination

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

Zoom
MeetingRegistrants
Select
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

List meeting registrants

SELECT * FROM list_meeting_registrants
WHERE id = 'me'
AND id = 'abcd-1234-meetingid'

List Meeting Registrants

Select a meeting registants for the specific meeting id

SELECT * FROM MeetingRegistrants
WITH(
  MeetingId='1234'
)
--You can get MeetingId by selecting from 'list_meetings' endpoint and also this value available as dropdown value for MeetingId parameter.

list_meeting_registrants endpoint belongs to MeetingRegistrants 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 meeting registrants

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM list_meeting_registrants
WHERE id = ''me''
AND id = ''abcd-1234-meetingid''';

EXEC (@MyQuery) AT [LS_TO_ZOOM_IN_GATEWAY];

List Meeting Registrants

Select a meeting registants for the specific meeting id

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM MeetingRegistrants
WITH(
  MeetingId=''1234''
)
--You can get MeetingId by selecting from ''list_meetings'' endpoint and also this value available as dropdown value for MeetingId parameter.';

EXEC (@MyQuery) AT [LS_TO_ZOOM_IN_GATEWAY];

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