Endpoint Read Drive
Name
get_drive
Description
Parameters
| Parameter | Required | Options | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|
Name:
Label: Drive Id / Shared Folder Specify a drive |
YES | |||||||||
|
Name:
Label: Default Group or User Id (additional Scopes needed to list - If fails enter manually) To list all users and groups from your organizations you need additional scopes. See connection UI - Choose User.Read.All and Group.Read.All Scopes and regenerate token. You can manually type value too if you know Group or User Id. Format is /users/{id} OR /groups/{id} |
|
Output Columns
| Label | Data Type (SSIS) | Data Type (SQL) | Length | Description |
|---|---|---|---|---|
| Id |
DT_WSTR
|
nvarchar(500)
|
500 | |
| Name |
DT_WSTR
|
nvarchar(300)
|
300 | |
| Description |
DT_WSTR
|
nvarchar(500)
|
500 | |
| DriveType |
DT_WSTR
|
nvarchar(60)
|
60 | |
| CreatedAt |
DT_DBTIMESTAMP
|
datetime
|
||
| CreatedByUser |
DT_WSTR
|
nvarchar(56)
|
56 | |
| LastModifiedAt |
DT_DBTIMESTAMP
|
datetime
|
||
| LastModifiedByUser |
DT_WSTR
|
nvarchar(48)
|
48 | |
| LastModifiedByUserEmail |
DT_WSTR
|
nvarchar(100)
|
100 | |
| LastModifiedByUserId |
DT_WSTR
|
nvarchar(144)
|
144 | |
| QuotaDeleted |
DT_I8
|
bigint
|
||
| QuotaRemaining |
DT_I8
|
bigint
|
||
| QuotaTotal |
DT_I8
|
bigint
|
||
| QuotaUsed |
DT_I8
|
bigint
|
||
| QuotaState |
DT_WSTR
|
nvarchar(50)
|
50 | |
| WebUrl |
DT_WSTR
|
nvarchar(300)
|
300 | |
| OdataContext |
DT_WSTR
|
nvarchar(450)
|
450 |
If the column you are looking for is missing, consider customizing OneDrive Connector.
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 OneDrive Connector in API Source or in API Destination SSIS Data Flow components to read or write data.
API Source
API Source - OneDrive
OneDrive Connector can be used to integrate OneDrive and your defined data source, e.g. Microsoft SQL, Oracle, Excel, Power BI, etc. Get, write, delete OneDrive data in a few clicks!
OneDrive
Read Drive
| Required Parameters | |
|---|---|
| Drive Id / Shared Folder | Fill-in the parameter... |
| Optional Parameters | |
| Default Group or User Id (additional Scopes needed to list - If fails enter manually) | |
API Destination
API Destination - OneDrive
OneDrive Connector can be used to integrate OneDrive and your defined data source, e.g. Microsoft SQL, Oracle, Excel, Power BI, etc. Get, write, delete OneDrive data in a few clicks!
OneDrive
Read Drive
| Required Parameters | |
|---|---|
| Drive Id / Shared Folder | Fill-in the parameter... |
| Optional Parameters | |
| Default Group or User Id (additional Scopes needed to list - If fails enter manually) | |
ODBC application
Use these SQL queries in your ODBC application data source:
Get drive
Gets info about drive
SELECT * FROM get_drive
WITH (DriveId='b!GtLQTMU726XXXXY5F2BBNi14')
--You can get DriveId by selecting from 'Drives' table.SQL Server
Use these SQL queries in SQL Server after you create a data source in Data Gateway:
Get drive
Gets info about drive
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM get_drive
WITH (DriveId=''b!GtLQTMU726XXXXY5F2BBNi14'')
--You can get DriveId by selecting from ''Drives'' table.';
EXEC (@MyQuery) AT [LS_TO_ONEDRIVE_IN_GATEWAY];