Keep up with the latest updates we’ve made in Workato.

May 6, 2024

Manage concurrency strategy with new API platform settings

With this new settings menu, you can control how to handle requests during periods of high concurrency - to either queue requests and set queue sizes, or reject requests when the limit is reached. Additionally, our concurrency documentation has been updated to provide more insight on how concurrency works, and how to use these new settings to manage your concurrency strategy.

Apr 30, 2024

Enhancements to working with Snowflake’s internal stages

Two new enhancements are available to simplify and streamline working with Snowflake's internal stages:

  • Upload to internal stage: Provides a dedicated solution for uploading files to Snowflake's internal stage, simplifying the process of transferring data into Snowflake for further processing or analysis
  • Bulk load from stage: Allows for loading files directly from Snowflake's internal stages into a table.
Apr 30, 2024

Long actions for databases

Long actions for databases give users the ability to handle long-running SQL queries and exports of datasets. The timeout limit for long actions is 120 minutes. New actions include:

  • Run long query using custom SQL, for executing queries that require extended processing times
  • Export query result, for bulk extraction from databases, without worrying about row limits

Long actions for databases are currently available for Snowflake, PostgreSQL, MySQL, and Oracle.

Apr 30, 2024

Addition of Workato data tables as new data source to query

Queries can now aggregate and transform data from Workato data tables, in addition to applications and files, and fetch the query results as CSV to be used in downstream actions.

Apr 30, 2024

Process and transform Excel files using SQL queries

SQL queries can now process and transform Excel files, providing the ability to aggregate and query across both CSV and Excel data types.

Apr 30, 2024

Handle CSV data more efficiently with enhancements to to FileStorage

To further enhance our data integration solution, we have updated and added bulk and batch CSV actions and triggers for Workato FileStorage to assist in processing, configuring, and monitoring data.

With FileStorage actions:

  • Store a CSV file along with its column data type schema in a directory (Create file action)
  • Append CSV lines to an already existing file with column data type validation (Append to file action)
  • Fetch CSV lines from a file in batches from an existing file (Get CSV lines from file action)

With FileStorage triggers:

  • Trigger and fetch any data type as a byte stream once it is available (New file bulk trigger)
  • Extract complete CSV file data in batches (New CSV file batch trigger)
  • Monitor a particular CSV file and fetch new lines appended to the file (New lines in a CSV file batch trigger)
Apr 30, 2024

Custom column filtering for Workflow Apps portal

When in a Workflow App, you can now filter by any of the columns visible to your role within the app, and bookmark a preferred view based on the filters set.

Examples include filtering to expenses or procurement requests above a certain dollar threshold, or narrowing down to onboarding employees in a particular department.

Apr 30, 2024

Audit log streaming email error notifications

When audit log streaming fails, Workato now sends email notifications to the workspace admin of your account and to all users designated in the error notifications email list. For Embedded accounts, email recipients are determined based on the workspace where audit log streaming is enabled.

Email notifications will be sent for the following error types:

  • Voluntary disconnections by a user
  • Involuntary disconnections, when Workato detects we no longer have access
  • Destination-specific errors
Apr 26, 2024

Specify personal date and time format from profile settings

You can now choose between 12 and 24 hour and between m/d/y and d/m/y formats from your profile settings. Available formats are:

  • Dec 31, 2024 1:00 PM (%b %d, %Y %l:%M %p)
  • Dec 31, 2024 13:00 (%b %d, %Y %H:%M)
  • 31 Dec, 2024 1:00 PM (%d %b, %Y %l:%M %p)
  • 31 Dec, 2024 13:00 (%d %b, %Y %H:%M)

The option you choose here is reflected across your workspace, but will not affect date and time format for other users in this workspace.

Apr 24, 2024

Formula generation added for Recipe Copilot

For workspaces with Recipe Copilot enabled, you can now use natural language to ask Copilot to generate a formula to accomplish your goal. Copilot evaluates what combination of data pills and/or formulas will best satisfy your request, before offering you a suggestion to accept or revise as needed.

This functionality receives data about your current recipe, which may include metadata about custom fields in your systems, but does not receive any job data.