Zoom Connector
Documentation
Version: 1
Documentation
Endpoint

List Meetings


Name

list_meetings

Description

Get the list of scheduled meetings. For current user (me) or specified user Id. To get more details about a meeting you can call get_meeting EndPoint. [API reference]

Related Tables

Meetings

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 Description
id DT_I8 bigint 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
agenda DT_WSTR nvarchar(4000) 4000 False
created_at DT_DBTIMESTAMP datetime False
join_url DT_WSTR nvarchar(1000) 1000 False
pmi DT_WSTR nvarchar(100) 100 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 Meetings table using API Destination

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

Zoom
Meetings
Select
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

List meetings

SELECT * FROM list_meetings
WHERE id = 'me'

List Meetings

List all the meetings for a selected User

SELECT *  FROM Meetings 
WITH(
  UserId ='me' -- 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 Meeting

Select a meeting from the list_meetings by providing meeting id

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

list_meetings endpoint belongs to Meetings 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 meetings

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

EXEC (@MyQuery) AT [LS_TO_ZOOM_IN_GATEWAY];

List Meetings

List all the meetings for a selected User

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT *  FROM Meetings 
WITH(
  UserId =''me'' -- 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 Meeting

Select a meeting from the list_meetings by providing meeting id

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Meetings Where id=1234
--You can get id 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_meetings endpoint belongs to Meetings table(s), and can therefore be used via those table(s).