The Microsoft Visual Studio Code Extension for the Universal Integration Platform (UIP) enhances the development experience of creating and working with Universal Extensions. This extension allows users to develop their own Universal Extensions within Visual Studio. To access this extension, download it directly from the Visual Studio Marketplace. Download NowKey Features: Provides an IDE wrapper for the uip-cli command line utilityQuickly prototype Extensions using starter Extension TemplatesBuild and upload Extensions and/or Universal TemplatesPull the latest Universal Template source files from the ControllerDownload the full Universal Template packageDebug Extensions locally without the need of Agent and Controller Note: End user often pair this extension with version control systems like Git or GitHub. In addition, if you prefer coding automated jobs and workflows, take a look at the jobs-as-code extension.

The OAuth 2.0 authorization framework enables a third-party application to obtain limited access to an HTTP service, either: On behalf of a resource owner by orchestrating an approval interaction between the resource owner and the HTTP service.By allowing the third-party application to obtain access on its own behalf. With Universal Automation Center, you can obtain Oauth2 access tokens that can be used to authorize UAC tasks. Key FeaturesSupport to obtain Oauth2 access token for "Resource Owner Password Credentials" (aka "Password Credentials") or "Client Credentials" grant types Support for authorization scopes Support to use the Client Credentials in the request Body or as Basic Authorization Header

Oracle Scheduler, a feature embedded in Oracle Database, facilitates the automation of a variety of tasks, jobs, and processes within the database environment. Users can schedule and oversee the execution of jobs, programs, and scripts at specified intervals or in response to events.  The Universal Task in Stonebranch enables users to directly schedule, trigger, monitor, and orchestrate jobs and job chains within the Oracle Scheduler through the Python module cx_Oracle in Universal Controller. Additionally, it allows the establishment of dependencies among different Oracle jobs or job chains, as well as connections with processes in other applications or platforms through UAC workflows. This integration permits Oracle Scheduler jobs to be triggered from UAC, either through time-based or event-based mechanisms Key Features: This Universal task provides the following main features:Ability to schedule, trigger & orchestrate the execution of Oracle Scheduler Job / Job chainsMonitor the Oracle job / Job Chain execution.Print job logs/execution status post-execution.

This Universal Extension is a tool to process input data in Comma-Separated Value (CSV), Delimited Separated Value (DSV), or Tab Separated Value (TSV) formats. It is typically used when input data need to be read, filtered, and possibly saved into new files or transformed into JSON format. Key Features:Read Input CSV/DSV/TSV input files with the capability to perform row filtering andSave data on a new file of the same format.Transform Data into JSON (as EXTENSION Output)Universal Task enables users to select well-known input data formats (known also as dialects) to parse and process Input data. The dialect list is the following:Excel CSVExcel TSVUnix CSVA “Custom” option also exists to provide full flexibility.

File compression is a way to reduce overall file size without losing any of the primary data to make large files more manageable. This integration provides the capability to compress and decompress a file, with or without password encryption.Key Features:This Universal Extension provides the following main features: ActionsCompress file or directories.Decompress zip files with files or directories.OtherSupport for AES-256 password encryption for files.Support for 7-Zip (Windows/Linux) and p7zip (Linux)Support for Embedded (Linux)What's New V1.3.0Fixed an issue where Windows paths containing spaces were not correctly evaluated.Added the ability to specify an output directory when using 7zip.

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).The parsed data segments are extracted and provided further to UAC tasks or workflows during each iteration. This allows for modular processing, where each task can handle a specific aspect of the data, enabling efficient and organized execution of complex workflows.Key Features:This Universal Template provides the following key features: 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 execution when one of the launched child tasks or workflows fails.What's New v1.0.1:Resolved issue where iterating through an empty list, it exits with RC 2.

GnuPG (GPG) is a command line tool implementing the OpenPGP standard. GPG allows for encryption, decryption and signing of data and communications. This integration provides the capability to perform file encryption and decryption, based on GnuPG. Key Features:Encrypt files based on file patterns and optionally sign the encrypted file.Decrypt files based on file patterns and optionally verify signature.PGP keys can be retrieved from either a local keystore stored on the Universal Agent environment or from a UDMG based keystore. Custom keyring files are supported. What's New: (v1.0.1) Fix check that falsely detects that the target file exists.

HTTP Download is a Universal Extension for downloading content from an HTTP server and storing it on the Universal Agent's File System for later processing. Downloading content from an HTTP server is a common operation in various scenarios, including File Transfer, Data Synchronization, Web Scraping, Data Analysis, and more.Key Features:Download content from the web using HTTP GET method and storing the content on the Universal Agents' file system.Support for Authorization towards a foreign API using Basic Authentication, Bearer Token and API Key.Support for SSL protocol.Progress bar for reviewing the progress of the downloaded content.Checksum verification of the downloaded content.

The Stonebranch Jobs-as-Code (JaC) Universal Extension automates task and workflow delivery pipelines in which the job configuration is managed as code. This approach allows developers to create and manage job configurations using DevOps methodologies — complete with version control, testing, and continuous integration. The extension is configurable, allowing end-users to create jobs-as-code using the integrated development environment (IDE) of choice.The extension integrates with an external version control system (Gitlab, Github, or Bit Bucket), which stores the corresponding job definitions.Integrating with existing delivery pipelines, jobs can be stored on the external git repository and/or imported.Universal Automation Center (UAC) job definitions may be created through the Universal Controller (UC) user interface or as code in a development environment. Key Features:Query UAC definitions based on a variety of selection criteria. This feature can be used as a dry-run before exporting or importing to/from a Git repository.Export selected UAC Definitions to a Git Repository. After the export, this repository can be used as a backup or as a basis for developer collaboration on top of a source version control system.Import back to Universal Controller, UAC Definitions stored already in a Git repository. For UC version 7.3, or higher, the import feature can be triggered by using webhooks. GitLab/GitHub/BitBucket providers are supported.Total count of the selected/exported/imported UAC definitions.Detailed table representation of the exported/imported UAC definitions. What's New v2.0.4Fixed:Getting workflow names through dynamic choice command taking too long.

