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

This Universal Extension provides the capability to monitor data (files/directories) on various major Cloud Providers including AWS, Google Cloud, Microsoft Azure. This integration 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 S3Google Cloud StorageMicrosoft 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: Action Monitor objects creation Monitor objects change - change based on modification time Monitor objects deletion Options Trigger On Existence - available for Action Monitor On Create.  Advanced filtering capability for objects to be monitored. Universal Event Event published upon single object creation, holding information about the new object Event published upon single object change, holding information about the updated file, including the latest object size and modification time. Event published upon single object deletion, holding information about the deleted object. Event published upon single object existence, holding information about the object. What's New v1.0.1:Fixes:Fixed an issue where events were not published with the action Monitor On Create when Trigger on Existence was enabled.Fixed an issue with the appearance of some warnings at the beginning of the extension execution that happens on later versions of the Universal Controller.Fixed an issue when updating credentials.