Endpoint List Users
Name
list_users
Description
Use this API to list your account's users.'s users [API reference]
Related Tables
Parameters
Parameter | Required | Options |
---|---|---|
Name:
Label: PageSize |
Output Columns
Label | Data Type (SSIS) | Data Type (SQL) | Length | Description |
---|---|---|---|---|
id |
DT_WSTR
|
nvarchar(255)
|
255 | |
first_name |
DT_WSTR
|
nvarchar(255)
|
255 | |
last_name |
DT_WSTR
|
nvarchar(255)
|
255 | |
DT_WSTR
|
nvarchar(255)
|
255 | ||
type |
DT_I8
|
bigint
|
||
pmi |
DT_I8
|
bigint
|
||
timezone |
DT_WSTR
|
nvarchar(255)
|
255 | |
verified |
DT_I8
|
bigint
|
||
dept |
DT_WSTR
|
nvarchar(255)
|
255 | |
created_at |
DT_DBTIMESTAMP
|
datetime
|
||
last_login_time |
DT_DBTIMESTAMP
|
datetime
|
||
last_client_version |
DT_WSTR
|
nvarchar(255)
|
255 | |
pic_url |
DT_WSTR
|
nvarchar(2000)
|
2000 | |
language |
DT_WSTR
|
nvarchar(255)
|
255 | |
phone_number |
DT_WSTR
|
nvarchar(100)
|
100 | |
status |
DT_WSTR
|
nvarchar(100)
|
100 | |
role_id |
DT_WSTR
|
nvarchar(1000)
|
1000 |
Input Columns
Label | Data Type (SSIS) | Data Type (SQL) | Length | 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 or in API Destination SSIS Data Flow components to read or write data.
API Source
This Endpoint belongs to the Users table, therefore it is better to use it, instead of accessing the endpoint directly:
There are no parameters to configure. |

API Destination
This Endpoint belongs to the Users table, therefore it is better to use it, instead of accessing the endpoint directly. Use this table and table-operation pair to list users:
There are no parameters to configure. |

ODBC application
Use these SQL queries in your ODBC application data source:
List Users
Lists all available Users for organization level
SELECT * FROM Users
list_users
endpoint belongs to
Users
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 Users
Lists all available Users for organization level
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Users';
EXEC (@MyQuery) AT [LS_TO_ZOOM_IN_GATEWAY];
list_users
endpoint belongs to
Users
table(s), and can therefore be used via those table(s).