JSON Tool is a Universal Extension for handling input data in JSON format from different sources. This tool is utilized for reading, filtering and applying light transformations on JSON data. Key Features:The Universal Task accepts three input data sources for processing and filtering. The list of input sources is the following:FileUAC Variable Text FieldThis Universal Extension provides the capability to read and filter input data in JSON format andSave the filtered JSON data into the local filesystem.Display the filtered JSON as Extension Output.

This option executes a PowerShell script from the Universal Controller Script Library.

Universal Task to launch, monitor, and return results from a task defined in a remote Universal Controller.For customers who would like to manage tasks in one Universal Controller from another Universal Controller. Simply supply the target Universal Controller URL, valid credentials, and the name of a task defined to the target Universal Controller. Using the web service API's, the Universal Task launches the requested task by name, captures the new instance sysid, and uses this to track the status of the task. After completion, the output is retrieved if the task type supports this, and the Universal Task complete with the same exit code as the launched task.

This integration allows users to run a command or Stonebranch Universal Controller (UC) data script on a remote SSH server. It enables the execution of commands and scripts from the UC script library on a remote Unix/Linux or Windows SSH server. Key Features: Ends with the exit code from the remote command/script. Both 'stdout' and 'stderr' from the remote task are returned to the integration 'stdout'. The 'stderr' is used for messages from the integration itself. Tested with the Universal Agent bundled Python distribution.Set different log-levels for the integration, providing you amounts of information to suit your needs. Supports both Linux/Unix and Windows. Additional Information: Users should note that this integration is unable to provide the following functionalities that are typically available for tasks that execute on a Universal Agent: No agent visibility, status, or alerting. The remote command or script cannot be cancelled from the controller interface. Canceling the SSH task will only cancel the integration Python script that initiates the SSH session. No fault-tolerant functionality. No clustering, load balancing, or broadcast functionality.What's New in V1.0.2Fixed: Format of uploaded file is changed dynamically in order to be compatible with target OS.

Universal Task to Install Universal Agent via SSH Server; Download Universal Agent Install from Stonebranch Website.The Universal Task automates the following functions: Download Install

UDMG (Universal Data Mover Gateway) is a business-to-business MFT (Managed File Transfer) Solution. It provides the capabilities to securely manage File transfers with external business partners (i.e. Customers or Suppliers), and between any endpoint in today’s Hybrid-IT infrastructure, on-premises, or in the cloud (public and or private).This integration provides UAC customers the ability to manage and integrate their UDMG Server processes within their UAC automation processes and workflows. Key Features This Universal Extension provides the following main features: register a request for a file transfer on the UDMG Server wait for its completion and return the status cancel a transfer pause a transfer resume a transfer What's New V 1.4.1 FixesFixed: Error "Partner Account: Field is required" when saving a task after selecting "Dynamic Retrieval of Partner Account Options" on Universal Controller 7.6

UDMG (Universal Data Mover Gateway) is a business-to-business MFT (Managed File Transfer) Solution. It provides the capabilities to securely manage File transfers with external business partners (i.e. Customers or Suppliers) and between any endpoint in today's Hybrid-IT infrastructure, on-premises, or in the cloud (public and or private). It also comes up with a keystore for PGP public and private keys. This Universal Extension provides the capability to perform OpenGPG encryption and decryption on files while keeping the PGP keys in the UDMG keystore.Key Features:Capability to encrypt single or multiple files with the public PGP key of the intended recipient and optionally sign them with the private key of the sender.Capability to decrypt a single or multiple files with the private PGP key of the intended recipient and optionally verify the signatures with the public key of the sender.Support for deletion or archival of source files after processing.Support for Binary and ASCII armored formats.What's New in V2.0.1Resolved compatibility issues with Linux systems utilizing glibc version 2.17.Error Code 101 now correctly corresponds to a task failure.

A Web service is a method of communication between two electronic devices over a network.This integration provides the capability to call endpoints of foreign APIs. It is beneficial for Stonebranch SaaS customers accessing the Universal Controller in the Stonebranch AWS Cloud and having their Universal Agents deployed in their datacenter. As the integration is triggered from the Universal Agent, no additional firewall port for the Universal Agent needs to be opened. Key Features: Support for communicating with APIs using the HTTP(S)/REST protocol.Support for HTTP Methods GET, POST, PUT, DELETE, PATCH.Support for Authorization towards a foreign API using Basic Authentication, API Key, access token or SSL client authenticationAbility to obtain OAuth2 Access token using Resource Owner Password Credentials (aka "Password Credentials") or Client Credentials Grant Types.Support for SSL Protocol.Ability to use a proxy between Universal Agent and target web service.Ability for configuration of custom exit codes based on the web service response payload (Supported for JSON payloads). What's New in V 1.4.2Fix: Include more logging messages and catch of various exceptions to provide better understanding for different positive and negative cases.