turbot/zoom

steampipe plugin install zoomsteampipe plugin install zoom
On This Page
Get Involved

Table: zoom_meeting

Query information about meetings in the Zoom account.

Note: A user_id must be provided in all queries to this table.

Examples

List all meetings for a given host

select
*
from
zoom_meeting
where
user_id = 'RCKlotFLRpe-Hbnv-VK3CA'

List all meetings for a given host by email

select
*
from
zoom_meeting
where
user_id in (select id from zoom_user where email = 'dwight@dundermifflin.com')

Get a meeting by ID

select
*
from
zoom_meeting
where
id = 912357281124

.inspect zoom_meeting

Scheduled meetings for the host. Instant meetings are not returned.

NameTypeDescription
account_idtextZoom account ID.
agendatextMeeting description.
created_attimestamp without time zoneTime when the meeting was created.
durationbigintMeeting duration.
encrypted_passwordtextEncrypted passcode for third party endpoints (H323/SIP).
h323_passwordtextH.323/SIP room system passcode.
idbigintMeeting ID, also known as the meeting number.
join_urltextURL using which participants can join a meeting.
occurrencesjsonbArray of occurrence objects.
passwordtextMeeting passcode.
pmitextPersonal meeting ID.
recurrencejsonbRecurrence details.
settingsjsonbMeeting settings.
start_timetimestamp without time zoneMeeting start time in GMT/UTC. Start time will not be returned if the meeting is an instant meeting.
start_urltextThe start_url of a meeting is a URL using which a host or an alternative host can start the Meeting.
statustextMeeting status: waiting or started.
timezonetextTimezone to format the meeting start time.
topictextMeeting topic.
tracking_fieldsjsonbTracking fields.
typebigintMeeting Types: 1 - Instant meeting. 2 - Scheduled meeting. 3 - Recurring meeting with no fixed time. 8 - Recurring meeting with fixed time.
user_idtextID of the user who is set as the host of the meeting.
uuidtextUnique Meeting ID. Each meeting instance will generate its own Meeting UUID.