Endpoint List Drives
Name
list_drives
Description
Related Tables
Parameters
| Parameter | Required | Options |
|---|---|---|
|
Name:
Label: Site Id Specify a site |
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
|
||
| WebUrl |
DT_WSTR
|
nvarchar(300)
|
300 | |
| OwnerDisplayName |
DT_WSTR
|
nvarchar(200)
|
200 | |
| OwnerEmail |
DT_WSTR
|
nvarchar(200)
|
200 | |
| OwnerId |
DT_WSTR
|
nvarchar(200)
|
200 | |
| OdataContext |
DT_WSTR
|
nvarchar(450)
|
450 |
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 SharePoint Online Connector in API Source or in API Destination SSIS Data Flow components to read or write data.
API Source
This Endpoint belongs to the Drives table, therefore it is better to use it, instead of accessing the endpoint directly:
| Optional Parameters | |
|---|---|
| Site Id | |
API Destination
This Endpoint belongs to the Drives table, therefore it is better to use it, instead of accessing the endpoint directly. Use this table and table-operation pair to list drives:
| Optional Parameters | |
|---|---|
| Site Id | |
ODBC application
Use these SQL queries in your ODBC application data source:
List drives
Lists all drives
SELECT * FROM Drives
list_drives endpoint belongs to
Drives
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 drives
Lists all drives
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Drives';
EXEC (@MyQuery) AT [LS_TO_SHAREPOINT_ONLINE_IN_GATEWAY];
list_drives endpoint belongs to
Drives
table(s), and can therefore be used via those table(s).