To interact with Google Drive® as part of a chain, add a step with a Google Drive connection command. For example:
- Upload, download, move, search, and delete files
- Create and delete folders
Connection Properties
To enable these commands, an IT admin first creates a Google Drive connection and configures its credentials and properties. The connection connects to Google Drive via the REST API.
Step 1. Create an OAuth 2.0 Client ID
To automate functionality within Google Drive from Wdata, first create an OAuth 2.0 client ID.
- 1
- In Google API & Services, select a project, or create a new one.
- 2
- Under Credentials, select the OAuth consent screen tab.
- 3
- Set the application to Internal, and add
onecloud.ioas an authorized domain. - 4
- Click Save.
- 5
- Under Credentials, click Create credentials, and select OAuth client ID.
- 6
- Under Application type, select Web Application, and click Create.
- 7
- Enter a name for the ID.
- 8
- In Authorized JavaScript origins, enter
https://app.onecloud.io. - 9
- In Authorized redirect URIs, enter
http://app.onecloud.io/oauth/callback. - 10
- To generate the OAuth client ID and secret, click Create.
- 11
- To enable API access, select Library from APIs & Services, search for and select Google Drive, and click Enable.
Step 2. Enter the Connection's Properties
When you create the connection, enter these properties:
| Input | Detail |
| Client ID | Enter the client ID from Google API & Services |
| Client Secret | Enter the client secret from Google API & Services |
Note: All sensitive credentials are automatically encrypted and stored at 2,048-bit encryption.
When you connect the connection, choose which Google account to authenticate with, and click Allow to enable automatic authentication in the future.
Note: Enable pop-ups so Google can confirm authentication.
Create Folder
Creates a new folder in Google Drive
Inputs
| Input | Detail |
| Folder Name | Enter the name of the folder to create |
| Parent Folder | Enter the name of the parent folder to create the new folder in. To create the folder at the top level, leave blank. |
Outputs
None
Exit Codes
| Code | Type | Detail |
| 0 | Success | Success |
| 1 | Error | General failure |
| 2 | Error | Invalid arguments |
| 3 | Error | Multiple files found with the given name |
| 4 | Error | Error deleting; requested object is a folder |
| 10 | Error | Error response from Google Drive API |
Delete File
Deletes a file from Google Drive
Inputs
| Input | Detail |
| File Name | Enter the name of the file to delete |
Outputs
None
Exit Codes
| Code | Type | Detail |
| 0 | Success | Success |
| 1 | Error | General failure |
| 2 | Error | Invalid arguments |
| 3 | Error | Multiple files found with the given name |
| 4 | Error | Error deleting; requested object is a folder |
| 10 | Error | Error response from Google Drive API |
Download File
Downloads a file from Google Drive
Inputs
| Input | Detail |
| File Name | Enter the name of the file to download |
| Folder Name | Enter the name of the parent folder to download the file from. To search the entire drive for the file, leave blank. |
| Download Path | Enter the path to where to store the file. To use the file as an output, leave blank. |
| Overwrite | To download the file regardless of whether a file with the same name exists at the path, check this box |
Outputs
| Output | Output Type |
| File | File |
Exit Codes
| Code | Type | Detail |
| 0 | Success | Success |
| 1 | Error | General failure |
| 2 | Error | Invalid arguments |
| 3 | Error | Multiple files found with the given name |
| 4 | Error | Error deleting; requested object is a folder |
| 10 | Error | Error response from Google Drive API |
Move File
Moves a file to a new folder in Google Drive
Inputs
| Input | Detail |
| File Name | Enter the name of the file in Google Drive to move |
| Folder Name | Enter the name of the parent folder to move the file to |
| Overwrite | To move the file to the new folder regardless of whether it already contains a file with the same name, check this box |
Outputs
None
Exit Codes
| Code | Type | Detail |
| 0 | Success | Success |
| 1 | Error | General failure |
| 2 | Error | Invalid arguments |
| 3 | Error | Multiple files found with the given name |
| 4 | Error | Error deleting; requested object is a folder |
| 10 | Error | Error response from Google Drive API |
| 16 | Error | Couldn't write the destination file because another file with the same name exists |
Search Files
Searches for files in Google Drive according to a specified query
Inputs
| Input | Detail |
| Query | Enter the search parameters, in the Google Drive-supported query language |
| Number of Results | Enter the maximum number of results to display; maximum of 100 |
| Order | Select the field to sort the returned files on |
Outputs
| Output | Output Type |
| Files | JSON |
Exit Codes
| Code | Type | Detail |
| 0 | Success | Success |
| 1 | Error | General failure |
| 2 | Error | Invalid arguments |
| 3 | Error | Multiple files found with the given name |
| 4 | Error | Error deleting; requested object is a folder |
| 10 | Error | Error response from Google Drive API |
| 16 | Error | Couldn't write the destination file because another file with the same name exists |
Upload File
Uploads a file to Google Drive
Inputs
| Input | Detail |
| File Name | Enter the name of the file to upload. Can be an existing file on your file system, a command output, or a file resource. |
| Folder Name | Enter the name of the folder to upload the file to in Google Drive. To upload the file to the top level, leave blank. |
| Upload Name | Enter the name of the file upon upload. To use the same name as the File Name input, leave blank. |
| Overwrite | To upload the file regardless of whether a file with the same name exists at the specified location, check this box |
Outputs
| Output | Output Type |
| File Name | String |
Exit Codes
| Code | Type | Detail |
| 0 | Success | Success |
| 1 | Error | General failure |
| 2 | Error | Invalid arguments |
| 3 | Error | Multiple files found with the given name |
| 4 | Error | Error deleting; requested object is a folder |
| 10 | Error | Error response from Google Drive API |