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, facilitating easy access and navigation for data-driven workflows.

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 ensures secure and reliable OAuth 2.0 connections by validating tokens and preventing input errors during the connection process.

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 is a cloud-based service that enables users to securely store, manage, and retrieve large amounts of data, with flexible access control options.

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 is a comprehensive platform that automates HR, financial, and other enterprise processes, improving workflow management and operational efficiency.

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 is a cloud-based spreadsheet tool that allows users to create, edit, and collaborate on spreadsheets in real-time, streamlining data management and reporting tasks.

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 artificial intelligence into automation workflows, enabling smarter automation and providing recommendations for building and improving recipes.

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 facilitates the seamless exchange of electronic data between businesses, enabling efficient and secure communication of business documents.

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 is an accounting software that automates financial management tasks, including invoicing, payment processing, and expense tracking, for small and medium-sized businesses.

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-based content management and file-sharing platform that offers secure storage, collaboration, and sharing of documents across teams and organizations.

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.