Platform Connector Updates: Enhancements and Bug Fixes

Workato Data Tables

Enhancement Bug fix

Workato Data Tables allows users to manage and store structured data within the Workato platform, enhancing data handling and navigation.

Enhancements:

• Added a direct link to the selected data table in the UI for all actions and triggers, enhancing user navigation and making it easier to access the relevant data table.

Bug fixes:

• Resolved an issue where users could not create a record with a null file object. Now, the file column is ignored if the filename is null or empty during record creation, ensuring smooth operation.

Auth Code Grant Validation

Enhancement

Auth Code Grant Validation improves the reliability of OAuth 2.0 connections by ensuring proper validation and preventing input errors.

Enhancements:

• Implemented connection validation for the OAuth 2.0 Auth Code Grant flow.
• The connection is now only established after validating the base URL and the acquired tokens, preventing the creation of invalid connections that could cause recipe errors.

Google Cloud Storage

Enhancement

Google Cloud Storage enables users to manage data in the cloud, with enhanced support for restricting access to specific storage buckets.

Enhancements:

• Added the ability to restrict access to a specific bucket in the GCS connection setup. This feature is particularly useful for users with restricted access to certain buckets, providing more granular control.

Oracle Fusion Cloud

Enhancement Bug fix

Oracle Fusion Cloud automates HR and financial processes within Oracle Fusion applications, streamlining workflows with added functionality.

Enhancements:

• Added missing fields ‘PrimaryFlag’ and ‘AddressUsageType’ to the form feed trigger, enhancing the data available in Oracle Fusion Cloud workflows.

Bug fixes:

• Fixed an issue where the “PersonNameId” field in the “HCM Contacts” object was not exposed. The update now includes child object support, making the “PersonNameId” field visible and usable for updates and upserts on the “HCM Contacts” object.

Google Sheets

Bug fix

Google Sheets automates spreadsheet workflows, including updating and managing rows, with improved handling of sheet names and row input.

Bug fixes:

• Fixed an issue where the “Update Multiple Rows in a Sheet” action failed when the sheet name contained spaces. The solution was to skip URL encoding for the sheet name to prevent conversion of spaces to %20.
• Resolved an issue where input intended for a specific sheet (e.g., “P1”) was incorrectly directed to the first sheet. The fix involved enclosing the sheet name in single quotes to ensure proper recognition as a sheet name instead of a range.

AI by Workato

Enhancement

AI by Workato integrates AI capabilities into automation workflows, with updated behavior for enabling AI in child workspaces.

Enhancements:

• Updated default behavior to disable AI by Workato in child workspaces when it is provisioned in a parent workspace.
• Child workspaces will have access to the AI feature, but it will be disabled by default, requiring manual enablement if needed.

EDI by Workato

Enhancement

EDI by Workato enables the seamless exchange of electronic data between businesses, improving data interoperability and automation.

Enhancements:

• Introduced Parse EDI action, enabling the interpretation of EDI data.
• Added Generate EDI action, allowing users to create EDI data for seamless electronic data exchange.

QuickBooks

Enhancement Bug fix

QuickBooks simplifies accounting and financial management by automating tasks such as invoicing, payments, and tracking expenses.

Enhancements:

• Added input support for the DefaultTaxCodeRef field, including a toggle text option for easier input with hints for allowed values.

Bug fixes:

• Fixed an issue where the Update Payment action was overriding the total amount. Users can now specify and override the total, preventing excessive payment amounts.

Box

Enhancement

Box is a cloud content management and file sharing service, offering secure ways to store and collaborate on documents.

Enhancements:

• Enabled support for custom OAuth profiles, enhancing authentication flexibility and user experience.

Microsoft Sharepoint

Bug fix

Microsoft SharePoint allows teams to collaborate and manage documents, lists, and workflows efficiently within an organization.

Bug fixes:

• Fixed the New Event Trigger to work for all rows in a list, correcting an issue where it only worked for the first 100 rows.