Category: Version 7

Sub Activity – Calendar

Calendar provides access to and management of calendar-related information and events, allowing retrieval of holiday data and integration into workflows.

The Calendar category has the following sub activity:

Get Holidays: This activity retrieves the Calendar from the Bot Manager based on the Calendar Name.

Input Properties:

  • Calender Name: Enter the calender name.
  • Holidays: Gets the Calendar holidays as collection.

Demo Project using XML Activities

The URL of the demo project is given below where users can learn about these activities in a better manner. 

Steps:

  1. First Sequence: 
    • Create a sample XML file within Genie Studio. 
    • Read the XML file and assign its contents to a string variable. 
    • Convert the string variable into an XML Document using the “XML Deserialize” activity. 
    • Display the values of the different properties from the XML file in a message box. 
  2. Second Sequence: 
    • Create a sample XML using the “XML Creator” activity. 
    • Replace the value of a specific property of the XML with a variable. 
    • Convert the XML Document into a string variable using the “XML Serialize” activity. 
    • Write the string variable to a text file. 
Activities Used“Read Text File, XML Deserialize, XML Creator, XML Serialize, Write Text File, Message Box”
Video Link https://www.youtube.com/watch?v=c7dVxZKhWbQ&list=PLwFA5laAhcEJ7sVztHRNXDdXffy2odMvv&index=22

Sub Activity – XML 

It is designed to handle XML data efficiently within automation workflows. These activities facilitate the creation, processing, and conversion of XML data.

The XML category has the following sub activities:

XML Creator: This activity returns XMLObject that encodes objects in a string.

Input Properties:

  • Options: Creates a string in XML format. It allows mapping or assigning values to the corresponding node in the string.

Output Properties:

  • XML Document: The resulting XML object that is stored in an object variable.

XML Deserialize: This activity accepts a string in XML format and converts it into an XML Object.

Input Properties:

  • XMLString: The XML String that you want to convert to an object.

Output Properties:

  • XML Document: The resultant XML object that is stored in an object variable.

XML Serialize: This activity converts the input Object into a string in XML format.

Input Properties:

  • Object: The XML object you want to serialize.

Output Properties:

  • XMLString: The resultant XML string is stored.

Demo Project using String Activities (Part 2)

The URL of the demo project is given below where users can learn about these activities in a better manner. 

Steps:

  1. Create a sample string variable and assign a default text value. 
  2. Use the Split String activity to split the string by a separator. (The output needs to be assigned to an Array List variable.) 
  3. Use the String Replace activity to replace a specific character in the string variable with a different character. 
  4. Use the Substring activity to extract a part of the string by providing the starting index and the length of the substring. 
  5. Use the To Lowercase activity to convert the entire string variable to lowercase letters. 
  6. Use the To Uppercase activity to convert the entire string variable to uppercase letters. 
  7. Use the Trim activity to remove any spaces from the left or right side of the text in the string variable. 
Activities Used“Split String, String Replace, To LowerCase, To UpperCase, Trim, Message Box”
Video Link https://www.youtube.com/watch?v=rGyj8DUQMk0&list=PLwFA5laAhcEJ7sVztHRNXDdXffy2odMvv&index=23

Demo Project using String Activities (Part 1)

The URL of the demo project is given below where users can learn about these activities in a better manner. 

Steps:

  1. Extract Text Activity: 
    • Create a string variable and assign a text value in the default value field. 
    • Drag and drop the “Extract Text” activity. 
    • Use the different extraction options available in the Extract Text activity to extract specific parts of the text from the string variable. 
  2. Format DateTime Activity:  
    • Drag and drop the Format DateTime activity. 
    • Provide any date in the value field of the input properties using the “datetime.parse” to the DateTime format. 
    • Select a specific date format from the available options in the “Format Field” dropdown. 
    • Display the formatted DateTime in a message box. 
Activities Used“Extract Text, Format DateTime, Message Box”
Video Linkhttps://www.youtube.com/watch?v=7SnnIacXTV4&list=PLwFA5laAhcEJ7sVztHRNXDdXffy2odMvv&index=19

Sub Activity – String 

These activities help to automate tasks that involve text processing and its operations range from simple tasks such as manipulating, searching, replacing, modifying to more advanced tasks such as regular expression matching and formatting text data.

The String category has the following sub activities:

Create Secure String: This activity helps encrypt any text into a secure String.

Input Properties:

  • InputText: Enter the text to encrypt.

Output Properties:

  • Result: Variable that stores the encrypted text.

Extract Text: This activity extracts the text from the given source string and returns it as a string variable.

Input Properties:

  • Source String: Enter the source string.

Options Properties:

  • “BEFORE” and “AFTER” could be interchanged.

Output Properties:

  • Result: Variable that stores the resultant string.

Is Regex Match: This activity indicates if the specified regular expression finds a match in the specified input string.

Input Properties:

  • Input: Enter a string value to match the expression
  • Regex: This field displays the current form of the regular expression selected/built and gets updated when the conditions have been changed.
  • RegexOptions: A bitwise combination of the enumeration values that specify options for matching.

