Versions Compared

Version Old Version 11 New Version Current
Changes made by

wiki

wiki

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Activities


Image Added

Account Info

This activity returns the specified GoogleDrive account information.

...

  • Output (type: Collection<String>): outputs a collection of strings with the specified Googledrive account information. A For Each and/or a Get Element From Collection activity can be used in order to extract he collection's values.

 


Execution: the activity will output the connected account's information:

 


Using the For Each activity to extract the collection's values:

 

 


Using the Get Element From Collection activity to extract the collection's values:

 

 

 






 

 

 



 

Connect To Googledrive

This activity connects to the specified Googledrive account and outputs a Googledrive client connection.

Activity Parameters

The Connect to Googledrive activity parameters can be provided by manual inserted values or via IN arguments or variables:

Parameters:

  • Client ID (text box editor type): the client ID. This ID can be get from Google Developers Console, from your App:
  • Client Secret (text box editor type): the client secret. This code can be get from Google Drive Developers Console, from your App:
  • Refresh Token (text box editor type): the GoogleDrive App connection token. This access token can be get by using Flowster Portal and a workflow with at least one argument, by following the next steps:
    • GoogleDrive: create an App. It should automatically provide a new App Client ID and a Client Secret code:



    • Administrator: create a workflow with one argument
    • Administrator - Edit Parameters: set the argument to Cloud → GoogleDrive type and insert the Client ID and the Client Secret in the required field


    • Administrator: make the workflow active
    • Portal: start the workflow and inside the Start Task workflow window click the Click Here option:


    • A new window will be opened, asking for access to the GoogleDrive account information
    • Click Accept and go back to the Portal. The Click Here text will be changed with Job Done. Click Start Task workflow and after the task workflow is started, copy the value from the Argument:


    • Workflow Connect To GoogleDrive activity: insert the copied value into the Refresh Token field:

The Read Only Output variable are the possible output values that the activity will provide:

  • Connection: outputs a Googledrive connection. The Ouput of this activity should be used as Input for all Connection parameters used for all activities placed under Googledrive category.

...

Delete File or Folder

This activity deletes the specified file or folder from the specified Googledrive account.

Activity Parameters

The Delete File or Folder activity parameters can be provided by manual inserted values or via IN arguments or variables:

All of the input parameters are mandatory.

Parameters:

  • File or Folder Path (text box editor type): the full path of the file or folder which you want to be deleted. E.g. FlowsterMSSQLActivities.bak, which meand that the activity will download the file from the Home directory.

The Read Only Output variable are the possible output values that the activity will provide:

  • Output: outputs the result status. If the item was deleted successfully then TRUE, otherwise FALSE.
 
Execution: the activity will delete the given file from Google Drive:



Disconnect From Googledrive

This activity disconnects the specified Googledrive account.

Activity Parameters

The Disconnect from Googledrive activity parameters can be provided by manual inserted values or via IN arguments or variables:

Parameters:

  • Connection (text box editor type): the Googledrive connection, obtained after using a Connect to Googledrive activity.

 

 

 

 

 






Download File

This activity downloads the specified Googledrive file.

Activity Parameters

The Download File activity parameters can be provided by manual inserted values or via IN arguments or variables:

Parameters:

  • Destination Folder Path (text box editor type): the path of the folder where you wish to download the file.
  • File Path (text box editor type): the full path of the existing file on the Googledrive account, which you wish to download. E.g. FlowsterMSSQLActivities.bak, which meand that the activity will download the file from the Home directory.

The Read Only Output variable are the possible output values that the activity will provide:

  • Output: outputs the result status. If the item was downloaded successfully then TRUE, otherwise FALSE.
  • Output Status: outputs the full path.
 
 


Execution: the activity will download the file from GoogleDrive into the given location:

 

 

 






List Files and Folders

This activity lists all files and folders from the specified Googledrive account.

Activity Parameters

The List Files and Folders activity parameters can be provided by manual inserted values or via IN arguments or variables:

Parameters:

  • Document Type (combo box editor type): the document type which you would like to be listed. Flowster Studio provides Files, Folders and All as options.
  • Parent Folder (combo box control): the full path of the folder from where you want to list all the SubItems. If left with the default value "", it will list all the items from the Home directory.

The Read Only Output variable are the possible output values that the activity will provide:

  • Output (type: Collection<Collection<String>>): outputs a collection of Document Type items and their properties.To use the elements of the collection, use For Each and/or Get Element From Collection activities.
  • Output rows count (type: Int32): outputs the number of files and folders found on the specified OneDrive account.

 


Execution: the activity will list all items from the account where it is connected to (in our case, both Files and Folders):

 


Using For Each activities to get the elements from the Type Items collection:

  • a first For Each activity to extract a single Collection from the main Collection:


  • a second For Each activity to extract the values from the second collection:
 


 Using For Each and Get Element From Collection activities to extract the elements from the Type Items collection:

  • a For Each activity to extract a single Collection from the main Collection:


  • a Get Element From Collection activity to extract the values from the second collection:




 



Upload File

This activity uploads a selected file to the specified Googledrive Account.

Activity Parameters

The Upload File activity parameters can be provided by manual inserted values or via IN arguments or variables:

All of the input parameters are mandatory.

Parameters:

  • File Path (text box editor type): the full path of the file that you wish to upload. The maximum allowed file size is 300 MB.
  • Overwrite (combo box control): choose "Yes" for overwriting the file that already exists, or "No" for recreating it.
  • Parent Folder (combo box control): directory on GoogleDrive where you wish to upload the file. If left blank it will upload the file to the home directory.

The Read Only Output variable are the possible output values that the activity will provide:

  • Output: outputs the Full path.
  • Output status: outputs result status. If the item was uploaded successfully then TRUE, otherwise FALSE.
 

Execution: the activity uploads the given file at the given GoogleDrive location:

 


The uploaded file can be seen on Google Drive: