Google Drive modules
The Adobe Workfront Fusion Google Drive modules enable you to monitor, search, create, update, delete, and manage your files, folder, or shared drives in your Google Drive.
In a Adobe Workfront Fusion scenario, you can connect your Google Drive account to multiple third-party applications and services.
If you need instructions on creating a scenario, see Create a scenario in Adobe Workfront Fusion.
For information about modules, see Modules in Adobe Workfront Fusion.
Access requirements
You must have the following access to use the functionality in this article:
To find out what plan, license type, or access you have, contact your Workfront administrator.
For information on Adobe Workfront Fusion licenses, see Adobe Workfront Fusion licenses.
Connecting Google Drive to Workfront Fusion
If you are @gmail.com or @googlemail.com user you need to create an OAuth client on the Google Cloud Platform in order to obtain Client ID and Client Secret.
For step-by-step instructions on how to create the OAuth client (and obtain Client ID and Client Secret), see Connect Adobe Workfront Fusion to Google Services using a custom OAuth client.
For instructions about connecting your Google Drive account to Workfront Fusion, see Create a connection to Adobe Workfront Fusion - Basic instructions
Google Drive modules and their fields
When you configure Google Drive modules, Workfront Fusion displays the fields listed below. Along with these, additional Google Drive fields might display, depending on factors such as your access level in the app or service. A bolded title in a module indicates a required field.
If you see the map button above a field or function, you can use it to set variables and functions for that field. For more information, see Map information from one module to another in Adobe Workfront Fusion.
Triggers
Watch Files In Folder
Retrieves file details when a file is added or modified in the specified folder.
Watch All Files
Retrieves file details when a file in your Google Drive is added or modified.
Watch shared files
Triggers when a new file is shared to you, or an existing shared file is updated.
Watch Comments
Triggers when a comment is added or modified on the selected file.
Actions
Upload a File
Uploads a file to your Google Drive.
Update a File
Updates a file’s metadata or content.
Copy a File
Copies a file to the new location.
Delete a File
Permanently deletes a file or folder.
Move a File/Folder to Trash
Moves a file or folder to the trash.
Get a file
Retrieves the file with the ID specified.
Search for Files/Folders
Searches for files or folders based on search criteria.
Create a Folder
Creates a folder in the specified location.
Get a share link
Retrieves the share link for a file in Google Drive.
Troubleshooting
Unable to upload or update a file
There are several situations when uploading or updating a file fails:
- The uploaded file is too big and exceeds the maximum file size limit allowed for your Google Drive plan or you have exceeded your Google Drive storage limit. You can either upgrade your storage plan or delete existing files from the Google Drive service.
- The selected folder where the file was to be uploaded to no longer exists. The scenario stops and it is then necessary to select a target folder again.
Search for files
In the module List files in a folder you can use your own query which consists of these parts:
-
Field - Attribute of the file that is being searched, for example, the attribute
name
of the file. -
Operator - Test that is performed on the data to provide a match, for example,
contains
. -
Value - The content of the attribute that is tested, for example, the name of the file
My cool document
.
Combine clauses with the conjunctions and
or or
, and negate the query with not
.
Fields
title
contains
1, =
, !=
fullText
contains
2, 3mimeType
contains
, =
, !=
modifiedDate
<=
, <
, =
, !=
, >
, >=
lastViewedByMeDate
<=
, <
, =
, !=
, >
, >=
trashed
=
, !=
starred
=
, !=
parents
in
owners
in
writers
in
readers
in
sharedWithMe
=
, !=
properties
has
Consider the following about operators in these fields:
-
The
contains
operator only performs prefix matching for atitle
.For example, the title “HelloWorld” matches for
title contains 'Hello'
but not fortitle contains 'World'
. -
The
contains
operator only performs matching on entire string tokens forfullText
.For example, if the full text of a doc contains the string “HelloWorld” only the query
fullText contains 'HelloWorld'
returns a result. Queries such asfullText contains 'Hello'
would not return results in this scenario. -
The
contains
operator matches on an exact alphanumeric phrase if it is surrounded by double quotes.For example, if the
fullText
of a doc contains the string “Hello there world”, then the queryfullText contains '"Hello there"'
returns a result, but the queryfullText contains '"Hello world"'
does not.Furthermore, because the search is alphanumeric, if the
fullText
of a doc contains the string “Hello_world”, then the queryfullText contains '"Hello world"'
returns a result. -
Fields of
type
date are currently not comparable to each other, only to constant dates.
Value types
\'
, e.g., 'Valentine\'s Day'
.true
or false
.2012-06-04T12:00:00-08:00
.Operators
contains
=
!=
<
<=
>
>=
in
and
or
not
has
For compound clauses, you can use parentheses to group clauses together. For example:modifiedDate > '2012-06-04T12:00:00' and (mimeType contains 'image/' or mimeType contains 'video/')
This search returns all files with an image or video MIME type that their last modification was after June 4, 2012. Because and
and or
operators are evaluated from left to right, without parentheses, the above example would return only images modified after June 4, 2012, but would return all videos, even those before June 4, 2012.
Examples
All examples on this page show the unencoded <q>q</q>
parameter, where title = 'hello'
is encoded as title+%3d+%27hello%27
. Client libraries handle this encoding automatically.
-
Search for files with the name “hello”
title = 'hello'
-
Search for folders using the folder-specific MIME type
mimeType = 'application/vnd.google-apps.folder'
-
Search for files that are not folders
mimeType != 'application/vnd.google-apps.folder'
-
Search for files with a name containing the words “hello” and “goodbye”
title contains 'hello' and name contains 'goodbye'
-
Search for files with a name that does not contain the word “hello”
not title contains 'hello'
-
Search for files containing the word “hello” in the content
fullText contains 'hello'
-
Search for files not containing the word “hello” in the content
not fullText contains 'hello'
-
Search for files containing the exact phrase “hello world” in the content
fullText contains '"hello world"'fullText contains '"hello_world"'
-
Search for files with a query containing the "" character (e.g., “\authors”)
fullText contains '\\authors'
-
Search for files writeable by the user “test@example.org”
'test@example.org' in writers
-
Search for the ID
1234567
in theparents
collection. This finds all files and folders located directly in the folder whose ID is1234567
.'1234567' in parents
-
Search for the alias ID
appDataFolder
in theparents
collection. This finds all files and folders located directly under the Application Data folder.'appDataFolder' in parents
-
Search for files writeable by the users “test@example.org” and “test2@example.org”
'test@example.org' in writers and 'test2@example.org' in writers
-
Search for files containing the text “important” which are in the trash
fullText contains 'important' and trashed = true
-
Search for files modified after June 4th 2012
modifiedDate > '2012-06-04T12:00:00' // default time zone is UTC
modifiedDate > '2012-06-04T12:00:00-08:00'
-
Search for files shared with the authorized user with “hello” in the name
sharedWithMe and title contains 'hello'
-
Search for files with a custom file property named
additionalID
with the value8e8aceg2af2ge72e78
.properties has { key='additionalID' and value='8e8aceg2af2ge72e78' and visibility='PRIVATE' }
Source of this guide is Google Drive documentation.