Changelog

Introducing API Proxy Transformation, which helps modernize your APIs and increase the robustness of your API integrations with:

• Request and response transformation capabilities: Configure request and response transformations with drag-and-drop functionality.
• Schema Mapping & Key-Value Pair Mapping: Define schemas, map data, and apply formulas for seamless data transformation between systems.
• Conditional Response Mapping: Route API responses based on HTTP status codes with conditional logic to improve error handling and flexibility.
• In-Line Formulas: Manipulate data using formulas and expressions.

Benefits include faster integrations, reduced development effort, enhanced compatibility, and secure data transformations.

This feature is in private release. Contact your Customer Success Manager to enable this feature.

You can now store multiple values in one column, enhancing the build experience of Workflow Apps. When creating a new column type, a new option - "Multi-value" - is now available for selection. Multi-value column types support use cases such as records tagging. Each table can have up to 20 multi-value columns and each multi-value column can store up to 20 values. 

Learn more about multi-value column types in our Workflow Apps documentation.

We’re excited to announce that batch actions have been introduced to the Data Tables Connector! This highly requested update empowers users to create, update, and delete records in batches, reducing complexity in recipe design and improving task efficiency. Key updates include:

• Batch Actions for Data Tables: Users can now perform batch operations to create, update, and delete records, enabling more streamlined workflows.
• Improved Efficiency: Batch actions eliminate the need for looping, helping reduce task consumption and enabling broader use cases.
• Limitations: Each batch supports up to 200 records, ensuring consistency with existing data-fetching limits.

We are excited to announce we now provide schema validation for API endpoints to improve data integrity.

This new functionality validates API requests for presence of fields and their field type for API recipe endpoints, allowing users to 'filter out' or reject API requests that don't meet pre-defined constraints.

Learn more in our API platform documentation.

PyPDF has been added to the Python connector library suite. This powerful addition significantly enhances document processing capabilities and opens up new possibilities for automation.

Learn more in our product documentation.

We’re thrilled to share this month’s updates from the Workato community for October 2024! This month, we’ve added 19 new or updated connectors, including including new connectors like LINE for messaging automation, AppDirect for subscription management, Datacom Easipay for payroll processing, and Astrix for cybersecurity. Additionally, we have worked on some of our existing connectors, such as Google Vertex AI, AWS Secrets Manager and AWS Security Hub with various improvements and bug fixes. Curious about the updates? Check out the full details here!

For October 2024, SOAP Tools transitioned to XML Tools by Workato, NetSuite aligned with the latest SuiteTalk WSDL, and QuickBooks resolved tax field issues. SharePoint improved file handling, while HubSpot and Amazon SNS enhanced OAuth and IAM configurations. Curious about these updates? Check out more details here!

The latest release includes on-prem FTP support plus SAP changes. Updates include:

• FTP: Added support for on-premise FTP.
• SAP: Provided detailed error messages for known SAP JCo failures.
• SAP: Uses the latest schema for RFC, BAPI and IDoc without restarting OPA.
• SAP: Extended timeout for updating outbound IDoc status to ensure stability on poor network connections.
• SFTP: Improved logging for troubleshooting purposes.
• MSSQL: Fixed issue when connecting to SQL Server with Windows Authentication.
• Logging: Fixed repetitive Request has Been Canceled errors in logs.
• Security: Updated JRE to 21.0.5+11, Jetty to 12.0.14, Spring to 6.1.14, and other libraries according to OWASP recommendations.

See the OPA release notes for this and previous updates to OPA.

API custom authorization allows you to enforce an additional set of authorization claims on API endpoints. Workato’s API Gateway evaluates the custom authorization expression after an API request is made to an endpoint and authenticated with a valid token. This feature adds an extra layer of security by enabling you to create additional role-based access control, locale restriction, and business logic rules.

This feature is in private release. Contact your Customer Success Manager to enable this feature. Learn more in our API Platform documentation.

We’re excited to announce some new additions and enhancements to our Embedded API endpoints!

New endpoints:

• Get usage (v2): Retrieves usage metrics for specified customer workspaces within a defined timeframe.
• List On-prem Groups: Retrieves a list of all On-prem Groups in a customer workspace.
• List On-prem Agents: Retrieves a list of all On-prem Agents in a customer workspace.
• Get details about an On-prem Agent: Retrieves detailed information about an On-prem Agent within a customer workspace using its unique ID.
• Get connections based usage: Retrieves connection-based usage metrics for specified customer workspaces and can be aggregated across customer workspaces.

Updated endpoints:

• Add member to customer workspace: Add a member to the specified Embedded customer workspace.
• Create customer: Create a new Embedded customer.