Changelog
Keep up with the latest updates we’ve made in Workato.
Community Connectors: What’s new in April
We've released 8 new connectors this month, including AWS Bedrock for AI innovation, Kintone for team collaboration, iChris for HR automation, and JobAdder for recruitment efficiency. Plus, we've polished up 13 other connectors like Acumatica, GraphQL and Freshsales with enhancements and bug fixes. Curious about the updates? Take a peek at our full update here.
Addition of RecipeOps trigger for alerting when API client exceeds policy limit
The new Recipe Operations triggers for policy quota and rate limit violations are instrumental in giving administrators visibility and the ability to proactively monitor their client's API usage. With these new triggers, administrators can now receive active alerts about violations, and move quickly to address.
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.
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.
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.
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.
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.
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)
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.
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