Platform Connector Updates: Enhancements and Bug Fixes

NetSuite

Bug fix

• When filtering while using the NetSuite SOAP connector, all custom fields are included in the filtering process, ensuring comprehensive data retrieval. 
• Error handling in the NetSuite connector prevents internal exception classes from appearing in error messages, improving user experience and system security.
• The ‘Update Job’ action now updates the specified custom field, ensuring accurate data management by sorting fields with ‘_id’ at the top of the list.

NetSuite Rest

Enhancement

• NetSuite Rest directly returns host names from NetSuite instead of using the account name as part of the API host, enhancing the connection setup.

Salesforce

Bug fix

• The Salesforce bulk upsert function ensures correct mapping of relationship fields when the “Use CSV column names as Salesforce field names” setting is enabled, ensuring accurate data updates. 
• Updated handling of newline characters in the JWT Platform Events Trigger has been implemented, allowing seamless use of real-time Platform Events triggers.

Salesforce Listener

Enhancement

• Error handling for the Salesforce listener has been improved. We’ve enhanced error reporting by replacing the use of the ‘Raven’ gem with ‘report_exception’ to capture Sentry errors. Additionally, we’ve updated the error message format to include ‘flow_id’ and ‘user_id’. This will provide more detailed information for error tracking and debugging.

SAP SuccessFactors  

Enhancement

• We have introduced a new feature that allows users to batch upsert records in SuccessFactors, enabling simultaneous updates or insertions of multiple records like PerPerson and EmpJob.

QuickBooks

Enhancement

• Support for Custom Fields in various sales-related actions and triggers has been added, allowing for a more comprehensive representation of objects and enabling updates to custom field values.

Workato Data Tables

Enhancement

• New batch actions have been implemented, allowing users to create, update, and delete records efficiently. 
• We have introduced ‘clear’ and ‘skip’ semantics in update and upsert actions, providing more control over data management by allowing users to nullify or maintain existing field values. 

SMS by Workato

Enhancement

• A limit of 25 SMS per day has been implemented, ensuring optimal performance and service quality. To learn more, visit our product documentation. 

Oracle Fusion

Enhancement

• Oracle Fusion Cloud now supports real-time business events as a trigger, enhancing integration capabilities with both Public and Custom Business Events.

Bug fix

• Users can now access the Learner Learning Records object in the Oracle Fusion connector trigger, due to enhanced support for more objects with different date fields.

IDP by Workato 

Enhancement

• Updates to the IDP by Workato Confidence score calculation improve performance and reliability, with better support for multi-level nested schemas.  

Bug fix

• JSON objects and lists in the IDP system now return keys instead of null values. And confidence scores for these fields are not left empty, even when their values are null. This includes fields such as the vendor GST number. This enhancement improves the overall data integrity and reliability of our IDP system.
• The OpenAI model has been updated and Structured outputs in API calls to OpenAI ensure responses adhere to the supplied JSON schema, maintaining schema integrity.

Workday 

Bug fix

• Termination events are now received after the effective moment, aligning with customer filters and ensuring accurate data. 
• The Workday Connector now displays all errors upon failure, providing an efficient and user-friendly experience.

Stripe

Enhancement

• Support for dual compatibility with both the existing extension and the new Stripe app, enhancing security and functionality.

Xero Practice Manager

Deprecation

• The ‘IsProspect’ field has been removed from the Xero Practice Manager, ensuring compliance with deprecation.

LinkedIn

Deprecation

• Usage of LinkedIn API version 202307 has been removed, ensuring compliance with LinkedIn’s latest changes. The following triggers and actions that utilized this API version have also been removed: New advertising form response, Get advertising form response by ID, Search advertising form responses. 

General

Bug fix

• Runtime validation ensures the ‘amount’ field is filled in for vendor-related actions, enhancing reliability for non-US locales. 
• System errors related to static streams without data are now correctly handled and the system will raise a BadInput error under these circumstances. This fix enhances the system’s error handling capabilities and improves overall user experience.
• JWT decoding errors have been addressed, ensuring correct processing of legacy API keys.  This issue was specifically related to the number of segments in the token, which was either too many or too few. To resolve this, we have added an exception to handle such cases

Security fix

• The chartkick gem has been sandboxed to reduce security risks, ensuring a secure environment.  
• The deprecated phantomjs has been replaced with puppeteer, improving security and performance. 

Enhancement

• Users can now bypass Workato’s default header capitalization, providing greater flexibility with case-sensitive servers.

Workato Data Tables

Enhancement

• The Data Tables documentation link has been updated, ensuring access to the latest information.

GitHub 

Enhancement

• Support for GitHub custom domains has been extended, enhancing authentication options and functionality. This enhancement is not just limited to GitHub app authentication but also includes OAuth and personal access token. We have also added the ‘site_admin’ scope for OAuth accounts as per the GitHub enterprise API documentation. The host URL in OAuth blocks will now change based on the input.

Webex Teams

Enhancement

• Token-Based Authentication in Webex Teams now seamlessly generates new tokens,  without any intervention, even when the previous token expires to ensure uninterrupted service. This applies to all actions, custom actions, and triggers. The enhancement also maintains backward compatibility with the OAuth authentication type.

RingCentral 

Migration

• RingCentral has announced the sunset of their sandbox environments and the introduction of developer accounts. To adapt to this change, we’ve removed support for sandbox environments in our OAuth apps. Please note that this change does not impact your existing developer account, access to production APIs, or any apps in production. If you have any questions or need assistance migrating to the new environment, please contact RingCentral’s Developer Support team.

SharePoint

Bug fix

• The “New row in SharePoint list” Trigger now provides the Attachment files array as a List data pill, simplifying subsequent steps.

BILL  

Bug fix

• The BILL connector has been updated to reflect rebranding and ensure access to the latest information.

Gmail 

Bug fix

• New Gmail Email Trigger feature picks up new jobs by using the ‘Received’ header as the primary timestamp. In cases where the ‘Received’ header is not present, the system will now fall back to the ‘Date’ header. This hybrid approach should ensure the New Gmail Email Trigger feature consistently picks up new jobs.

Airtable

Bug fix

• The Airtable adapter now converts empty strings to nil, preventing RuntimeErrors. 
• The new/updated trigger in Airtable now remains active and every poll will make a ‘get_fields’ API call to retrieve all the table fields ensuring continuous job generation for updates. 

Outlook 

Bug fix

• The Outlook New email real-time trigger has improved the detection and processing time of new jobs by adding a lifecycleNotificationURL during subscription , improving workflow efficiency.

Pipedrive

Bug fix

• The Pipeline datapill in Pipedrive now correctly matches the API response, ensuring accurate trigger filtering. We’ve added an additional field in the extended output schema with key `pipeline_id` to match the API response. This fix applies to new deals, new/updated deals, get object (deal), and update deal. Even if Pipedrive decides to update the getDealFields schema call to reflect `pipeline_id` in the future, our logic will handle it.

Lightspeed Commerce

Bug fix

• The Lightspeed Commerce Connector now uses the Base URL, improving functionality and reliability.

Google Sheets

Bug fix

• The Google Sheets connector now handles boolean or integer values by converting the values to string format before processing, ensuring smooth operation.

Amazon SES

Bug fix

•  Support for Amazon SES ‘Delete Suppressed Destination’ feature and users can now provide an email address to remove from the list, enhancing usability.

Amazon S3 

Bug fix

• The Amazon S3 adapter now handles various network errors, ensuring reliable server connections.