Our engineers are hard at work daily to make Workato better! View the latest updates to our platform below.
Dec 23 - Jan 08
SAP On-premise connector:
What's new: The new SAP On-premise connector that can connect to almost any SAP system on-premise or on a firewall protected server (including AWS, IBM, etc.). The supported SAP versions include SAP ERP ECC 6.0 and later, SAP CRM, SAP SRM, SAP SCM, and any other modules compatible with the NetWeaver platform.
This first release supports asynchronous IDoc. Support for synchronous RFC will be coming soon.
Google Sheets: Search rows limit increases to 50,000 rows
Search rows action now can return up to 50,000 rows of result, up from the previous limit of 200 rows.
Salesforce: Batch operations
Apart from support for Salesforce bulk operations, Workato has included support for Salesforce batch operations, which make use of Salesforce’s Collections API.
These actions allow the creation and update of up to 2,000 records at a time. Users should make use of these operations when they are creating or updating small batches of Salesforce records, or if they wish to perform multiple operations without using Bulk API.
ServiceNow: New trigger and action
Search records using query: New Search records using query action allows the use of ServiceNow queries to filter the records you want. Supports up to 50,000 records retrieved per batch.
Scheduled record search trigger: New Scheduled record search trigger allows execution of query on a specified schedule. Query results will be returned in batches of records. Also supports up to 50,000 records retrieved per batch.
Increased search action limit: The actions Search records, Search records (User) and Search records using query can now be configured to return up to 50,000 records (up from 100).
Okta: Scheduled trigger
What's new: The new Okta Scheduled trigger allows a scheduled search instead of real-time exit.
Dec 11 - Dec 22
Google sheets: New actions
Update rowactions based on new Google Sheets API v4. Enable searching by simple field mappings and update rows in a sheet by row number.
New/updated rowtrigger now monitors up to 10,000 rows, increased from the previous limit of 1000 row.
SQL Server: Automatic chunking for upsert action
Redshift: Escape special characters for connection
Anaplan: More output fields for import and export action
Wrike API migration On 19th December 2018, Workato's Wrike connectors have been updated to use Wrike's API v4.
This update will disconnect all your existing Wrike connections. All recipes using Wrike connections will be stopped on 19th December 2018.
What you need to do:
Reconnect all Wrike connections in your account to use the updated connector. You can complete this action on or after December 19th, 2018.
Nov 25 - Dec 10
New Recipe UI
What's new: The new recipe UI introduces a flowchart building interface that clearly displays the flow of logic through the entire recipe. Usability issues that have been raised have also been addressed in this design. Users should not only find this iteration of the recipe editor more user-friendly but also see new features that make their recipe building experience more efficient.
Learn more: Read more on Workato's New Era Update and upcoming features here: https://product.workato.com/2018/12/04/workato-new-era-update/
New Google AI connectors
What's new: New Google AI connectors have been added to the list of apps Workato supports. These new connectors enable a variety of content analysis capabilities that bring a new level of intelligence to recipes and automations.
- Google Vision: Read text from images and scanned documents. Example use case: Read text from an uploaded driver's license and create a contact in Salesforce.
- Google Speech-to-text: Allows conversion of a short speech-to-text transcript.
- Google Text-to-speech: Allows conversion of text to synthetic voice audio.
Google Translate: Translate text between languages.
Example use case: call recordings / voice messages from foreign customer --> use Google Speech-to-text to transcribe to text --> use Google Translate to translate to English --> use Google Text-to-Speech to convert to audio, which customer support reps can listen to.
ServiceNow: Subdomain routing
Context In development lifecycles, teams typically clone their sandbox instances for deployment into production. In the process, webhooks in the sandbox instance also get copied over into production. As a result, webhook events in production gets sent to the sandbox recipes, causing an error.
What's new: Subdomain routing for webhooks To fix this, we’ve introduced subdomain routing. When an instance is cloned, the subdomain will change based on the instance it is in. This will ensure that webhooks in the cloned instance will be routed to the correct production recipe. To enable this behavior, simply stop and restart your ServiceNow recipes.
Nov 11 - Nov 25
HTTP: OAuth2 client credentials grant
What's new: The HTTP connector now allows connections using the OAuth2 client credentials grant flow. Using the client credentials grant, the client can request an access token using only its client credentials. This is usually used when the client is requesting access to the protected resources under its control.
Oct 25 - Nov 10 2018
Microsoft Dynamics CRM: Deleted object trigger
What's new: The new trigger checks for deleted objects, e.g. deleted leads, every 5 minutes. Visit the object view page -> Customize Entity -> Enable Auditing to use this trigger.
ADP: Support for custom actions
What's new: The ADP adapter now allows custom actions. Select the 'Custom action' option on the action dropdown to build one with a HTTP request.
ADP: Unmask sensitive data
What's new: All data is masked by default with ADP. The new toggle allows users to unmask sensitive information, which will be returned in the response.
Netsuite: Custom fields for journal entries and line items
What's new: Add custom fields that are returned in the output datatree in the 'Custom fields' textbox. This is enabled on both journal entries and journal entry line items.
Box: Support for OAuth scope selection & new scopes
What's new: When creating a Box connection, users can now select the OAuth scopes to request for. This enables limiting the connection's permissions to only the relevant ones for recipes connected to Box. We also added 2 new scopes:
Manage enterprise propertiesand
Manage retention policies. This allows buildings more powerful custom actions!
Box: Upload large file
Upload fileaction now allows large file of Gigabyte size. Previously it was limited at about 20Mb.
Workbot: Message actions
What's new:: Message actions on Slack allow users to perform actions on any existing Slack messages. The new message actions capabilities on Workato allows users to make use of this new feature to build even more powerful Slack workflows.
Oct 16 - Oct 25 2018
Audit log replication
What's new: Audit log replication can now be done with a Sumo Logic HTTP Source. Admin events such as user login/logout, recipe start/stop, connections made/disconnected are enabled as events that can be logged.
New adapter: Anaplan
What's new: The Anaplan adapter is now released in beta. Anaplan is a cloud-based business planning and performance management platform, used by many enterprises. With this connector, you can download/upload files and import/export data in Anaplan.
Salesforce: Search records in bulk using SOQL (Batch)
What's new: Related objects can now be used in searches with the Search records in bulk using SOQL (Batch) action. Simply select the related join objects wanted. Then, select the fields you're interested in using in the recipe via the Fields input field.
Oct 06 - Oct 15 2018
Oracle DB: Execute stored procedure action
What's new: The Oracle Execute stored procedure action now supports stored procedures nested in packages.
Redshift: Batch actions
What's new: Insert and Upsert row actions in the Redshift connector will now allow increased speed and data throughput when moving a large number of records to Redshift.
Active Directory: Support for auxiliary class attributes
What's new: In Active Directory, some object classes may have statically linked auxiliary classes with their own attributes. With this enhancement, Workato supports all auxiliary class attributes and object class attributes.
Salesforce: Support for OAuth scope selection
What's new: When creating a Salesforce connection, you can now select the OAuth scopes to request for. This enables you to limit your connection's permissions to only relevant permissions for your integrations.
Sept 25 - Oct 05 2018
Find more details on this month's updates in our blog post.
Data pill enhancement
Context: We've greatly improved visibility on data pills when they are mapped into fields so that building and reviewing recipes can be done in a glance.
What's new: All data pills have been revamped to include the application logo and step it comes from.
Added delete functionality for lookup tables
What's new: We have added the ability to delete all data from lookup tables without the need to delete the table entirely. Access this by clicking on the
...menu icon on the last column of your lookup table.
Added delete functionality for custom adapters_schema
What's new: We have also added the ability to remove custom (SDK) adapters. Users can do so from their individual custom adapters pages.
Quick Base: Bulk import action
What's new: We released a new Quick Base bulk import action using CSV file. Users can now easily import a large amount of data into Quick Base with this addition. Documentation is available on: Quick Base action: Create and update records in bulk from CSV file
Microsoft Dynamics CRM: Picklist lookup support
Context: It can be hard to retrieve the lookup values of picklists in Microsoft Dynamics CRM. In the API response, typically only the internal values of the picklist selection are returned.
What's new: The new feature in our Microsoft Dynamics CRM connector now gives you both the picklist option labels as well as the internal values for your selected picklist option. These fields show up as additional fields for you to use in the datatree.
Wrike: New/updated task trigger can now filter by task status
What's new: You can now filter new/updated task trigger events by task status. This allows you to trigger recipe actions only on specific task statuses.
Wrike: Secondary connector
What's new: You can now connect a secondary Wrike connector in your recipes. This makes it possible to sync folders, tasks and projects across 2 different Wrike accounts.
Wrike: Seach folders/projects action can now filter by custom field
What's new: You can now filter search results of a Search folders/projects action by using custom fields. To use this filter, add the optional field 'Custom field list' in a Search folders/projects action.
Sept 4 - Sept 24 2018
Group data mapping
Context: In a large enterprise database, there can be hundreds of fields in every table. When there are a daunting number of fields to map or if many of your field labels match with the name of pills, it can be a chore to do them one-by-one.
What's new: Map fields automatically with the new group data mapping tool in every action. Click on the icon next to the 'comment', 'clone' and 'delete' icons on the right hand side on every recipe line to bring up the group mapping wizard. Simply choose the fields to map and the data source to get started.
Read the documentation on group data mapping to learn more.
New control for date/time picker
What's new: A new grid icon is available on the right of all date/time fields. Clicking on this icon will bring up a calendar date picker followed by a drop-down list of times. Use this new function to quickly configure dates and times. After selecting your chosen date or time, you may still edit this by typing in the field directly.
For our more experienced users, please note that clicking on the calendar icon on the left of the field will no longer work.
Workday: Trigger change
Context: Previously, large worker objects in Workday caused jobs to timeout.
What's new: A new option under Advanced configuration called 'Return reference only' available in Workday triggers allows the job to return only references and transaction logs, minimising the trigger data size to prevent timeouts
HTTP connector: Secondary connector
What's new: Previously, only 1 HTTP connection was allowed per recipe. The new secondary connector is useful when users need to connect to multiple REST endpoints. To use the HTTP secondary connector, access the adapter dropdown menu and click on the 'HTTP secondary' option.
Salesforce new action: Salesforce bulk query using SOQL
Aug 17 - Sept 3 2018
Find more details on August's updates in our blog post.
Note: We have upgraded our services to TLS 1.1 or higher as of August 21, 2018. Please view this article for more details: Stronger security with TLS 1.1 update.
Compatible input/output schemas
Context: Previously, all mapped fields in later recipe steps are cleared when the user changes the trigger or actions.
What's new: All actions and triggers now have compatible input and output schemas. The user can change a trigger or action and all mappings will remain valid if the new trigger has the same fields/pills.
Recipe IQ: Powering intelligent recipe building
Context: The Workato platform uses sophisticated machine learning algorithms based on billions of integration events and hundreds of thousands of integration use cases to assist users in building effective integrations and automations.
What's new: During recipe building, users may notice the
Powered by RecipeIQtag, which indicates that our AI algorithms are intelligently suggesting the best actions, data pills or fields for use.
Job report: Timing tab
What's new: The timing tab for every step in a recipe has been exposed. Users can find it next to the 'input' and 'output' tabs in the individual job reports. This tab shows the time taken for every action and can be used in debugging recipes.
New connector: On-Prem Command-line Scripts
What's new: Workato's
On-prem command-line scriptsconnector allows you to run whitelisted command line scripts in your private network with an on-premises agent. Find out how to set a profile up on the on-premises profile documentation.
HTTP & Custom HTTP connectors
Context: Previously, users had to parse the HTTP response as text, then use the JSON parser as the next action to parse out the response.
What's new: The HTTP adapter now supports JSON arrays and objects.
On-premises files connector major update
What's new: Several new triggers and actions have been added to the connector, and the old versions of those triggers and actions have been deprecated. This update will not affect your current running recipes. We will continue to support the deprecated triggers and actions, and your current recipes will keep running as normal.
Please read the following article for more information: On-prem file connector major update - Sep 2018.
Jira & Jira Service Desk (cloud-only)
What's new: Added support for basic authentication with API tokens, in anticipation for the upcoming deprecation of basic authentication with password by Atlassian. Read about this in our recent announcement.
What's new: Added support for new/updated vendor trigger.
Aug 4 - Aug 16 2018
- Database connectors (Oracle, Redshift, MySQL, SQL Server, PostgreSQL) changes to required fields pick lists in triggers. Read the article here for more information.
- PostgreSQL: Select rows using custom SQL
- This action lets you select rows based on a custom SQL query. Rows that are returned from the query will be returned as the output of this action. Read the documentation here.
- Google Sheets: 150 new 2-min recipes has been published and are available for use. Find them here.
- Workbot enhancements:
- Custom help (on the connection level). You can now define what users see when they DM ‘help’ to Workbot.
- New post command reply & post message enhancements
- Allow custom message color by supplying hex code
- Allow message menus to be displayed before buttons
- Original_message added to trigger output
- Enhancements to post command reply only
- Replace original
- Delete original
- New custom HTTP action for Workbot
July 19 - Aug 3 2018
Find more details on July's updates in our blog post.
- Recipe lifecycle management: Added support for message templates
- Shopify: Inventory API changes. These changes will result in your recipes breaking if you are using Shopify connector actions. Please view this document for more information.
- New connector: JDBC (in beta)
- Workbot for Slack: Post Message & Post Command Reply actions — added support for multiple attachments.
- Eventbrite: Now supports Eventbrite Music
- Salesforce: New get document by ID action
- Workday: Enhancements to fields with attributes and repeated fields. View this documentation to learn more.
July 06 - July 18 2018
- Recipe lifecycle management: Added support for shared schema import/export
- New recipe editor toolbar: The new toolbar allows you to easily access the save and start buttons on screen when building and editing your recipes
- Files by Workato: New Transform image file action, allows the conversion of image files to .jpg and .png files and image resizing
June 22 - July 05 2018
Find more details on June's updates in our blog post.
- Static and dynamic list input modes
- Recipe lifecycle management: Imported connections will appear in the same connection folder
- Transliterate formula added: Replaces non-ASCII characters with an ASCII approximation, e.g.
- New HTTP wizard to guide user in building an HTTP action
ItemGroupstandard object now available in Search action and trigger
- Added support for special characters
June 08 - June 21 2018
- New recipe creation wizard
Added Propel as a new connector.
- Object created
- Daily object review
- Object created/updated
- Custom action
- Create object
- Get related objects
- Search objects
- Update object
- Added the ability to search custom records by custom fields
- Added support for message object in New Classification trigger
- New action: Decrypt file with PGP
- New events action has been enhanced to allow "others" option in the Event type dropdown. This allows users to enter a specific Event name.
- The call operation action now includes 'get integration systems' as an operation.
June 01 - June 07 2018
- New Action: Delete Record
- Deprecated Actions: Get incident details by ID, Get user details by ID, Assign user to incident. Please use the new actions: Search records or Update records if you need these actions.
- Attributes array has been added to the output for lead batch activity trigger
- New Action: Get Eligible Project leaders from Replicon