This integration is for any email provider that uses SMTP and IMAP, including email vendors like Outlook.com, Microsoft Exchange, and Gmail. This integration allows sending and retrieve E-Mails and E-Mail attachments. It also provides the functionality to download mail attachments to a mail folder. This Integration is beneficial for Stonebranch SaaS customers, accessing the Universal Controller in the Stonebranch AWS Cloud and having their Universal Agents deployed in their own datacenter. As the Integration is triggered from the Universal Agent, no additional firewall ports would need to be opened. Key Features Some details about Universal Tasks to send and retrieve E-Mails and E-Mail attachments. Main functionalities: Send an E-Mail with or without attachments Use Universal Controller Variables Retrieve an E-Mail based on filter criteria like From, To, sender, subject, body content … Move an E-Mail to a Mail folder after downloading it to a configured folder Delete an E-Mail after downloading it to a configured folder

Google BigQuery is a serverless, highly scalable data warehouse designed to make SQL-based queries on large datasets fast and easy. It is part of the Google Cloud Platform and enables users to perform real-time data analysis with its powerful processing capabilities and simple SQL interface.. This Universal Task allows Stonebranch users to schedule, trigger, monitor, and orchestrate the Google BigQuery process directly from the Universal Controller.   This task uses Python modules google-cloud-big query and google-auth to make REST-API calls to Google BigQuery This task will use the GCP Project ID, BigQuery SQL or Schema, Dataset ID, Job ID, Location, Table ID, Cloud Storage URI, and Source File Format as parameters of BigQuery function, and GCP KeyFile (API KEY) of Service account for authenticating the REST-API calls to Google BigQuery. Key Features This Universal task provides the following main features: BigQuery SQL List dataset List tables in the dataset View job information Create a dataset Load local file to a table Load cloud storage data to a table Export table data What's New (v1.1.4) This new release involves a Bug Fix Fix: Usage for the Double quotes for the _scriptPath

Google Kubernetes Engine (GKE) is a service for deploying, managing, and scaling Kubernetes containers on Google Cloud. Among its capabilities, GKE supports Jobs, which are used for executing tasks that run to completion, such as batch jobs or one-time processing tasks. To deploy a Job, a Kubernetes Job resource definition is used. Said file is typically defined inside of a YAML or JSON file and specifies the task details, container image, and execution configuration. Once applied to a GKE cluster, the Job runs to completion and terminates automatically. This integration provides the capability to deploy a GKE job on a specified cluster or delete a job from a namespace. Key Features Deploy and Monitor a GKE job on the specified cluster by providing the required Job Resource Definition Job can be provided as a UAC Script, a local file or using an HTTP link. STDOUT and EXTENSION Output can be tuned to provide useful information for the execution of the Job. The executed Job can be deleted automatically. Dynamic commands "Retrieve Container Logs" and "Delete Current Job" can be used on invoked Task Instances. Delete a GKE job from the specified namespace.

This Universal Extension provides the capability to monitor objects (files/directories) on various major Cloud Providers including AWS, Google Cloud, Microsoft Azure and trigger Universal Events, which can be used for execution of tasks and workflows. It can be executed as a standalone UAC Task, however in order to benefit from the full functionality and scalability of UAC, it is suggested to be used in conjunction with Universal Monitor Triggers and Universal Monitor Tasks. Multiple storage systems are supported (an overview can be found here). Integrations within this solution package include: Amazon S3 Google Cloud Storage Microsoft OneDrive Business, including Sharepoint Microsoft Azure Blob Storage Hadoop Distributed File Storage (HDFS) Local file system (Linux, Windows) HTTP(S) URL Key Features: This Universal Extension supports the following key features: Features Monitor Object Creation, Change (based on modification time) and Deletion using advanced filtering capabilities Generates Universal Events for each entity the monitor has detected, which can be used to trigger other tasks and workflows. Large set of possible parameterization and coverage of remote storages. Plug & Play, easy installation without the need to install external dependencies. Dynamic token updates for OneDrive Business cloud storage, observing the OneDrive business refresh token flow. Enhanced observability with event metrics, providing users with detailed statistical insights into events processed across all task instances. Shared configuration with Cloud Data Transfer. What's New v 2.0.1 Fixes Fixed an issue where an event produced by this integration caused a crash on certain extensions. What's New v 2.0.0 Enhancements Installing external dependencies is no longer required. The extension can now automatically attempt to update and store short-lived OneDrive tokens without any extra configuration. It is now possible to detect whether an event involves a directory. Introduced observability features using event metrics. Added the option to skip SSL Verification when updating Credentials. Credential updates on the Universal Controller are performed only when necessary. Other user experience improvements. Deprecations and Breaking Changes Event templates have been reduced to a single template. Changed extension prefix to ue_cloud, providing the capability to share the same configuration with Cloud Data Transfer. Refer to the documentation's migration guide if upgrading from version 1. Fixes Action Monitor On Change error when a file was created. Events were not published in some cases when field Recursion Depth was set to a value greater than 1. Unchecking the Use Storage Modtime field resulted in task failure. Running the task with any local user is now supported with Agent versions where issue D-13034 is resolved. Update Credentials functionality is corrected to retain the existing Key Location value. Task will not fail when using Windows paths including whitespaces.

This Universal Extension provides the capability to perform data transfers between cloud based storage services, as well as local or distributed file systems. Transfers are fast and secure since data are streamed from one storage to another with no intermediate storage taking place. Multiple storage systems are supported (an overview can be found here). Integrations within this solution package include: Amazon S3 Google Cloud Storage Microsoft OneDrive Business, including Sharepoint Microsoft Azure Blob Storage Hadoop Distributed File Storage (HDFS) Local file system (Linux, Windows) HTTP(S) URL Key Features This Universal Extension supports the following key features: Actions Copy, move, synchronize data between two storages. Copy a URL's content and to cloud or local destination without saving it in temporary storage. List data on a storage, including listing with details or in JSON format for machine parsing. Create objects on a storage. Delete objects from a storage. Features: Fast transfers for objects stored in the same region. Preserves always timestamps and verifies checksums. Supports encryption, caching, compression, chunking. Dynamic token updates for OneDrive Business cloud storage, observing the OneDrive business refresh token flow. Support for dry runs. Allows users to execute a Universal Task without making any permanent changes on the target storage. Advanced filtering capability for files or objects to be listed or transferred. Option to mark the Universal Task as Failed when no files have been transferred. List of overwrite options for existing data. Additional customized options. Observability capabilities, providing users with detailed statistical insights for data transfers across all task instances. Output Progress of the selected Action is visible, during Universal Task Instance execution. Text or JSON formatted output. What's New V 4.1.1 Fixes List actions would not display the complete object name.  What's New V 4.1.0 Enhancements Introduced the ability to authenticate on remotes of type OneDrive using the OAuth Client Credential flow. Introduced the option to provide detailed information of affected files after the Task execution. Added the option to toggle the SSL Verification process when attempting to update Credentials using HTTPS. Credential updates on the Universal Controller are performed only when necessary. Fixes Running the task with any local user is now supported with Agent versions where issue D-13034 is resolved. Extension output enhancement on Task failure. Fixed "Index out of range" error with the List Objects action. Fixed Task failure when paths with whitespaces are provided on Windows agents. Update Credentials functionality now works with Synchronize and Copy From URL actions. Update Credentials functionality is corrected to retain the existing Key Location value.