Endpoint Get my drive info
Name
get_about
Description
Gets my drive information [API reference]
Related Tables
Parameters
| Parameter | Required | Options | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| There are no parameters | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Output Columns
| Label | Data Type (SSIS) | Data Type (SQL) | Length | Description |
|---|---|---|---|---|
| Kind |
DT_WSTR
|
nvarchar(210)
|
210 | |
| UserKind |
DT_WSTR
|
nvarchar(200)
|
200 | |
| UserDisplayName |
DT_WSTR
|
nvarchar(180)
|
180 | |
| UserMe |
DT_WSTR
|
nvarchar(40)
|
40 | |
| UserPermissionId |
DT_WSTR
|
nvarchar(4000)
|
4000 | |
| UserEmailAddress |
DT_WSTR
|
nvarchar(290)
|
290 | |
| StorageQuotaLimit |
DT_I8
|
bigint
|
||
| StorageQuotaUsage |
DT_I8
|
bigint
|
||
| StorageQuotaUsageInDrive |
DT_I8
|
bigint
|
||
| StorageQuotaUsageInDriveTrash |
DT_I4
|
int
|
||
| MaxUploadSize |
DT_I8
|
bigint
|
||
| AppInstalled |
DT_WSTR
|
nvarchar(40)
|
40 | |
| FolderColorPalette |
DT_WSTR
|
nvarchar(3390)
|
3390 | |
| TeamDriveThemes |
DT_NTEXT
|
nvarchar(MAX)
|
||
| DriveThemes |
DT_NTEXT
|
nvarchar(MAX)
|
||
| CanCreateTeamDrives |
DT_WSTR
|
nvarchar(150)
|
150 | |
| CanCreateDrives |
DT_WSTR
|
nvarchar(150)
|
150 |
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 Google Drive Connector in API Source or in API Destination SSIS Data Flow components to read or write data.
API Source
This Endpoint belongs to the Drive 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 Drive table, therefore it is better to use it, instead of accessing the endpoint directly. Use this table and table-operation pair to get my drive info:
| There are no parameters to configure. |
ODBC application
Use these SQL queries in your ODBC application data source:
Get my drive information
Gets my drive information
SELECT * FROM Drive
get_about endpoint belongs to
Drive
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:
Get my drive information
Gets my drive information
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Drive';
EXEC (@MyQuery) AT [LS_TO_GOOGLE_DRIVE_IN_GATEWAY];
get_about endpoint belongs to
Drive
table(s), and can therefore be used via those table(s).