Versions Compared

Key

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


Panel

Table of Contents

...

Your use of this download is governed by Stonebranch’s Terms of Use, which are available at  Stonebranch Integration Hub - Terms of Use.

Overview

This integration is designed to automate the processing of input data by reading it from a flat file in Windows/Linux or a UAC script data repository. The core functionality revolves around a for-each loop, which iterates through the input data, parsing it using a predefined delimiter (such as a comma, pipe, or any one or two characters).

...

Version Information

Template Name Version
 CS For-Each-Input Loop1.0.0

Refer to Changelog for version history information.

...

  • Actions
    • Read input from a Windows or Linux flat file.
    • Read input from UAC script type data.
    • Parse each line of input via any single or two characters.
    • Launch UAC task or workflow for every line of the parsed input via REST API.
    • Option to wait and launch UAC tasks or workflows based on the previous execution's completion.
    • Capability to launch UAC tasks or workflows either sequentially or in parallel and monitor executions of launched task instances.
    • Restart the for-each loop task from the failed line of input or customize the input lines accordingly in the UAC script data.
    • Option to abort for each loop task For-Each-Input Loop task execution when one of the launched child tasks or workflows fails.
  • Authentication
    • Authentication through HTTP(S)
  • Input/Output
    • Capability to read input from a flat file in Windows or Linux Operating system
    • Can Accept from UAC script data 
    • It can also accept input from UAC script data that points to a variable potentially the data coming from predecessors Taks
    • Print the summary of Tasks instances launched for the input data and their status
  • Other
    • It's a UAC utility that helps to iterate through the input data and process it by launching a UAC task or workflow via REST-API

...

Modifications of this integration, applied by users or customers, before or after import, might affect the supportability of this integration. For more information refer to Integration Modifications.

Configure Universal Task

For a new Universal Task, create a new task, and enter the required input fields.

Input Fields

The For Each loop task -Each-Input Loop task contains the following Input fields

FieldInput typeDefault valueTypeDescription
Select a FunctionRequiredTrigger by Script InputChoice

The action performed upon the task execution.

Valid values are:

  • Trigger by Script Input

  • Trigger by reading Target File

UAC Base URLRequired
TextProvide the universal controller base URL. Eg.-https://xxxxxxx.stonebranchdev.cloud/
UAC CredentialsRequired-CredentialsCredentials for "Basic" Authorization Type. The Credentials definition should be as follows.
  • Universal Controller User as "Runtime User".
  • Universal Controller User Password as "Runtime Password".
User Defined InputRequired-Script

Select or Create a UAC Script type of data that can be provided as input.

Required when the field: Select a Function is selected with "Trigger by Script Input" 

Specify Script name by VariableOptionalFalseBooleanThe flag that determines whether the UAC Script type of data provided as a variable
Script Name by VariableOptional-Text

Provide the UAC Variable that points to the UAC Script of type data 

Required when the field "Specify Script name by Variable" is set to True

Specify the Input FileOptional-Text

Provide the Input File Name included with path either from a Windows or a Linux OS

 Required when the field: Select a Function is selected with "Trigger by reading Target File" 

Specify Delimiter to Parse InputOptionalFalseBooleanEnable it when it required to parse the input data with a single or two-character delimiter
Variable DelimiterOptional-TextSpecify the delimiter value by which the extracted line of input is to be parsed E.g. Comma or Pipe or ## or any single or double character
First Row as HeaderOptionalFalseBoolean

Enable this field if the First row in the input file or script needs to be considered as a header.

If the first line in data is considered as Header, every UAC task launch will have the corresponding header (column name) as a variable name 

UAC Task to triggerRequired-TextSpecify the UAC Task Name or Workflow that needs to be triggered for every input line read
Parallel Job launchOptionalFalseBoolean

Check this field if the UAC Task needs to be launched in Parallel for every line of Input that is been read

By default, the UAC Task is launched Sequentially  & monitored for every line of input read 

Abort Execution When a triggered Job FailsOptionalFalseBooleanEnable this field if the Parent "For-Each loop-Input Loop" task needs to fail when one of the launched child UAC Task fails
Restart from FailureOptionalFalseBooleanEnable the field when the Parent "For-Each loop-Input Loop" task needs to be restarted and input lines to be corrected in UAC Script of type data
Restart Execution InputOptional-ScriptProvides the restart input in the UAC script of type data

...