Integrate.io logo

Integrate.io Release Notes & Product Updates

An overview of the latest updates and product improvements. Got a product update or feature you'd like to see supported? Let us know - support@integrate.io

May 2026: New Connectors, Smarter Notifications & Expression Functions

ETL & Reverse ETL
May's release cycle focused on expanding connector coverage, adding text and date normalization functions to the expression editor, and tightening notification control across workspaces and packages.

Introducing Service Hook Filters
Service hook notifications can now be scoped to specific packages and workspaces, so users receive alerts only for the work relevant to them. The hook filter editor includes a scope picker, improved loading for large accounts, and accurate match counts during search - making it practical to manage notifications even in accounts with hundreds of packages.

New Zendesk Connector
The ETL platform now supports Zendesk as a source, letting users extract tickets, users, and organizations via OAuth - with automatic token refresh and support for both full and incremental load. Teams that rely on Zendesk for customer support workflows can now pull that data directly into their pipelines without manual exports.

New Features
  • INITCAP(): A new expression editor function capitalizes the first letter of each word in a string and lowercases the rest, covering a common text normalization step that previously required custom transformations.
  • NormalizePhone(): Standardizes phone numbers into E.164 format, handling a wide range of input formats and providing configurable behavior for invalid numbers - removing the need for manual cleaning logic in pipelines that ingest contact data.
  • NormalizeDate(): Accepts datetime inputs and returns the date portion, validating against multiple formats so users can reliably extract dates from mixed-format fields without writing custom expressions.
  • NormalizeLanguage(): Normalizes language codes in the expression editor, expanding the set of standardization tools available when working with localization or audience data.
  • Excel Sheet Selection for Large File Ingestion: When the "ingest large Excel file" option is enabled, users can now specify which sheet to load, supporting workbooks where the target data is not on the default sheet.
  • Inline SFTP Key per Connection: Each SFTP connection can now carry its own Ed25519 key pair inline, giving users connection-level key management without relying on shared credentials.
  • Create New Option in Cluster and Connection Pickers: Dropdowns for cluster and connection selection in the Job form and component editors now include a "Create new" option, letting users add a resource without leaving the current context.
  • Package Variable Persistence: Saving package variables now immediately persists them to the database and triggers draft validation, so newly added variables are recognized in the package without requiring an additional save cycle.

Improvements
  • The Mouseflow connector has been updated to move the website ID input from the connection form into the source component, aligning configuration with where it is most relevant.
  • Gmail source now extracts full email bodies, replacing the previous snippet-only behavior and supporting a dedicated "Email body" field option for ingesting content without attachments.
  • The Snowflake connection form has been updated from Account identifier to Account locator, reflecting the current Snowflake authentication model and reducing configuration errors.
  • Azure REST API pagination is now supported for the management.azure.com endpoint, enabling reliable ingestion of paginated Azure resource data.
  • AI error summaries now anchor on the deepest root cause in stack traces rather than the first exception, producing cleaner, more actionable explanations for Salesforce timeouts, S3 access errors, schema mismatches, and cluster failures.
  • The Package Designer now opens the relevant component editor when a user clicks on an error in the Package Errors panel, reducing the steps needed to navigate from an error to the fix.

