# ReportUsers Retrieve hosts report Retrieve active or inactive hosts report for a specified period - Catalog: `Zoom` - Schema: `Reports` - Select Zoom API URL: `/report/users` - Insert Zoom API URL: `/report/users` - Update Zoom API URL: `/report/users` - Delete Zoom API URL: `/report/users` - Field Selection Method: NotRequired - Select Zoom API Operation: `get /report/users` 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. ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `from` | `datetime` | ☑ | | Start Date | | `page_number` | `int64` | ☐ | 1 | Current page number of returned records | | `page_size` | `int64` | ☐ | 30 | The number of records returned within a single API call | | `to` | `datetime` | ☑ | | End Date | | `type` | `string` | ☐ | | Active hosts or inactive hosts (Values: active, inactive) | ## Columns of Table Function The columns of the table function `ReportUsers` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `from` | `datetime` | | ☐ | Start date for this report | | `page_count` | `int64` | | ☐ | The number of items returned on this page | | `page_number` | `int64` | | ☐ | The page number of current results | | `page_size` | `int64` | | ☐ | The number of records returned within a single API call | | `to` | `datetime` | | ☐ | End date for this report | | `total_meeting_minutes` | `int64` | | ☐ | Number of meeting minutes for this range | | `total_meetings` | `int64` | | ☐ | Number of meetings for this range | | `total_participants` | `int64` | | ☐ | Number of participants for this range | | `total_records` | `int64` | | ☐ | The number of all records available across pages |