MeetingsByMeetingId |
Retrieve a meetingRetrieve a meeting's details
Catalog: Zoom
Schema: Meetings
This is a read-only table function. The Zoom API may not support changing the data or the Invantive SQL driver for Zoom does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Zoom API.
Select Zoom API URL: /meetings/{meetingId}
Insert Zoom API URL: /meetings/{meetingId}
Update Zoom API URL: /meetings/{meetingId}
Delete Zoom API URL: /meetings/{meetingId}
Field Selection Method: NotRequired
Select Zoom API Operation: get /meetings/{meetingId}
Parameters of Table Function
The following parameters can be used to control the behaviour of the table function MeetingsByMeetingId. A value must be provided at all times for required parameters, but optional parameters in general do not need to have a value and the execution will default to a pre-defined behaviour. Values can be specified by position and by name. In both cases, all parameters not specified will be treated using their default values.
Value specification by position is done by listing all values from the first to the last needed value. For example with `select * from table(value1, value2, value3)` on a table with four parameters will use the default value for the fourth parameter and the specified values for the first three.
Value specification by name is done by listing all values that require a value. For example with `select * from table(name1 => value1, name3 => value3)` on the same table will use the default values for the second and fourth parameters and the specified values for the first and third.
Name |
Data Type |
Required |
Default Value |
Documentation |
---|---|---|---|---|
meetingId |
int64 |
☑ |
|
The meeting ID |
Table Function Columns
The columns of the table function MeetingsByMeetingId are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
agenda |
string |
|
☐ |
Agenda |
created_at |
datetime |
|
☐ |
Create time |
duration |
int64 |
|
☐ |
Meeting duration |
h323_password |
string |
|
☐ |
H.323/SIP room system password |
host_id |
string |
|
☐ |
ID of the user set as host of meeting |
id |
string |
|
☐ |
Meeting ID, also know as meeting number |
join_url |
string |
|
☐ |
Join url |
password |
string |
|
☐ |
Meeting password |
settings_alternative_hosts |
string |
|
☐ |
Alternative hosts emails or IDs. Multiple value separated by comma. |
settings_approval_type |
int64 |
|
☐ |
|
settings_audio |
string |
|
☐ |
Determine how participants can join the audio portion of the meeting |
settings_auto_recording |
string |
|
☐ |
|
settings_close_registration |
boolean |
|
☐ |
Close registration after event date |
settings_cn_meeting |
boolean |
|
☐ |
Host meeting in China |
settings_enforce_login_domains |
string |
|
☐ |
Only signed-in users with specified domains can join meetings |
settings_enforce_login |
boolean |
|
☐ |
Only signed-in users can join this meeting |
settings_host_video |
boolean |
|
☐ |
Start video when host joins meeting |
settings_in_meeting |
boolean |
|
☐ |
Host meeting in India |
settings_join_before_host |
boolean |
|
☐ |
Allow participants to join the meeting before the host starts the meeting. Only used for scheduled or recurring meetings. |
settings_mute_upon_entry |
boolean |
|
☐ |
Mute participants upon entry |
settings_participant_video |
boolean |
|
☐ |
Start video when participants join meeting |
settings_registration_type |
int64 |
|
☐ |
Registration type. Used for recurring meeting with fixed time only. |
settings_use_pmi |
boolean |
|
☐ |
Use Personal Meeting ID. Only used for scheduled meetings and recurring meetings with no fixed time. |
settings_waiting_room |
boolean |
|
☐ |
Enable waiting room |
settings_watermark |
boolean |
|
☐ |
Add watermark when viewing shared screen |
start_time |
datetime |
|
☐ |
Meeting start time |
start_url |
string |
|
☐ |
Start url |
timezone |
string |
|
☐ |
Timezone to format start_time |
topic |
string |
|
☐ |
Meeting topic |
type |
int64 |
|
☐ |
Meeting Type |
uuid |
string |
|
☐ |
Meeting unique ID |
16-06-2022 17:21 Version 22.1.46-BETA+3385