Fixes
  • Component previewer row ordering now matches schema preview ordering.
  • Sort and Window components now return rows in the correct sequence during preview.
  • Window component no longer adds "stitched::" prefixes to field names in the component previewer.
  • Limit component previewer now works correctly.
  • Window and Union component validation no longer incorrectly disables save and preview buttons after input updates.
  • Universal OAuth connector reconnection for Google OAuth now works correctly - missing parameters that previously broke the request have been restored.
  • Facebook Ads destination now shows the correct operation type options for the Customers object when reopening a saved configuration.
  • AI Assistant popup no longer appears behind the expression editor and other modals.
  • Expression Console search in the functions popup now returns correct results.
  • Multi-line CSV parsing in Cloud Storage and SharePoint sources now works correctly when a text qualifier (" or ') is set.
  • Google Sheets source headers containing commas or newlines no longer shift downstream columns, and duplicate-header columns now render their values correctly.
  • Renaming a workspace no longer incorrectly updates the Last Modified date on every package inside it.
  • Salesforce proxy traffic now routes through the correct region for proxy-enabled accounts.

Performance Enhancements
  • The hook filter editor now uses lazy loading for package and workspace lists, reducing memory usage and keeping the UI responsive in large accounts.
  • JSON extraction functions have been optimized to handle a wider range of data types more efficiently, reducing processing overhead for pipelines that work with complex nested structures.

Keep exploring what shipped this month - there's a lot in here, and we'd love to hear what's making a difference for your team.

4 days ago

April 2026: Real-time Package Validation & New Connectors

ETL & Reverse ETL
April's release cycle focused on tightening the package authoring loop, expanding connector coverage across CRM and analytics tools, and hardening the platform's secure-access options.

Real-time Package Validation
Package Validation now runs continuously inside the Package Designer, with a status section in the toolbar that reflects the current state of the package as you edit. Auto-validation triggers on component changes without requiring a save, and a new two-tier classification separates 'to configure' warnings from genuine errors so users can see what is actually blocking a run versus what is still in progress.

REST API Connections via SSH Tunnel
A new connection type routes REST API traffic through an SSH tunnel, letting users reach private APIs that sit behind a firewall without exposing them to the public internet. The connection is configured through the standard form and works with existing REST API source, removing the need for custom networking workarounds when integrating with internal services.

Refreshed Package Designer
The Package Designer now ships dedicated components for each database and file storage connection type, replacing the generic Database and File Storage entries on the components list.

New Connectors
  • Stripe Source Connector: Pull payments, subscriptions, customers, and invoices directly from Stripe into the warehouse, giving finance and revenue teams a single source for billing analytics, churn modeling, and reconciliation against the general ledger.
  • SugarCRM Source Connector: Bring accounts, contacts, opportunities, and custom modules from SugarCRM into downstream pipelines, so revenue teams can build pipeline forecasts, attribution models, and customer 360 views without exporting from the CRM by hand.
  • ServiceNow Source Connector: Move incidents, change requests, and service catalog data from ServiceNow into the warehouse, letting IT and operations teams report on SLA performance, ticket volume trends, and team workload alongside the rest of the business.
  • Kantata Source Connector: Pull project, resource, and financial data from Kantata into the warehouse, giving services and PMO teams the inputs they need to track utilization, project profitability, and forecast capacity.
  • Klaviyo Source Connector: Ingest campaign, flow, and subscriber engagement data from Klaviyo, so marketing teams can attribute revenue back to specific sends and join email behavior with web and purchase data already in the warehouse.
  • Mouseflow Source Connector: Bring session replay and heatmap analytics from Mouseflow into pipelines, letting product and growth teams join behavioral signals with conversion data to understand where users drop off and which experiments are working.
  • Crisp Source Connector: Ingest conversation, contact, and helpdesk data from Crisp, so support and product teams can analyze response times, surface recurring issues, and tie customer questions back to product usage.

New Features
  • Postgres JSON Column Support: Postgres destinations can now write directly into JSON columns, removing the need to serialize JSON payloads as text and parse them downstream.
  • Postgres Staging Schema Configuration: Users can now configure staging tables to be created in the destination's target schema instead of the public schema, avoiding permission failures on locked-down databases.
  • REST API String Unwrapping: The REST API source now offers an option to unwrap extracted string values, returning plain strings instead of JSON-quoted strings for downstream consumption.
  • REST API Destination Request Throttling: A configurable sleep interval between requests has been added to the REST API destination, letting users stay within rate limits on target APIs without external throttling.

Improvements
  • The AI Assistant has been migrated to a new engine, providing in-product help that is based on our live product documentation pages.
  • Source component field aliases now consistently replace spaces and special characters with underscores during schema import, producing predictable column names regardless of the upstream field naming convention.
  • The cURL import parser in the REST API source and Expression Editor now recognizes the `--url` flag, so commands copied from a wider range of tools parse correctly without manual editing.
  • The Data Previewer now shows a human-readable timestamp tooltip when hovering over Unix datetime fields, removing the need to convert epoch values manually while inspecting data.
  • Test Connection error messages on connection forms now persist until explicitly dismissed instead of disappearing automatically after seven seconds, giving users time to read and act on the diagnostic.
  • Job error logs and component preview error output have been trimmed to remove stack traces and internal noise, surfacing the operator-relevant message instead of a wall of text.
  • The File Source components now truncate oversized data previews to keep the application responsive when working with very large files.

Bug Fixes
  • Fixed an issue in the SFTP source where seeking inside SFTPInputStream caused records to be silently dropped from the output.
  • Fixed Excel ingestion so that blank cells are treated as null instead of empty strings, matching expected behavior in downstream type-sensitive operations.
  • Fixed `_WORKFLOW_PACKAGE_LAST_SUCCESSFUL_JOB_SUBMISSION_TIMESTAMP` to return the parent workflow's last successful timestamp for sub-packages, where it had previously returned empty.
  • Fixed an issue where Dynamics and SharePoint connectors did not refresh access tokens automatically, causing long-running jobs to fail mid-run.
  • Resolved a scheduler issue where DST offsets were applied incorrectly, shifting scheduled runs by an hour at transition boundaries.

Performance Enhancements
  • Excel file previews from SFTP sources have been optimized to handle larger files without timing out, restoring the previewer's usefulness on multi-megabyte spreadsheets.
  • The File Uploader has been reworked to handle large-size files reliably, eliminating failures that previously occurred above certain size thresholds for some file types.

Alongside this release, our fully updated documentation is now live, with refreshed content and improved accessibility throughout. For quick lookups while you work, use the Ask Assistant button at the top of the UI to surface answers without leaving the tool.

Have a look at what shipped this month and let the team know which improvements are landing well in your day-to-day work.
about 1 month ago

March 2026: New Connectors, Editor Upgrades & More

ETL & Reverse ETL
March's release cycle focused on expanding connector coverage, deepening the Expression Editor's capabilities, and closing reliability gaps across the pipeline.

Introducing the Reworked Expression Editor
The Expression Editor has been redesigned to make building expressions faster - new copy and insert buttons let you add any expression directly, no manual typing required. Clicking any function now opens a detail panel on the right showing its full description, parameters, and usage - no more hunting through documentation. A parameter legend below the syntax line makes it clear at a glance which inputs are required and which are optional, and related functions are now surfaced contextually to help users discover the right tool for the job. We also added a dedicated DateTimeConverter, removing the need to manually locate, input, and convert datetime fields when working with date expressions. A built-in cURL import rounds out the update, letting users utilize pre-build Postman API calls without leaving the editor.

Introducing NetSuite REST API Support
The ETL platform now supports NetSuite via its REST API using SuiteQL, giving users a modern, query-based alternative to the JDBC connector for accessing NetSuite data. This month also includes a JDBC driver upgrade from version 8.10.136.0 to 8.10.184.0, improving compatibility and stability for existing NetSuite JDBC connections.

Introducing the Universal OAuth Connector
The Universal OAuth Connector now supports HTTP Basic Authentication as part of the OAuth 2.0 flow, enabling connections to providers that require this handshake. Automatic token refresh has also been implemented.

Introducing the Native Shopify Source
The native Shopify source component now supports both full load and incremental loading, with pre-defined objects aligned to the approach used by the HubSpot connector. The underlying OAuth connector issue that previously caused Shopify authentication failures has been resolved as part of this work.

New Connectors
  • Gmail Connector: Users can now ingest CSV and Excel attachments directly from a Gmail inbox using service account authentication, with support for both full and incremental load modes and automatic metadata extraction.
  • Google Sheets Connector: A new bidirectional connector lets users read from and write to Google Sheets using service account authentication, supporting both source and destination use cases within the same job.
  • Constant Contact Connector: Users can now connect to Constant Contact via OAuth 2.0, fetch contact objects and email campaigns, and use dynamic field discovery during schema import.
  • SharePoint as a Destination Component: SharePoint can now be used as a write destination within the package designer, in addition to its existing role as a source.

New Features
  • Schedule Webhook Notifications: Users can now receive service hook notifications for schedule lifecycle events - creation, activation, and deactivation - keeping external systems in sync with job schedules.
  • Import cURL from Postman: The REST API source component now includes an import cURL button, allowing users to paste a cURL command directly from Postman to pre-populate the request configuration.
  • Save and Validate Option: A Save and Validate option has been added to the Save button dropdown in the Package Designer, allowing users to trigger validation without leaving the editing context.
  • File Storage Header and Data Row Customization: Users can now specify which row contains headers and which row data begins during CSV and Excel file imports, handling files with non-standard layouts.
  • Previewer Error Detail: The Previewer now displays specific error log output instead of a generic error message, making it easier to diagnose preview failures.

Improvements
  • Schema preview in source components now supports up to 800 fields, up from 500, giving users a more complete view of wide tables.
  • Search inputs have been added to the connections dropdown and the components list in the package designer, reducing navigation time when working with large connector sets.
  • The SharePoint destination editor consolidates the document library and folder path into a single field, with clearer labeling and alignment with the source component layout.
  • The REST API source component now auto-detects and suggests the correct JSONPath after schema load, reducing manual configuration for nested JSON responses.
  • The SFTP connector now supports Ed25519 key pairs for public key authentication and has been upgraded to handle modern OpenSSH servers that require ETM (Encrypt-then-MAC) algorithms.
  • The schema importer timeout has been increased from 30 to 60 seconds, reducing failures on slower or larger schemas.

Bug Fixes
  • Fixed multiple expression editor issues: backdrop clicks closing the underlying modal, the popup reappearing after background dismissal, flickering tooltips, unreliable autocomplete, and incorrect display on smaller screens.
  • Fixed a bug where the Curl() function was not routing through proxy servers, causing preview failures for API endpoints with IP whitelisting.
  • Resolved UTF-8 encoding corruption when ingesting Korean, Chinese, or Japanese characters via the REST API source and the Curl() UDF.
  • Fixed HubSpot source issues where number fields were incorrectly typed as Float instead of Double, and the incremental load date variable was set incorrectly.
  • Fixed a Salesforce source issue where previewing objects with hundreds of fields produced HTTP errors.
  • Fixed an issue where global variables were not applied correctly during component preview, and resolved a package validation failure for File Storage sources using Parquet files.
  • Fixed an issue where error logs in Job Details were truncated, and resolved an OAuth popup that remained open after authentication completed.

Performance Enhancements
  • Salesforce schema fetching now uses concurrent API calls, reducing wait times when loading objects with large field sets.
  • Database queries underlying dataflow exports have been optimized, resolving timeout errors for large packages.
Thanks for using the product - keep the feedback coming and let us know what you'd like to see next!
2 months ago

February 2026: AI Assistant, New Integrations, and Improved CDC

ETL & Reverse ETL
We are excited to share our latest updates, which include new features, improvements, and bug fixes to enhance your experience.

Introducing AI Assistant
  • Get instant, context-aware support with our new AI Assistant, now integrated directly into the platform. This feature provides a seamless way to troubleshoot, explore features, and get real-time guidance without leaving your workflow. You can access the assistant directly from various components via a dedicated popup or activate it instantly using keyboard shortcuts, making it easier than ever to get help exactly when you need it.
New ServiceTitan Integration
  • Seamlessly connect to ServiceTitan with our new integrated solution, featuring a dedicated Connector for streamlined credential management and a powerful Source Component for high-performance data retrieval. This update allows you to efficiently fetch ServiceTitan objects and fields while optimizing your workflow. By centralizing connection management and data processing, this integration ensures a more stable, transparent, and reliable data pipeline.
Introducing File-Based CDC & Query Mode
  • We’ve upgraded our Change Data Capture (CDC) Database Source Component with advanced File-Based options, providing a more robust framework for high-integrity data synchronization. And we’ve introduced Query Mode support for file-based snapshots, giving you the flexibility to use custom queries to define exactly which data is captured during the snapshot process.
New Features
  • Added support for the new GPT-5.2-pro model for AI transformations, giving you access to advanced reasoning capabilities and improved output quality.
  • Enabled a new option to generate one CSV file per input Excel file, ensuring clarity and organization in your data exports.
  • Introduced case-insensitive file matching for ZIP paths, making it easier to manage file retrieval without worrying about case sensitivity.
  • Enhanced Facebook Ads integration to utilize v24.0, providing improved metrics for user engagement activities.
  • Implemented pagination for Xero Journal endpoints, ensuring all journal records are retrieved accurately.
Improvements
  • Refined handling of cursor pagination for Monday.com data retrieval, ensuring more reliable data fetching without infinite loops
  • Improved validation behavior in forms, ensuring that users receive accurate feedback in real-time.
  • Refined mobile view responsiveness, allowing for a better user experience on smaller screens.
  • Updated the UI to clarify configuration for custom authentication headers.
Bug Fixes
  • Fixed validation issues in database source components, ensuring accurate field validation across various modes.
  • Corrected minor alignment issues and improved tooltip visibility for interface elements.
Performance Enhancements
  • Optimized edge management functionality, improving the overall efficiency of data handling processes.
Explore these updates to take full advantage of the new features and improvements designed to enhance your workflow.
3 months ago

January 2026: Unified API Authentication and New File Ingestion Tools

ETL & Reverse ETL
We're excited to share the latest updates and improvements made in January 2026. Discover new features and enhancements designed to improve your experience with our products.

Introducing Universal OAuth Connection
  • We are proud to introduce our new Universal OAuth Connection Framework, a core architectural upgrade designed to standardize and secure how our platform interacts with third-party APIs. This unified system streamlines the integration process, providing a more reliable and consistent authentication experience across all supported services.
Upload your files directly as Source
  • We’ve launched a new File Upload Component to streamline the ingestion of local data. This tool allows you to upload files directly to a linked storage environment and immediately utilize them as a data source.
New Features
  • Dynamic variable substitution is now possible in the File Mover component, enhancing your workflow by allowing variables set at runtime to replace static values, improving script adaptability.
  • Pagination support has been added for multiple components, including NetSuite REST queries, Netradyne, Momentify and Infusion APIs, enhancing data retrieval efficiency when working with larger datasets.
Improvements
  • Expanded support for the Lead object, enabling more comprehensive Hubspot CRM data synchronization.
  • Added support for .xlsm file types, allowing for the ingestion of macro-enabled Excel workbooks from SharePoint.
  • Resolved metric discrepancies across all reporting objects in Ads v22 integrations.
  • Mobile responsiveness has been improved with UI adjustments that ensure a better viewing experience on smaller screens.
  • Search functionality has been enhanced to clear filters automatically when navigating, making your experience smoother and more intuitive.
  • Various UI/UX improvements have been made across components, including improved visibility for success messages and a more streamlined editor interface.
Bug Fixes
  • Various issues related to component management in the REST API have been resolved, optimizing functionality.
  • Fixed alignment issues in mobile views and resolved bugs that impacted cached connections.
  • Corrected minor issues in query handling and enhanced input validations across the board.
Performance Enhancements
  • Optimized data retrieval processes and improved pagination strategy performance, resulting in faster data access and better user experience.
Explore these updates and enjoy a more efficient and user-friendly experience with our products!
4 months ago
Loading more updates...