ForEach

This activity helps the user to perform bulk file operations in loop to read, extract, move and perform other operations with it. 

Properties

INPUT

Extension: This parameter indicates to provide the type of extension that needs to be extracted particularly. It accepts “String” datatype. You can either hardcode the values in “String” datatype or provide the value in String format. 

RootDirectory: *Indicates the provide the folder path for execution of file operations. It offers multiple ways to choose the folder:

1. Browse Option: When selecting the “Browse” option, it will automatically list the folders available for the specified account. The user must manually select the spreadsheet each time when using this option.
2. Variable option: You also have the option to provide the values in variable format. You can either hardcode the value in String datatype or provide the values in String format.

MISC

DisplayName: Displays the name of the activity. The activity name can be customized, which aids in troubleshooting.

SkipOnError: Specify the “Boolean” value as “True” or “False.”
True: Continue executing the workflow regardless of any errors thrown.
False: Halt the workflow if it encounters any errors.
None: If the option is left blank, the activity will, by default, behave as if “False” were chosen.

Version: It indicates the version of the feature being used.

OUTPUT

Output: It helps to view the output of the activity as the result of File path. It returns the values in “String” datatype. 

Result: It provides the ability to view the execution status of the activity. It returns values in “Boolean.”
True: Indicates that the activity has been executed successfully without any errors.
False: Indicates that the activity has been unsuccessful due to an unexpected error being thrown.

* Represents mandatory fields to execute the workflow.

Property Configuration

Root Directory: Indicates the provide the folder path for execution of file operations.

Type/Extension (Optional): Users can limit the scope for the file system operation by including the file extensions here. The input should be string with only comma for separating multiple file extensions. Example jpg,png.

Include Subfolders (Optional): When enabled users can increase the scope of file operations by including all the sub folders under the selected root directory.

Skip and continue for access denied (Optional): This will log all the access denied errors and continue to the next file.

Advanced Options (Optional):

File Name: Use this option to configure an advanced filter to specify any conditions for the files to be read.
     a. And / OR condition: The “AND” function returns results that meet all specified conditions, while the “OR” function returns results that meet any of the specified conditions.

Size: Allows users to limit scope for file selection by its Size. Four conditions available equal to, Greater than, lesser than and range.

Created date: Allows users to limit the scope for file selection by file created date.  Four conditions available equal to, Greater than, lesser than and range.

Modified date: Allows users to limit the scope for file selection by file modified date.  Four conditions available equal to, Greater than, lesser than and range.

Limit number of files to: Integer input here is to limit the output file count to match this number.