Product Release Notes - Version 4.2.01h (27-08-2024)

This update focused on security, connectivity, and new technologies. It added wildcard support for SSL certificates, enhanced Azure SQL and ODBC compatibility, and introduced GraphQL (preview) and Google BigQuery (beta) connections. REST and CRM connectors also gained expanded schema and data-model support for greater flexibility.

Upgrade Note: If you require any of the new features or improvements introduced in this release, please contact our Support team to schedule the upgrade to the latest version. Our team will assist you with the upgrade process and ensure a smooth transition.

🔒 Security & Connection Enhancements

Wildcard Support for SSL Certificates
Connections using SSL now support wildcard certificates. For example, a certificate issued for *.shopify.com will securely validate any subdomain such as rapidi.shopify.com. This improvement increases flexibility and simplifies secure connections to multi-tenant or subdomain-based services.

🗄️ Database Connectivity

Improved Azure SQL Support
The MS-SQL connector now offers enhanced compatibility with Azure SQL. All core operations — read, write, update, and delete — are fully supported, including correct handling of special characters. SSL encryption is also fully supported to ensure secure communication.

Custom Quote Character for ODBC
ODBC connections can now specify a custom quote character using the configuration variable ODBCQuoteChar.
This option provides greater flexibility for databases that use non-standard quoting conventions.

🌐 REST & API Enhancements

Flexible ReadDesign Host Support
The REST handler now allows ReadDesign operations from a separate host. This enables storing JSON schema definitions externally — for example, in a GitHub repository — while maintaining a secure connection to the customer’s service.

Support for Nested JSON Schema Elements
REST connections now support nested (sub-element) structures within JSON schemas. This allows more complex data models to be defined and read correctly across various API integrations.

🔄 CRM & OData Enhancements

Additional ServiceAppointment Fields
The CRM OData ReadDesign function now includes additional fields for ServiceAppointment objects, providing a more complete data model and improving synchronization coverage.

🧩 New & Experimental Features