Report_DatesDaily |
Retrieve daily reportRetrieve daily report for one month, can only get daily report for recent 6 months
Catalog: Zoom
Schema: Reports
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: /report/daily
Insert Zoom API URL: /report/daily
Update Zoom API URL: /report/daily
Delete Zoom API URL: /report/daily
Field Selection Method: NotRequired
Base Path: dates[*]
Select Zoom API Operation: get /report/daily
Parameters of Table Function
The following parameters can be used to control the behaviour of the table function Report_DatesDaily. 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 |
---|---|---|---|---|
month |
int64 |
☐ |
|
Month for this report |
year |
int64 |
☐ |
|
Year for this report |
Table Function Columns
The columns of the table function Report_DatesDaily are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
date |
datetime |
|
☐ |
Date for this object |
meeting_minutes |
int64 |
|
☐ |
Number of meeting minutes on this date |
meetings |
int64 |
|
☐ |
Number of meetings on this date |
month |
int64 |
|
☐ |
Month for this report |
new_users |
int64 |
|
☐ |
Number of new users on this date |
participants |
int64 |
|
☐ |
Number of participants on this date |
year |
int64 |
|
☐ |
Year for this report |
16-06-2022 17:21 Version 22.1.46-BETA+3385