EndPoint Get User Drives

Name

get_user_drives

List all drives which are either shared with you (i.e. via shared files or folders) or you have full access to that drive. [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
DriveId	`DT_WSTR`	`nvarchar(255)`	255	`False`
DriveName	`DT_WSTR`	`nvarchar(255)`	255	`False`
DriveType	`DT_WSTR`	`nvarchar(255)`	255	`False`
Description	`DT_WSTR`	`nvarchar(500)`	500	`False`
WebUrl	`DT_WSTR`	`nvarchar(500)`	500	`False`
CreatedDateTime	`DT_DBTIMESTAMP`	`datetime`		`False`
LastModifiedDateTime	`DT_DBTIMESTAMP`	`datetime`		`False`
CreatedByByDisplayName	`DT_WSTR`	`nvarchar(500)`	500	`False`
LastModifiedByDisplayName	`DT_WSTR`	`nvarchar(500)`	500	`False`
LastModifiedByEmail	`DT_WSTR`	`nvarchar(500)`	500	`False`
LastModifiedById	`DT_WSTR`	`nvarchar(500)`	500	`False`
QuotaDeleted	`DT_I8`	`bigint`		`False`
QuotaRemaining	`DT_I8`	`bigint`		`False`
QuotaTotal	`DT_I8`	`bigint`		`False`
QuotaUsed	`DT_I8`	`bigint`		`False`
QuotaState	`DT_WSTR`	`nvarchar(50)`	50	`False`
UserId	`DT_WSTR`	`nvarchar(255)`	255	`False`
UserDisplayName	`DT_WSTR`	`nvarchar(500)`	500	`False`
UserDescription	`DT_WSTR`	`nvarchar(4000)`	4000	`False`
UserBusinessPhones	`DT_WSTR`	`nvarchar(4000)`	4000	`False`
UserGivenName	`DT_WSTR`	`nvarchar(80)`	80	`False`
UserJobTitle	`DT_WSTR`	`nvarchar(200)`	200	`False`
UserMail	`DT_WSTR`	`nvarchar(200)`	200	`False`
UserMobilePhone	`DT_WSTR`	`nvarchar(500)`	500	`False`
UserOfficeLocation	`DT_WSTR`	`nvarchar(500)`	500	`False`
UserPreferredLanguage	`DT_WSTR`	`nvarchar(100)`	100	`False`
UserSurName	`DT_WSTR`	`nvarchar(80)`	80	`False`
UserPrincipalName	`DT_WSTR`	`nvarchar(200)`	200	`False`
UserCreatedDateTime	`DT_DBTIMESTAMP`	`datetime`		`False`
UserDeletedDateTime	`DT_DBTIMESTAMP`	`datetime`		`False`

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:

OneDrive

Get User Drives

OneDrive

Get User Drives