Reference

Endpoint Past Meeting

Name

list_past_meeting_registrants

Description

Use this API to get information about a past meeting. [API reference]

Related Tables

PastMeetingRegistrants

Parameters

Parameter Required Options
Name: MeetingId

Label: MeetingId

The Meeting 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_I8 bigint
host_id DT_WSTR nvarchar(100) 100
type DT_I8 bigint
topic DT_WSTR nvarchar(500) 500
user_name DT_WSTR nvarchar(255) 255
user_email DT_WSTR nvarchar(255) 255
start_time DT_DBTIMESTAMP datetime
end_time DT_DBTIMESTAMP datetime
duration DT_I8 bigint
total_minutes DT_I8 bigint
participants_count DT_I8 bigint
dept DT_WSTR nvarchar(8) 8
source DT_WSTR nvarchar(16) 16
uuid DT_WSTR nvarchar(100) 100
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 PastMeetingRegistrants 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
PastMeetingRegistrants
Required Parameters
MeetingId Fill-in the parameter...
SSIS API Source - Read from table or endpoint

API Destination

This Endpoint belongs to the PastMeetingRegistrants table, therefore it is better to use it, instead of accessing the endpoint directly. Use this table and table-operation pair to past meeting:

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

ODBC application

Use these SQL queries in your ODBC application data source:

Read past meeting registrants

<p>Reads registrants from a past meeting. This allows you to retrieve attendance information for meetings that have already concluded.</p> <p>Query the <code>PastMeetingRegistrants</code> table with the <code>MeetingId</code> of the completed session.</p> 

SELECT * FROM PastMeetingRegistrants
WITH(
  MeetingId='123456'
)

list_past_meeting_registrants endpoint belongs to PastMeetingRegistrants 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 past meeting registrants

<p>Reads registrants from a past meeting. This allows you to retrieve attendance information for meetings that have already concluded.</p> <p>Query the <code>PastMeetingRegistrants</code> table with the <code>MeetingId</code> of the completed session.</p> 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM PastMeetingRegistrants
WITH(
  MeetingId=''123456''
)';

EXEC (@MyQuery) AT [LS_TO_ZOOM_IN_GATEWAY];

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