System activities

Every activity in VeloPhex.System.Activities 0.7.1-rc.12.

Supported

This pack is part of the supported Core profile and ships with Studio.

Package VeloPhex.System.Activities · version 0.7.1-rc.12 · 81 activities. Generated from build 0.7.1-rc.12.

Collection#

Control#

  • Check False: Fails with a message when a condition is true.
  • Check True: Fails with a message when a condition is false.
  • Comment: A note for readers of the workflow; does nothing when run.

Data Table#

  • Add Data Column: Adds a new column of a specified data type to an existing DataTable.
  • Add Data Row: Appends a new row to an existing DataTable using an array of values or a DataRow.
  • Build Data Table: Creates a new DataTable with defined columns and optional initial data.
  • Clear Data Table: Clears all rows from a DataTable while preserving its schema.
  • Filter Data Table: Filters rows in a DataTable based on a column condition, returning a new DataTable.
  • Generate Data Table From Text: Parses delimited text into a structured DataTable.
  • Get Row Item: Retrieves a value from a specified column in a DataRow.
  • Join Data Tables: Combines rows from two DataTables based on matching column values.
  • Lookup Data Table: Searches for a value in a column and retrieves the target cell value and row index.
  • Merge Data Table: Merges a source DataTable into a destination DataTable.
  • Output Data Table: Converts a DataTable into a delimited string representation.
  • Remove Data Column: Removes a specified column from a DataTable by column name or index.
  • Remove Data Row: Removes a specified row from a DataTable by index or DataRow reference.
  • Remove Duplicate Rows: Removes duplicate rows from a DataTable, producing a new DataTable with unique rows.
  • Sort Data Table: Sorts a DataTable by a specified column in ascending or descending order.
  • Update Row Item: Updates a value in a specified column of a DataRow.

Date & Time#

  • Modify Date: Performs date and time arithmetic and formats the output.

Dialogs#

  • Browse for File: Asks the signed-in user to pick a file. Windows only, attended runs.
  • Browse for Folder: Asks the signed-in user to pick a folder. Windows only, attended runs.
  • Input Dialog: Asks the signed-in user for a value, typed or picked from a list. Windows only, attended runs.
  • Message Box: Shows a message to the signed-in user and waits for a button. Windows only, attended runs.

File System#

  • Append Line: Adds a line to the end of a text file.
  • Compress/Zip Files: Compresses files and folders into a zip archive.
  • Copy File: Copies a file to another path, leaving the original in place.
  • Copy Folder: Copies a folder's contents into another folder.
  • Create File: Creates a file, empty or with initial text.
  • Create Folder: Creates a folder, and any folder above it that is missing.
  • Delete File: Deletes a file, and reports whether one was there to delete.
  • Delete Folder: Deletes a folder, optionally with everything inside it.
  • Extract/Unzip Files: Extracts a zip archive into a folder.
  • File Exists: Reports whether a file is at a path.
  • Folder Exists: Reports whether a folder is at a path.
  • Get File Info: Reads a file's name, size, timestamps and read-only flag.
  • Get Files: Gets the paths of files in a directory matching an optional search pattern.
  • Get Folder Info: Reads a folder's name, timestamps, item counts and total size.
  • Get Folders: Gets the paths of subdirectories in a directory matching an optional search pattern.
  • Move File: Moves a file to another path.
  • Move Folder: Moves a folder, and everything in it, to another path.
  • Path Exists: Reports whether a path exists, and whether it is a file or a folder.
  • Read Text File: Reads a text file into a string.
  • Rename File: Renames a file, leaving it in the same folder.
  • Rename Folder: Renames a folder, leaving it where it is.
  • Wait for Download: Waits for a new downloaded file in a folder and returns its path.
  • Write Text File: Writes a string to a text file, replacing its contents.

Invoke#

  • Invoke Method: Calls a public method of an object, or a static method of a type, and returns its result.
  • Invoke PowerShell: Executes a PowerShell script or command and captures output and error streams.
  • Start Process: Starts a system process or application with arguments.

Logging#

  • Add Log Fields: Adds fields that every later log line of the run carries.
  • Log Message: Writes a message to the run log at a chosen level.
  • Remove Log Fields: Stops adding the named fields to later log lines of the run.
  • Report Status: Shows what the run is doing now: a log line and the run's Status field.
  • Write Line: Writes a line of text to the run log.

System#

Text#

  • Format Value: Formats a number or date as text with a format string and culture.
  • Is Match: Indicates whether the regular expression finds a match in the input string.
  • Matches: Searches an input string for all occurrences of a regular expression.
  • Modify Text: Trims, changes the case of, or replaces text in a string.
  • Replace Regex: Replaces strings that match a regular expression pattern with a specified replacement string.
  • Split Text: Splits a string into an array of parts at a separator, or into lines.
  • Text to Left/Right: Splits a string in two around the first or last occurrence of a separator.

Triggers#

  • File Change Trigger: Waits for a file or folder under a path to be created, changed, deleted or renamed.

Collection

Control

Data Table

Date & Time

Dialogs

File System

Invoke

Logging

System

Text

Triggers