Google Drive query files

Note: This is an external action and may execute on servers running outside your data center Centralized locations used to house servers used by Nintex for remote storage, processing, or distribution of data. Nintex has a number of regional data centers available for Nintex for Office 365. For information about Nintex data centers and where your data center is located, contact your Nintex account or territory manager. region. Before implementing, consider performance and regional concerns where digital boundaries are an issue. For more information, see In-tenant and external actions.

Queries files in Google Drive.

Note: If the service encounters multiple folders with the same name, it will only access the most recently modified folder. Likewise, if the service encounters multiple files with the same name, it will only return the most recently modified file.

Action settings

Do one of the following to open the Action configuration window:

  • Double-click the action.
  • Click on the action and then click Configure.

See Action configuration window for more information.

Field Description
Folder

Specify the folder containing the files to be queried.

All subfolders are recursively queried for the provided Google Drive account.

In the example folder structure, the indicated area is queried for each value specified for Folder.

  • Crestan\Other\Email: Email folder only.
  • Crestan\Depts: Depts folder and all of its subfolders (HR and IT).
  • (unspecified): The root of the folder structure and all subfolders (every file for the provided Google Drive account).

Example folder structure:

Crestan

>Depts

>>HR

>>IT

Other

>Email

Note: If multiple folders of the same name exist, only the most recently modified folder is accessed.

Keyword search

Specify text for search within documents.

Keyword operators:

  • Quotes (""): Contains the exact phrase within the quotes.
  • AND: Contains all given words.
  • OR: Contains one or more of the given words.
  • Hyphen (-): Does not contain the word.

Examples:

  • "red apple" AND metro -nyc: Searches for documents containing the exact phrase "red apple" and the word "metro" but not containing the word "nyc".
  • green OR eager: Searches for documents containing either "green" or "eager." 
Filters

Specify whether or not a filter should be used.

  • Select all items
  • Select items only when the following is true: 

    • When item: Select an item property, select an operand, and enter a value.

    • Add filter rule: Click to add a filter rule.
Order by

Select the property by which to sort the files.

  • Modified
  • Name
  • File Size
Direction

Select the sort direction.

  • Ascending
  • Descending
Authorizing user

Specify an email address to receive the authorization request for the action. External email addresses can be used.

  1. When the action runs, an email with the below content is sent to the email address selected for the Authorizing user.

    2. From: notification@nintexlive.com

    Subject: Contains phrases "Nintex Live" and "Request authorization".

    Contents: Contains links to authorize or deny the operation.

  2. When the link to provide authorization is clicked the user is prompted to do the following:
    1. Log in to the external service.
    2. Allow Nintex Live to access the external service.
    3. Option to stop receiving future authorization requests for the service.

If the authorizationis not provided for one of the following reasons, the workflow is suspended.

  • The authorizing user denies the authorization request by:
    • Clicking the deny link in the email received.
    • Not allowing Nintex live to access the external service.

    The workflow is suspended with the error "The service request has been denied".

  • Authorization is not provided within 7 days after the authorization request is sent.
    • The authorizing user never clicks the authorize link in the email message.
    • The authorizing user initiates the process by clicking the link but does not complete all steps. For example, the authorizing user logs in to the external service but does not complete the step to allow Nintex Live to access the external service.

    • The workflow is suspended with the error "The service request has expired".
ID

Specify a collection or dictionary variable to store the ID of the item.
Modified

Specify a collection or dictionary variable to store the modified date of the item.
Name

Specify a collection or dictionary variable to store the item name.
File size (in bytes)

Specify a collection or dictionary variable to store the file size.
Type

Specify a collection or dictionary variable to store the type of the item.
Result count

Specify an integer variable to store the result count of the query.
For more information about how to use Lookups in configuration fields, see Lookups in action configuration fields.