Endpoint

Get Users

Name

get_users

Get the list of users. [API reference]

Parameter

Label

Required

Options

Description

OrderBy

Order By

Order the specified column by ascending or descending order [API reference]

SearchCriteria

Search Criteria

Data filter (e.g. somecolumn -eq 'somevalue') [API reference]

PageSize

Page Size

The number of records to include in each page of results [API reference]

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
Id	`DT_WSTR`	`nvarchar(255)`	255	`False`
DisplayName	`DT_WSTR`	`nvarchar(500)`	500	`False`
Description	`DT_WSTR`	`nvarchar(4000)`	4000	`False`
BusinessPhones	`DT_WSTR`	`nvarchar(4000)`	4000	`False`
GivenName	`DT_WSTR`	`nvarchar(80)`	80	`False`
JobTitle	`DT_WSTR`	`nvarchar(200)`	200	`False`
Mail	`DT_WSTR`	`nvarchar(200)`	200	`False`
MobilePhone	`DT_WSTR`	`nvarchar(500)`	500	`False`
OfficeLocation	`DT_WSTR`	`nvarchar(500)`	500	`False`
PreferredLanguage	`DT_WSTR`	`nvarchar(100)`	100	`False`
SurName	`DT_WSTR`	`nvarchar(80)`	80	`False`
UserPrincipalName	`DT_WSTR`	`nvarchar(200)`	200	`False`
CreatedDateTime	`DT_DBTIMESTAMP`	`datetime`		`False`
DeletedDateTime	`DT_DBTIMESTAMP`	`datetime`		`False`
IdPath	`DT_WSTR`	`nvarchar(255)`	255	`False`

If the column you are looking for is missing, consider customizing OneDrive Connector.

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw	Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.

Use OneDrive Connector in API Source component to read data or in API Destination component to read/write data:

This Endpoint belongs to Users table, therefore you cannot work with it directly. Use this table and table-operation pair instead:

OneDrive

Users

Select

Use these SQL queries in your ODBC application data source:

SELECT * FROM get_users

get_users endpoint belongs to Users table(s), and can therefore be used via those table(s).

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM get_users';

EXEC (@MyQuery) AT [LS_TO_ONEDRIVE_IN_GATEWAY];

get_users endpoint belongs to Users table(s), and can therefore be used via those table(s).