Output Properties:

  • IsMatch: A boolean variable that returns true if a match is found, else displays false.

Regex Matches: This activity searches for all occurrences of a regular expression input string and returns all successful matches.

Input Properties:

  • Input: Enter a string value to match the expression
  • Regex: This field displays the current form of the regular expression selected/built and gets updated when the conditions have been changed.
  • RegexOptions: A bitwise combination of the enumeration values that specify options for matching.

Output Properties:

  • Matches: Variable that returns the collection of matches found.

Split String: This activity is used to split a specified string which will be stored as separate elements in an ArrayList list based on the separator provided by the user.

Input Properties:

  • InputString: Enter the InputString.
  • Separators: Enter the character or string that separates the components.
  • RemoveEmptyEnteries: Remove any empty entries in the result.

Output Properties:

  • SubStrings: Variable that stores substring.

String Replace: This activity finds and replaces character(s) in the provided source string.

Input Properties:

  • Source String: Enter the string that needs to be replaced.
  • Build: Input the parameters for the replacement.
  • StartingIndex: Enter the starting index from which the search begins.

Output Properties:

  • String: Variable that stores the resultant string.

String Template: This activity uses a template to create dynamic string content with the parameters that are provided by the users.

Input Properties:

  • Parameters: Input values to the StringTemplate compile Activity
  • Template String: Enter a Liquid template string to generate the resulting interpolated string. Eg: Hello {{ name }}!

Output Properties:

  • String: Variable that stores the resultant string.

Sub String: This activity is used to extract a part of the string by giving the index and length of the string that is to be extracted.

Input Properties:

  • Source String: Enter the source string.
  • StartIndex: Enter the starting index from which the search begins.
  • Length: Enter the length of the string to be extracted.

Output Properties:

  • Result: Variable that stores the resultant string.

To LowerCase: This activity converts the string into lowercase.

Input Properties:

  • Source String: Enter the source string.

Output Properties:

  • Result: Variable that stores the resultant string.

To UpperCase: This activity converts the string into uppercase.

Input Properties:

  • Source String: Enter the source string.

Output Properties:

  • Result: Variable that stores the resultant string.

Trim: This activity is used to trim the left or right sections of the string based on the characters.

Input Properties:

  • Source String: Enter the source string that needs to be trimmed.
  • TrimChars: An array of characters to be removed.
  • TrimLeft: Trims characters on the left.
  • TrimRight: Trims characters on the left.

Output Properties:

  • Result: Variable that stores the resultant string.

Demo Project using JSON Activities

The URL of the demo project is given below where users can learn about these activities in a better manner. 

Steps:

  1. Create a sample JSON file within Genie Studio. 
  2. Read the JSON file and assign its contents to a string variable. 
  3. Convert the string variable into a JSON object using the “JSON Deserialize” activity. 
  4. Display the values of the different properties from the JSON file in a message box. 
  5. Create a sample JSON using the “JSON Creator” activity. 
  6. Replace the value of a specific property with a variable. 
  7. Convert the JSON object into a string variable using the “JSON Serialize” activity. 
  8. Write the string variable to a text file. 
Activities Used“Read Text File, JSON Deserialize, JSON Creator, JSON Serialize, Write Text File, Message Box”
Video Link https://www.youtube.com/watch?v=4T7xP66c3RU&list=PLwFA5laAhcEJ7sVztHRNXDdXffy2odMvv&index=18

Sub Activity – JSON

This category allow users to create, manipulate, and process JSON data efficiently in automation workflows. These activities streamline the integration of JSON-based data with other automation components, improving efficiency in data processing.

The JSON category has the following sub activities:

JSON Creator: This activity returns a JObject that encodes a string object. It accepts a string in JSON format and can map variables or values to the respective nodes in the string.

Input Properties:

  • Options: Creates a string in JSON format. It allows you to map or assign values to the corresponding nodes in the string.

Output Properties:

  • JSONObject: The resulting JSON object that is stored in an object variable.

JSON Deserialize: This activity accepts a string in JSON format and converts it into a JSON Object.

Input Properties:

  • JSONString: The JSON string that you want to convert into an object.

Output Properties:

  • JSONObject: The resultant JSON object is stored in an Object variable.

JSON Serialize: This activity converts an input Object into a string in JSON format.

Input Properties:

  • Object: The JSON Object that you want to serialize.

Output Properties:

  • JSONString: The resultant JSON string is stored.

Demo Project using Dictionary Activities

The URL of the demo project is given below where users can learn about these activities in a better manner. 

Steps:

  1. Create a Dictionary using the “Build Dictionary” activity. 
  2. Retrieve the values from the dictionary by using the corresponding keys. 
  3. Add a new key/value pair to the dictionary using the “Add to Dictionary” activity. 
Activities Used“Build Dictionary, Add to Dictionary, Message Box”
Video Link https://www.youtube.com/watch?v=M8CUKaF6hEk&list=PLwFA5laAhcEJ7sVztHRNXDdXffy2odMvv&index=17