Versions Compared

Key

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


Activities

...

Collection of Objects From String

This activity splits the InputString parameter based on the Separator parameter and builds a collection of Object items as output.

Activity Parameters

The Collection of Objects From String activity parameters can be provided by manual inserted values or via IN arguments or variables:

Image Removed

All of the input parameters are mandatory.

Parameters:

  • InputString (text box editor type): the input string that you wish to separate with Separator parameter to obtain a collection.
  • Separator (text box editor type with "¥" default value ) : the separator used to separate the input string to obtain a collection.

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

  • Output Collection: outputs a collection of type object containing the separated elements from the input string.
  • Output Count : outputs an integer equal to the collection count.
 

...

Image Removed

 

Get Element From Collection

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

Activity Parameters

The Get Element from Collection activity parameters can be provided by manual inserted values or via IN arguments or variables:

 

All of the input parameters are mandatory.

Parameters:

  • InputString (text box editor type): the input string that you wish to separate with Separator parameter to obtain a collection.
  • Separator (text box editor type with "¥" default value ) : the separator used to separate the input string to obtain a collection.

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

  • Output Collection: outputs a collection of type object containing the separated elements from the input string.
  • Output Count : outputs an integer equal to the collection count.
 

...

Image Removed

...

"Browse and Select a .Net Type" window opens. In the Search field, type "Collection" and hit "Enter". After the results are displayed, select the one of type collection<T>. Because the "Output Collection" parameter is of type collection<Object>, select from the drop down list, Object type and hit "Enter".

Image Removed

The "Browse and Select a .Net Type" window will close and the "Collection" defined variable will be of type Collection<Object>.

Image Removed

The "Count" variable should be of type "Int32" because the output parameter "Output Count" returns a value of type "Int32".

In order to display the values stored in the "Collection" variable, an iterator-type activity must be used to iterate through the elements of the collection and output the stored values. Get Element From Collection activity returns a specific element from the collection based on the "Filter Index" value. If all elements from the collection are to be displayed, a Custom ForEach activity should be used. For showcase purposes, in this task, Get Element From Collection activity is used to display the first element of the collection.

The "Count" variable value may be displayed in the Tracking Data panel using a Write Line activity or any other activity that displays values in the Tracking Data panel.

 

Get Element From Collection

Input Values

The "Input Collection" parameter is bound to the "Collection" variable which stores the "Output Collection" parameter from Collection Of Objects From String activity.The "Filter Index" parameters represents the position of the element in the collection. If the "Filter Index" parameter is used, the "Name Indexes" parameter may be ignored.
 Image Removed

Output Values

The output values are stored in three defined variables. Given the case, OUT arguments may be used in the same manner. If the output values are not to be passed outside the task, variables need not be defined, but instead set the "Track Outputs" property for this activity to "Yes" and the output values will be displayed in the Tracking Data without storing them in variables/OUT arguments.

...

In order to display the values stored in the "Collection Count" , "CSVString" and "Element" variables, use  Write Line activity or any other activity that displays values in the Tracking Data panel. Because this type of activities only display string values, variables "Count" and "CollectionCount" must be converted to string with "ToString()" function. The WriteLine activity that displays the counters which are of type "Int32" should have as input ' "Count : " + Count.ToString() +Environment.NewLine + "Collection Count : " +CollectionCount.ToString() '.

On Execution (Home->(Execution section) Start button) -  task "Collections_Demo"  , Tracking Data panel should display:

Image Removed

 

 

 Image Added