Google Drive Commands

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.io as 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

When you connect the connection, choose which Google account to authenticate with, and click Allow to enable automatic authentication in the future.

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