Google Drive
Google Drive is a file storage and synchronization service created by Google. It allows users to store files in the cloud, share files, and edit documents, spreadsheets, and presentations with collaborators.
This connector is available in the following products and regions:
Service | Class | Regions |
---|---|---|
Logic Apps | Standard | All Logic Apps regions except the following: - Azure China regions - US Department of Defense (DoD) |
Power Automate | Standard | All Power Automate regions except the following: - US Government (GCC High) - China Cloud operated by 21Vianet - US Department of Defense (DoD) |
Power Apps | Standard | All Power Apps regions except the following: - US Government (GCC High) - China Cloud operated by 21Vianet - US Department of Defense (DoD) |
Contact | |
---|---|
Name | Microsoft |
URL | Microsoft LogicApps Support Microsoft Power Automate Support Microsoft Power Apps Support |
Connector Metadata | |
---|---|
Publisher | Microsoft |
Website | https://www.google.com/drive/ |
Privacy policy | https://policies.google.com/privacy |
- This connector is no longer a tabular connector and therefore cannot be used as a tabular data source - including for the Excel connector.
Name | Value |
---|---|
Maximum sheet rows count | 500000 |
Maximum content length (in MB) | 10 |
Maximum number of megabytes being transferred to/from the connector within a bandwidth time interval (per connection) | 1000 |
Bandwidth time interval (in miliseconds) | 60000 |
Name | Calls | Renewal Period |
---|---|---|
API calls per connection | 100 | 60 seconds |
Copy file |
Copies a file on Google Drive |
Create file |
Uploads a file to Google Drive |
Delete file |
Deletes a file from Google Drive |
Extract archive to folder |
Extracts an archive file into a folder in Google Drive (example: .zip) |
Get file content using id |
Retrieves file content from Google Drive using id |
Get file content using path |
Retrieves file content from Google Drive using path |
Get file metadata using id |
Retrieves file metadata from Google Drive using id |
Get file metadata using path |
Retrieves file metadata from Google Drive using path |
List files in folder |
List files in a Google Drive folder |
List files in root folder |
Lists files in the Google Drive root folder |
Update file |
Updates a file in Google Drive |
Copies a file on Google Drive
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Source url
|
source | True | string |
Url to source file |
Destination file path
|
destination | True | string |
Destination file path in Google Drive, including target filename |
Overwrite?
|
overwrite | boolean |
Overwrites the destination file if set to 'true' |
Returns
Blob metadata
- Body
- BlobMetadata
Uploads a file to Google Drive
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Folder path
|
folderPath | True | string |
Folder path to upload the file to Google Drive |
File name
|
name | True | string |
Name of the file to create in Google Drive |
File content
|
body | True | binary |
Content of the file to upload to Google Drive |
Returns
Blob metadata
- Body
- BlobMetadata
Deletes a file from Google Drive
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
File
|
id | True | string |
Specify the file to delete |
Extracts an archive file into a folder in Google Drive (example: .zip)
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Source archive file path
|
source | True | string |
Path to the archive file |
Destination folder path
|
destination | True | string |
Path in Google Drive to extract the archive contents |
Overwrite?
|
overwrite | boolean |
Overwrites the destination files if set to 'true' |
Returns
- response
- array of BlobMetadata
Retrieves file content from Google Drive using id
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
File id
|
id | True | string |
Unique identifier of the file to retrieve in Google Drive |
Infer Content Type
|
inferContentType | boolean |
Infer content-type based on extension |
Returns
The content of the file.
- File Content
- binary
Retrieves file content from Google Drive using path
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
File path
|
path | True | string |
Path of the file in Google Drive |
Infer Content Type
|
inferContentType | boolean |
Infer content-type based on extension |
Returns
The content of the file.
- File Content
- binary
Retrieves file metadata from Google Drive using id
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
File
|
id | True | string |
Specify the file |
Returns
Blob metadata
- Body
- BlobMetadata
Retrieves file metadata from Google Drive using path
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
File path
|
path | True | string |
Path of the file in Google Drive |
Returns
Blob metadata
- Body
- BlobMetadata
List files in a Google Drive folder
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Folder id
|
id | True | string |
Specify the folder in Google Drive |
Returns
- response
- array of BlobMetadata
Updates a file in Google Drive
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
File
|
id | True | string |
Specify the file to update |
File content
|
body | True | binary |
Content of the file to upload to Google Drive |
Returns
Blob metadata
- Body
- BlobMetadata
Blob metadata
Name | Path | Type | Description |
---|---|---|---|
Id
|
Id | string |
The unique id of the file or folder. |
Name
|
Name | string |
The name of the file or folder. |
DisplayName
|
DisplayName | string |
The display name of the file or folder. |
Path
|
Path | string |
The path of the file or folder. |
LastModified
|
LastModified | date-time |
The date and time the file or folder was last modified. |
Size
|
Size | integer |
The size of the file or folder. |
MediaType
|
MediaType | string |
The media type of the file or folder. |
IsFolder
|
IsFolder | boolean |
A boolean value (true, false) to indicate whether or not the blob is a folder. |
ETag
|
ETag | string |
The etag of the file or folder. |
FileLocator
|
FileLocator | string |
The filelocator of the file or folder. |
LastModifiedBy
|
LastModifiedBy | string |
The user who last modified the file or folder. |
This is the basic data type 'binary'.