What's enhanced
Filter dashboards by application
Narrow down the list of running or completed flows to view only those that involve the applications you care about. This is supported in the Running and Completed flow dashboards. You will find this filter in the Flows view (EDI activity Dashboard) if you enable B2B Manager in your account. For more information, see Explore the Integration Dashboard" and "Understand the Dashboard - EDI Activity.
Recently used applications
Recently used applications are at the top in application drop-down lists, so it’s quick and easy to find your most recently used applications when creating new resources like connections, exports, and imports.
Celigo AI knowledge bot enhancements
We’ve made several updates to improve your experience with the Celigo AI knowledge bot.
-
You can now make use of the “copy” action when you’d like to take the bot’s response and make use of that data - perhaps for some sample JavaScript.
-
All code blocks also include an “expand” action that opens the code in a larger window to provide for better visibility.
-
We’ve also added a “regenerate” action, which may be useful to ask a question again - perhaps after more context has been established.
-
Finally, we’ve added a “reset conversation” action for when you want to establish a new context.
Job object details available via hooks
Hooks now allow access to the flow runtime “job object”, including job id, start time, step type (export, import, etc), and more. These details are particularly useful when you need to capture such details for tracking and reporting needs.
Expansion of Lambda support
We have expanded our stack support so that you can include languages beyond the existing Node.js, Java, and C#. The new “Other” option permits the use of any other language type in your Lambda function.
File provider connectors: CSV parsing enhancement
Snowflake bulk load does support variant columns. To enable, contact Celigo Support. After the migration is completed in January 2025, this is productized. For more information, see Import data into Snowflake.
Customer-reported bugs
-
IBM AS2 servers responded that Celigo MDN headers were invalid for 3PL requests
-
The dynamic lookup advanced field editor (AFE) incorrectly parsed “Amazon” as a handlebars statement instead of a string
What's new
Advanced Field Editor (AFE): Improved handlebars editing experience
We've improved the process for inserting fields and helpers in the middle of handlebars expressions. Now, when you select a field or helper from the drop-down list, the existing text will be preserved and shifted to the right, rather than being overwritten. This update ensures a smoother, more intuitive experience, allowing you to build expressions faster without the need for manual corrections.
You’ll also see automatic closing brackets when needed, saving you extra steps. This enhancement helps minimize errors and keeps your workflow efficient.
Drag and drop for branched flows
You can now drag and drop flow steps within branched flows, just like in linear flows. This update lets you easily rearrange bubbles without the need to delete and reconfigure them. All associated tools, such as mappings and filters, move along with the bubble, preserving your configurations.
Additionally, if you move a step out of a branch, the branch itself remains intact, maintaining its rules and logic. This enhancement reduces manual work, saves time, and simplifies the process of organizing complex flows.
Access execution details for enhanced analytics
You can now access key execution information throughout all AFEs in your flows, giving you the ability to enhance data records and improve your tracking capabilities. This new functionality allows for better reporting and analytics by providing insights into flow run details. With this update, you'll have greater visibility into your integration processes, enabling more efficient data analysis and decision-making.
Celigo AI: UX enhancements for resource descriptions and code editors
We’ve made several improvements to the Celigo AI interface to enhance usability:
-
Resource descriptions UX improvements
-
The description icon has been updated across the platform to prevent confusion with drag-and-drop functionality. This ensures a clearer interface, particularly in Flow builder and resource list views.
-
To improve readability, long user descriptions (over 5 lines) will now have a maximum height and a vertical scroll bar. This change keeps descriptions compact and easy to manage, even when they’re detailed.
-
-
AI editors in code assistants UX improvements
-
The input field for Celigo AI now has a white background to align with the rest of the product, clearly indicating where user input is expected. The response field has been changed to gray to differentiate it.
-
We’ve removed the “?” help icon next to the Celigo AI label, making it easier to focus on the main input field without distractions.
-
B2B Manager: Dashboard enhancements
We’ve introduced several key improvements to the EDI Dashboard in B2B Manager to enhance usability and data analysis:
-
Search functionality: A search box has been added, allowing you to search records by Document ID, Sender ID, or Receiver ID. Document ID is the default search field.
-
New filters: In addition to FA Status, you can now filter data by Doc Type, Direction, and File Type, with an easy option to clear filters and return to the full dataset.
-
Increased page size: The default page size has been increased from 50 to 100, reducing the need for excessive navigation across multiple pages.
-
Fixed column headers: Column headers are now fixed, so you can always see which field you are viewing as you scroll through your data.
These updates make it easier to search, filter, and navigate the EDI Dashboard, improving overall efficiency and clarity.
Note
B2B Manager is currently only available in North America, with plans to release in EMEA in the future.
Updated Help Center design
We’re rolling out a new Celigo Help Center theme to improve the navigation and presentation of content. Thanks to the feedback from our customers, it offers several enhancements, including…
-
Tree navigation of the entire Help Center in each article
-
A mini table of contents at the top right
-
Consistency with the Celigo brand refresh
We’re planning additional improvements, and we encourage your feedback and ideas in the Celigo Connective.
What's fixed
-
Errors were not reported at the flow level at the flow dashboard, even though they appeared for individual flow steps in Flow builder
-
Trace keys were missing for export data arrays
-
Stores couldn’t be deleted from the Shopify – NetSuite integration apps
Help center updates
What's new
Select fields to exclude before merging integration changes
When leveraging integration lifecycle management (ILM), you can now merge changes selectively by ignoring specific fields during integration pulls. This means you can promote changes from one integration to another without including environment-specific configurations like file locations. By choosing which fields to exclude, you can avoid conflicts and make sure only the necessary changes are synchronized.
Note
Currently, this feature supports exclusions at the field level. Plans to expand this are targeted for future releases.
Celigo AI: SQL queries for NetSuite JDBC connector, and SOQL queries for Salesforce connector
With Celigo AI enabled, simply type your query in natural language, and it will be converted into SQL or SOQL automatically, making the configuration process easier for users of all skill levels.
This update will save time and simplify the process of writing and understanding queries. Plus, Celigo AI will provide plain English descriptions of existing SQL or SOQL queries, making data management and analysis much more straightforward.
Enhanced typing experience for Windows users
Windows users can now enjoy a smoother typing experience across the platform, including text input for fields like flow step names, descriptions, and the handlebars Advanced field editor. Backend performance improvements have eliminated lag and freezing, allowing for a more fluid and responsive typing experience.
What's enhanced
Java language support for AWS Lambda stacks
AWS Lambda stacks now support the Java language. Previously, AWS Lambda stacks created on the Celigo platform only supported C# and Node.js. See Run operations on different servers in stacks for more information.
What's fixed
Some agents couldn't be deleted in environments with multiple agents.
New integrator.io articles
Updated integrator.io articles
What's new
Celigo AI for transformations
Designed to streamline and accelerate the development process across a variety of integration scenarios, Celigo AI for Transformations 2.0 will bridge knowledge gaps and significantly reduce the time required to build complex transformations.
Access the Celigo AI panel within the transformations window. Whether you are a technical expert or a business user, you can either simply provide a prompt or use native auto-transform functionality and receive assistance to complete your tasks efficiently.
Celigo AI for transformations excels in multiple transformation scenarios, including (but not limited to):
-
Rows to record: Transform multiple rows of data into a structured record.
-
Record to rows: Break down a single record into multiple rows.
-
Rows to rows: Convert rows of data to a different format or structure.
-
Field modifications: Modify specific fields within the source data to generate a new, transformed record.
Streamed responses from the knowledge bot
As soon as you ask a question, the Knowledge bot will start delivering its response in real time. You’ll get your answer in a dynamic, ongoing stream, keeping you informed from the first moment and making the interaction feel more like a human conversation.
Celigo AI support for Azure Synapse connector
Use Celigo AI to convert plain language into SQL queries, streamlining Azure Synapse connector configurations. Simplify import/export setups and boost configuration efficiency.
This enhancement allows a broader range of individuals to leverage data without the need for complex SQL logic, significantly improving productivity, minimizing errors, and accelerating data-driven insights.
Snowflake bulk load capabilities
Effectively manage larger datasets with Snowflake’s bulk load capabilities using local files, thereby reducing the time and resources needed for data transfers. By providing more control over the data ingestion process, as well as a more scalable approach to accommodate growing volumes of data, this feature makes it easier for engineers and database administrators to manage data workflows, while business users are able to access data more quickly for analysis.
Note
Snowflake bulk load via file does not support variant columns; please use batch inserts for these.
Filter “Your existing flow steps” by connection
Using the option “Optionally filter by connection,” you can narrow down flow steps based on their associated connections, making it simpler to find exactly what you’re looking for, especially when dealing with multiple resources tied to different applications.
We’ve also updated the user interface for more clarity and direction:
-
The label “Create from scratch” now reads “Create flow step.”
-
The note for your existing flow steps has been changed from “Clone an existing flow step from your account” to “Clone or reuse an existing flow step from your account.”
-
Just like the existing connection field, you can type the name of the connection in the filter field to quickly find what you need without scrolling through a list.
What's enhanced
Automatically recover rate limit errors for imports where oneToMany is set
Auto-recovery is now enabled for operations involving connections in exports, lookups, and imports, regardless of whether the one-to-many configuration is used. integrator.io will automatically detect and recover from these errors, minimizing downtime and reducing the need for direct user action.
This feature operates in the background, providing a seamless experience without any additional setup. You can continue with your tasks confidently, knowing that rate limits will be managed more effectively.
Windows Server 2012 R2 reaching end of support
Starting November 6th, 2024, the Celigo on-prem agent will no longer support Windows Server 2012 R2. This decision aligns with Microsoft’s plans to end support for this operating system, details of which can be found in Microsoft's Lifecycle Policy announcements.
To ensure uninterrupted service and compatibility with the latest Celigo integrations, it is imperative that users of Windows Server 2012 R2 upgrade to a more current version of Windows Server before November 6th, 2024. The Celigo Product Team will be sending direct reminders via email over the coming months, and if you require assistance with the upgrade process, don’t hesitate to contact Celigo support or your trusted CSM.
What's fixed
-
Async helper XML errors from the Amazon – NetSuite integration app weren’t reflected in debug logs.
-
The XML parser Advanced field editor failed to detect invalid XML characters when the Parse strategy was set to Automatic.
-
The Clone Amazon – NetSuite integration app template corrupted the copy and dropped record types, connections, and flow mappings.
-
Manual token-based auth connections to NetSuite did not allow you to set the required environment setting.
-
Filter scripts couldn’t use flow-level custom settings.
Help Center updates
New integrator.io articles
Updated integrator.io articles
What's new
Celigo AI Knowledge Bot
To further enhance your experience in integrator.io, this chat window provides instant product support. Describe a flow you would like to build, ask a question, or try an example query, and the Knowledge Bot will provide a concise summary of the information you’re looking for. It will also link to related Help Center articles, all within a maximum response time of 10 seconds.
Receive real-time assistance directly within the platform, greatly reducing the time and effort required to browse external resources and accelerating your path to meaningful results.
For more information, see Understand the Knowledge bot.
Natural language search
To streamline your resource creation process, simply describe your use case and let Celigo AI present you with the most suitable flow step options, pulling from both your existing resources and the Celigo Marketplace. This feature reduces the time and effort required to find the perfect match for your desired outcome, improving accuracy and enhancing overall efficiency.
For more information, see Retrieve flow steps from existing integrations or Marketplace using a prompt.
What's enhanced
Auto-mapper UX enhanced
The auto-mapping functionality has been updated to streamline your mapping processes even further. Now, when configuring mappings, you can choose from three direct options to auto-map all fields, a single specific field, or multiple specific fields, ensuring quicker setup without the need for manual prompts.
Additionally, Mapper 2.0 has been refined to automatically select all child fields when a parent field is chosen, and vice versa, while preventing changes to already mapped destination fields for clarity and control.
For more information, see Mapper 2.0 (Auto-map destination fields section).
Celigo rebrand
Celigo recently completed a rebrand, and integrator.io is reflecting some of those changes. We updated our logo and revised the global left navigation to reflect the new palette. The navigation’s architecture remains unchanged, so there are no interruptions to your daily operations.
What's fixed
-
When changing the connection on an import to Amazon in the Amazon Seller Central – NetSuite integration app, the async helper failed to populate the Result export and Status export
-
In the NetSuite Item to Amazon Product Add/Update flow of the Amazon Seller Central – NetSuite integration app, the display name for a custom category could not be updated
-
Flows connecting to a database via the on-premise agent intermittently paused with the error “Blacklisted Host has been closed.”
Help Center updates
New connectors
Updated connectors
Updated endpoints
New integrator.io articles
Updated integrator.io articles
Prebuilt apps articles
What's new
Build faster with prebuilt flow steps
Leverage the collective wisdom and efforts of both your organization and the wider community by implementing existing resources into your flow configurations. Rather than creating a resource from scratch, you can now take advantage of one of the many relevant prebuilt options presented based on your identified source.
Clone an existing flow step from your integrator.io account, or implement a popular resource from the marketplace to quickly achieve meaningful results from your integrations.
What's enhanced
Advanced Field Editor (AFE) layout preference persistence
To improve the user experience, Advanced Field Editors (AFEs) will now save your preferences and apply the last-known layout for each editor. This enhancement eliminates the need to adjust your layout preferences every time you access an editor, allowing you to focus more on your work and less on setting up your environment.
Visually simplified sheets exports
This enhancement simplifies exporting from sheet-based applications like Google Sheets and Smartsheet by allowing you to easily visualize and parse headers as columns, with data displayed in key:value format. Additionally, responses generated in an array of arrays format are automatically converted into a more user-friendly array of objects format.
This update enables seamless integration of sheet data into downstream processes, reducing the time and effort required. It facilitates the development of more efficient business processes and provides you with more control over how data is parsed and utilized.
Selective export execution in JSRT
The functionality to execute individual exports within a flow, previously released in the UI, is now extended to JavaScript runtime environments (JSRT).
What's fixed
-
Messages related to user activation, invitation, and password validation are improved for better readability
-
Upon submitting an idea in the Celigo Connective, you are not required to reconfirm your email address
-
Then the value in a custom setting of type Date and time couldn’t be saved when skipTimezoneConversion was set to “false”
-
For an export retrieving XML data with Next page URL pagination, the last page URL was ignored
-
Handlebars expressions were unable to access values within the JSON object for imports that used the one-to-many mapping option
-
The batch limit on an import can now exceed 1,000 records, allowing flows with numerous smaller items to avoid timing out
-
XML paths containing a colon (:) couldn’t be previewed before import
-
The Build relative URI Advanced field editor (AFE) displayed different handlebars values on preview than those sent
What's new
Faster error resolution with user assignments and notifications
Eliminate the need for manual coordination – and enhance productivity and operational flow – by allowing users to assign and tag errors. You can quickly identify and prioritize critical errors, speeding up resolution, by directing issues to the right team members.
-
Assign open errors to specific users, facilitating targeted review and swift resolution
-
Email notifications will be delivered to integrator.io users, as well as to email addresses not yet registered to integrator.io, ensuring immediate awareness of new responsibilities
-
Filter errors by assignment to quickly identify errors assigned to a particular user, others, or those left unassigned
-
Admins and account owners can enable or disable the “Invitations” feature
-
The error message, “A tag with this name already exists,” will alert users when attempting to create a duplicate tag
What’s new in Celigo AI
Instant revert: Click to return to the last saved template
Boost workflow efficiency in handlebars, SQL, and script Advanced field editors (AFEs) by swiftly discarding recent and unwanted changes. This quick reset feature allows you to revert to your last saved template with one click, simplifying the editing experience and reducing the risk of unintentional changes.
Continuous visibility of AI-generated resource descriptions
AI-generated resource descriptions will persist for an entire session in integrator․io. Scroll through Flow builder, edit exports, and perform other key tasks, while easily referencing the resource description, ensuring easy access to vital information without disrupting your workflow.
AI-powered filter rule creation
Streamline filter rule creation using Celigo AI, which turns plain language prompts into precise filter rules, simplifying complex workflow development.
Additionally, the Explain filter rules button saves time and facilitates knowledge sharing by providing AI-generated explanations of configured filter rules.
Enhanced data mapping: Support for Object and Object array fields
Celigo AI now automatically maps both Object and Object array data field types, along with their child elements, to destination fields, ensuring comprehensive support for relevant use cases.
AI-generated SQL queries for database connector configurations
Streamline Postgres SQL and MySQL connection configurations by asking Celigo AI to transform plain language commands into SQL queries. Enter commands to simplify import and export setups and enhance the efficiency of the configuration process.
User experience improvements
-
The Celigo AI panel now defaults to a closed state, streamlining the interface
-
Expand the Celigo AI window vertically with a click-and-drag action for a tailored view
-
Error panels within AFE windows are now collapsible, enhancing workspace flexibility
Agent support for Linux-based operating systems
Expand your connectivity options with Linux-based agent support. Download and install agents on Linux servers directly from integrator․io, enabling seamless integration with on-premise applications. This enhancement, driven by customer feedback, facilitates connections to several applications hosted on Linux environments.
The following Linux operating systems will be supported:
-
Redhat Enterprise Linux RHEL 7 or newer
-
Fedora 24 or newer
-
CentOS 7 or newer
What's enhanced
Enhanced keyboard shortcuts for AFE auto-suggestions
Enhance writing handlebars expressions in AFEs with upgraded keyboard shortcuts, designed to work smoothly as you type. These improvements make using the auto-suggestions more intuitive, significantly reducing friction and boosting efficiency.
-
Tab: Automatically adds the first matched field or helper as you type, moving the cursor to the next argument within the expression and keeping the auto-suggestions open for additional arguments.
-
Ctrl/Cmd + Space: Improves interaction, focusing on “All” or the first matched item based on your input.
-
Hover-over definitions: Displays definitions for helpers after a brief hover period, eliminating the need for mouse interaction.
-
Function keys: Utilizes “Fn + up/down” keys to switch focus between typing and the suggestions overlay, enhancing usability without relying on a mouse.
Platform performance enhancements for an improved user experience
Significant code optimizations ensure faster page loads and smoother interaction across the Celigo platform, accommodating a large number of integrations without compromising on speed or responsiveness.
-
The home page (in list view) has been revised to display application names rather than logos, enhancing response speed and allowing more options to be visible at once
-
When viewing lists of your imports and exports, server queries have been optimized with a paginated response system
-
On the Dashboard, flow grouping has been removed to ensure that only essential data requests are made
Important updates for NetSuite users
Role permissions required for any role with access to the Celigo NetSuite bundle
To allow for better control over which user accounts can access sensitive data, applicable accounts must have full access to the Custom Record Entries permissions.
If you have created a NetSuite connection with a custom role in integrator.io, you must add the required permission to the role in NetSuite. To better understand the process of adding the permission in NetSuite, see Add a permission to NetSuite custom role.
Compatibility with NetSuite 2024.1 release
To ensure compatibility with the NetSuite release version 2024.1, Celigo platform capabilities have been fully tested across all integration-related applications and business requirements.
Enhanced user experience in HTTP connector form
Simplify your configuration process by easily choosing between a prebuilt or HTTP connector. Simply enter your Base URI in a standard HTTP connection form, and if available, a prebuilt connector option will become available. Switch between the prebuilt and HTTP connectors directly in the create or edit connection panel, giving you full control over which applications you connect with. This update makes setting up your configurations simpler and your experience smoother. Whether you're dealing with multiple applications that share identifiers or need to adjust a connection, you now have the flexibility to ensure your HTTP integrations work exactly as you need them to.
What's fixed
Customer-reported issues resolved
-
In a one-to-many import with a lookup to find existing records, the insert/update operation was failing to create records in Salesforce
-
Syncing orders from Shopify to NetSuite failed to complete when a single long-running job created hundreds of messages
-
GraphQL export preSavePage hook previews were not displayed
-
SFTP server file operations were incorrectly logged and handled during test mode runs
What's new
Celigo AI delivers descriptive resource summaries, intuitive code assistance, and intelligent auto-mapping
Resource descriptions
With the help of Celigo AI, you can instantly generate plain language descriptions of imports, exports, and flows. Gain an immediate understanding of an integration’s business purpose instead of spending hours deciphering complex flow logic. Especially beneficial for those less familiar with the platform, this feature offers a concise breakdown of business logic, including transformations, mappings, and more.
-
Easily understand the logic of a resource created months ago, avoiding tedious configuration checks
-
Seamlessly transition integrations when a team member departs without being dependent upon manual documentation efforts
-
Provide leadership teams with high-level summaries without diving into intricate details
-
Transfer integrations to and from services and partner teams smoothly, maintaining confidence that users with varying degrees of platform knowledge will easily understand the resources
Code assistance
Celigo AI empowers more users to become proficient builders with an intuitive code assistant that enables non-technical users to craft code in various advanced field editors (AFEs) for SQL statements, handlebars, and JavaScript using plain language prompts. Additionally, the “explain selection” feature provides a clear explanation of any highlighted section of existing code, instantly bridging knowledge gaps.
Auto-mapping
Reduce manual effort and increase task efficiency by leveraging Celigo AI to automatically populate mappings for destination fields. Existing mappings will remain untouched while any remaining fields are intuitively populated, greatly reducing time to value by enabling users to complete configurations more quickly.
Guided experience in writing handlebars expressions
Remove guesswork and reduce cognitive burden by allowing the Celigo platform to take the lead in writing handlebars expressions. The cursor will move through the expression and highlight one parameter at a time while offering suggested values in a dropdown menu. Auto-suggestions can be escaped or invoked again with keyboard shortcuts at any time during the writing process, allowing you to determine how much guidance you would like to receive.
Generate OpenAPI specifications for webhook listeners
As previously introduced for exports, imports, and data flows, OpenAPI specification generation is now available for listeners. With API specifications and documentation readily available, consumers of your APIs can leverage the endpoints efficiently for their business needs without gaining full access to the source code.
New connectors
Find complete instructions and popular integration scenarios – along with connector resource enhancements – at
What's enhanced
NetSuite WSDL version support updates
In alignment with NetSuite’s recent changes to their list of supported WSDL versions:
-
WSDL version 2023.1 is now supported
-
Any NetSuite connections configured with WSDL version 2016.2 (deprecated) must be updated to avoid flow interruptions
Test mode enhanced
-
View test run results for blob exports and imports
-
View test run debug logs without having to enable debugging
-
View test run results for dynamic lookups configured within NetSuite mappings to verify the lookups are being correctly evaluated
User experience improvements
-
The left navigation menu has received some design changes: the Help and Account sections can now be found in the top right of the screen
-
The option to unmerge branches now has its icon:
-
Various design adjustments have been made to optimize the connection creation experience in the flow builder
-
The errors page/list can now be opened from the Home screen or Flow builder page when all runtime and test mode errors are part of the same flow step
-
Restrictions have been put in place to ensure that running flows cannot be disabled
-
When creating a connection, a search for a specific API type will return results for all related connectors
What's fixed
Customer-reported issues resolved
-
Nonstandard response code from SAP Ariba listeners was interpreted as an error, marking some orders as failed
-
FTP exports failed when multiple concurrent calls attempted to perform file parsing within a short period
-
Export previews failed to properly display extended characters, resulting in missing data
-
Salesforce imports with conditional mappings in the item sublist were creating empty lines when attempting to update records
-
NetSuite JDBC exports sharing concurrent connections crashed when very large volumes of data were requested
Support: Help Center updates
New connector articles
Migration connector articles
Revised connector articles
New integrator.io articles
Revised integrator.io articles
New integration app articles
Revised integration app articles