2021 release notes

Support for Base64-encoded, Gzip-compressed stringsThis functionality has been requested by customers to solve real-world integration challenges. For example, eCommerce businesses can now extract shipping labels from Amazon Seller Central and bring better visibility to their Warehouse & Customer Support teams via other systems, such as an FTP server or NetSuite File Cabinet.

New connectorsBuilt-in connectors are now available for Mixpanel and SAP S/4HANA Cloud.

Revised connectors

Salesforce API version 52.0 is now supported – you can export and import newly introduced sObjects, such as Return Orders.

In addition, the Freshservice, Mavenlink, Miva, SAP Business ByDesign, SAP SuccessFactors, Shopify, and Square connectors have been updated according to the vendors’ latest APIs.

Additional extended characters allowed in requests

Universal HTTP connections now include support for ISO-8859-1 character set encoding in exported data.

* This feature relies on the integrator.io bundle for NetSuite v1.19.1.0, which was released on October 19, 2021 and will be applied to customers’ Production accounts in phases throughout the following few weeks. The release is immediately available for Sandbox accounts, and you must manually upgrade the bundle in your NetSuite Sandbox Environment. (In compliance with NetSuite policies, Celigo cannot automatically update bundles in Sandbox accounts, only in Production accounts.)

Error Management 2.0 (EM 2.0) standardization for all accounts

Celigo will begin including EM2.0 by default for all new accounts. If you’re not already running EM2.0, you should become familiar with the improved error-handling capabilities and its new user experience.

Account-level dashboard for Error Management 2.0

In accounts upgraded to Error Management 2.0, you can use a new dashboard to:

Deprecation of integrator․io legacy user interface (UI)

Since the current UI was introduced in 2020, there has been an option to Switch to legacy UI on the user avatar at the upper right of every page. Customers who were more familiar with that interface or, on occasion, unable to perform a task in the new UI had the option to continue developing integrations in the legacy UI. With this release, we are removing the option to switch back to our legacy UI, to mark the beginning of the final stage of legacy UI deprecation. If an issue is encountered where there is a need to switch back to the legacy UI, we strongly encourage you to file a support ticket, so that we can provide assistance with resolving the issue.

Parsed records include filename metadata

Each export that adds records to a flow’s data by parsing a file (such as XLSX or JSON) will also add a fileName field to that record. Then, you will be able to check that value later, making it easier to troubleshoot errors in the case where your flow contains records added from multiple source files.

The fileName was previously available only for “blob” files (downloaded in an export).

NetSuite listeners (real-time exports) built on SuiteScript 2.0

When you build a NetSuite listener , you can choose to set the NetSuite API version to SuiteScript 1.0 (using the current NetSuite bundle [20038]) or SuiteScript 2.0 (beta). Among other advantages, SuiteScript 2.0 offers faster bulk updates and better token security.

New connectors

Built-in connectors are now available for Freshservice, Looker, Omnisend, PandaDoc, Paylocity, OrangeHRM, PagerDuty, Quickbase, SAP ByDesign, SAP SuccessFactors, and Zenefits.

In addition,

New vendor-specific EDI templates

integrator.io is now able to export and import the following electronic data interchange (EDI) definitions:

New and enhanced templates

Since the last release, we’ve built a lot of great Marketplace templates for you to jumpstart your integrations, including:

In addition, some of the more popular Quickstart integrations templates have been updated with this release:

Drag-and-drop transformation rules

Now you can easily reorder transform rules by dragging and dropping the fields just like you can when defining import maps. Simply create or modify a transformation, add transform rules, and rearrange the fields using drag and drop.

Usability improvements for identifying existing records

When you configure an import, the setting previously labeled Existing data ID is now called How would you like to identify existing records?. In addition, the available options and workflow for each option have been improved to streamline configuration.

More intuitive options for saving and closing

The buttons available at the bottom of each page have been updated to reduce confusion. The Save & close button now appears only if you have unsaved changes on the page, and integrator․io now indicates when saving is in progress.

Ability to sort and group content when using a file provider

If you export files that contain multiple rows for a single order, you'll want to check out the enhanced parsing capabilities in integrator․io. When creating or modifying a file provider transfer step, you can now set additional parse file options. The new options enable you to configure how records are sorted and grouped. You can specify one or more fields to use for sorting records and select the sort order. After sorting options are applied, integrator․io also applies any groups you have defined. When you define groups, you can specify one or more fields to use for grouping records together.

Error Management 2.0 enhancements

With this release, EM2.0 has become the standard, full-featured error-handling solution for all customers:

Completely revised HTTP & REST API user experience

We’ve revisited and noticeably improved the usability in every setting (form field), as well as rewritten all of the help bubble () content, for each HTTP & REST API…

These changes apply to the “universal” HTTP & REST API applications, as well as many of the options for built-in connectors to apps with these underlying technologies.

While you will notice more descriptive labels for the fields in existing flow resources – in slightly different groupings, all your current settings will remain unchanged.

Revised connectors

We’re continuing to improve the built-in API connectors and keep up with the providers’ features:

BETA: Amazon Selling Partner API (SP-API) support

To transition from the planned deprecation of Marketplace Web Service (Amazon MWS) Orders, Reports, and Merchant Fulfillment Network (MFN) API endpoints, integrator․io is now enabling support for basic connectivity to SP-APIs.

Amazon SP-API is the next-gen suite of API-based automation functionality for Amazon selling partners, offering a number of improvements from Amazon MWS, such as modernized, JSON-based REST API design standards, OAuth 2.0 selling partner authorization using Login with Amazon, and a test endpoint.

NetSuite WSDL updated to include 2020.2

integrator․io now supports the latest NetSuite WSDL release (2020.2) along with all WSDL releases for the past three years. You can select the version when creating or modifying a NetSuite connection.

New listener Execution context

When creating a listener for NetSuite for a real-time export, you can now select “Web Application” as an Execution context.

Hat tip: Special thanks to active customer Lovesac for the feature request, as well as additional help with testing.

Customer-reported issues resolved

The following articles have been added to Celigo integrator.io documentation:

The following topics have been substantially revised based on customer feedback, changes from this release, and ongoing quality efforts:

New vendor-specific EDI templates

integrator․io is now able to export and import the following electronic data interchange (EDI) definitions:

Marketplace tiles without templates or Integration apps no longer empty

The integrator.io Marketplace recently was upgraded to include a tile for every supported connector. In those cases where prebuilt integrations for the connector are not yet present, the category was empty. They now display next steps.

SQL query limit expanded to 128 KB

Some customers were negatively impacted by the previous limit of 32 KB. Expanding the limit to 128 KB resolves problems associated with large SQL queries.

View reports to audit records in a flow

A new Tools > Reports page allows you to analyze flow events – success, errors, and ignored items – to view the trace keys of the records that have been processed at each step.

Import mapping in one click

You can now automatically apply import field mapping between source and destination endpoints. integrator․io suggests corresponding fields for integrations between two applications such as NetSuite and Salesforce. Fields you already mapped are unaffected, and you can edit any of the mappings that have been automatically applied.

View logs for webhook

You can now set a “debug” timeframe to capture the requests received by integrator․io Webhooks. The data recorded will help developers in troubleshooting or investigating an error.

Single sign-on (SSO) authentication

Account owners and administrators can configure SSO authentication for integrator․io accounts to reduce security risks by providing increased assurance about a user’s identity. When the account owner enables SSO and configures it with the OpenID provider (such as Okta or OneLogin), users can securely access integrator․io without needing to store or remember usernames and passwords.

Then, account users can access integrator․io by clicking the app in the SSO provider’s web portal or browsing the SSO URL of the account.

PGP encryption/decryption

Improved PGP encryption settings are available for FTP, Amazon S3, and Google Drive, with added functionality to define compression settings and ASCII armor for the files. In addition, you can now enable or disable decryption (export) and encryption (import) for individual transfers that use a PGP-configured connection. The encryption settings also include an option to configure a signing hash.

Delete Salesforce records and files

When importing data to Salesforce, an added option allows you to permanently delete records and documents/attachments in your account that match the lookup criteria. You can also suppress errors for records that don’t exist when the flow runs. Previously, you would have had to establish an HTTP connection to delete records through the Salesforce API.

New connectors

Built-in connectors are now available for Fulfillment.com, Google Ads, Mavenlink, Walmart Canada, Walmart Mexico, and Yotpo.

New vendor-specific EDI templates

integrator.io is now able to export and import the following electronic data interchange (EDI) definitions:

New and enhanced templates

Since the last release, we’ve built a lot of great Marketplace templates for you to jumpstart your integrations, including:

In addition, some of the more popular Quickstart integrations templates have been updated with this release:

Define a “trace key” for records

A record’s trace key is a unique field, such as an Internal Id, that identifies it throughout a flow. Error Management 2.0 (EM2.0) automatically resolves similar errors based on the trace key, and the record’s trace key is also retrieved when auditing flow data. In addition, it makes error records easier to search and identify.

The trace key is determined by integrator․io, but for a custom flow, you can override the value in the source app’s export or the destination app’s import in a one-to-many scenario.

Error Management 2.0 (EM2.0) enhancements

Customers running EM2.0 will have additional error handling visibility:

Upgrade to EM2.0 to switch to a new paradigm in error handling.

Improved Business Process Apps Framework support

The built-in Business Process Apps Framework (a.k.a., Integration app framework 2.0) now includes support for edition-based Integration apps – allowing faster development and reduced maintenance of Integration Apps by app developers.

Remove partially installed integrations

When you begin to install an integration – from a Marketplace template, cloned integration, or a ZIP file shared with you – and then cancel, your integrator․io homepage displays the partially installed integration as • Continue setup. That often happens if you run into problems configuring the connection.

At any point you can click the integration tile to resume the setup. A new option in the installation page is Delete integration to remove the partially installed tile from your homepage to the Recycle bin. Previously, customers would have to delete the integration with an integrator․io API call or return to the Legacy user interface.

Filter by absolute number

Filters using the Number data type now support use of the absolute function to filter records on an exact number value.

Import mappings provide flow step context

When creating or editing field mappings, the title of the form includes the import that you’re working on, as a convenient reminder in case your flow contains additional imports.

Improved Advanced field editor (AFE) 2.0 experience

New connector options

We’re continuing to improve the built-in API connectors and keep up with the providers’ features:

Marketplace button gives clearer context

When browsing templates in the integrator․io Marketplace, the default action is now to Preview the template. Previously, the button read Install, which is a later step upon reviewing the template’s components.

QuickBooks API version settings expanded

Previously, flow steps to QuickBooks did not allow you to specify the minor API version. You can now include the full version as a query parameter.

SQL queries preserved when “Insert/Update” import operation changed

For all SQL imports (to MySQL, PostgreSQL, or MS SQL), any queries that you’ve entered for an Insert/Update operation will also be available if you change the selection to Insert or Update. Similarly, an SQL query that you type for an Insert operation or an Update operation will appear when you change the type to Insert/Update.

Customer-reported issues resolved

The following articles have been added to Celigo integrator.io documentation:

The following topics have been substantially revised based on customer feedback, changes from this release, and ongoing quality efforts:

New connectors

Built-in connectors are now available for Microsoft Teams, Adobe Sign, Authorize.Net, Freshworks CRM, Pipedrive, and PrestaShop.

New vendor-specific EDI template

integrator.io is now able to export and import electronic data interchange (EDI) definitions for Fifth Third Bank EDI 824.

JavaScript debugging

You can now view and print script logs – including info, debug, error, and warning messages – for each script in your scheduled flows. The new Scripts tab will be available in your flow Run dashboard for any flow that contains a script hook.

You can turn on debugging for a specified time frame. And the new built-in console object allows you to set properties and call methods to output informational events and resolved values at runtime.

Delete records & files for NetSuite imports

The NetSuite connector now supports deleting records and File cabinet files . You can configure lookup criteria for identifying those records or files that need to be deleted, with the option to Ignore missing records if none are found.

NetSuite authentication update

With the release of API version 2021.1, NetSuite does not allow new accounts to connect to a RESTlet via basic authentication. This auth type is now marked “To be deprecated – do not use.” If you’re still using basic authentication, you’ll need to change your authentication method to a more secure method, such as token-based.

Support for NetSuite contact role record type

integrator.io now supports the Contact role field on the Contact record type.

New account-level Administrator role

You can now assign all permissions granted to an account owner to any user who has access to your account. Previously, only account owners had the ability to invite users, manage user permissions, create API tokens, and perform other owner-level tasks.

New connectors

Built-in connectors are now available for Clover , Google Drive , Intercom , lexbizz , and PriceFx.

New and enhanced templates

We’ve built a lot of great templates for you to jumpstart your integrations, including Acumatica , ADP Workforce Now , Amazon AWS , Amazon MWS , Azure Active Directory , BigCommerce , HubSpot , Jira Cloud , Magento 2 , Mailchimp , Microsoft Dynamics 365 , Microsoft Dynamics 365 Business Central , Salesforce , SAP Ariba , SAP Concur Expense , SAP Concur Invoice , ServiceNow , Shopify , Slack , Square , Stripe , Zendesk Sell , Zendesk Support, and much more.

This is just a sampling of what you’ll find in the Marketplace! We’re putting out new templates all the time, so be sure to check it out!

New vendor-specific EDI template

integrator.io is now able to export and import electronic data interchange (EDI) definitions for Odyssey EDI 850.

Error Management 2.0 enhancements

When you’ve migrated your account to EM2.0, you can see the number of error retries and whether the retry has completed successfully or failed again. You can also filter the errors by the error source and timestamp.

Test more quickly in Dev playground

If you have Developer mode on, you can now launch a Dev playground editor with a sample file to start testing right away. You’ll now see subsections in each editor, offering different file types to use as input data.

Browse your resources in Dev playground

You can now view all of your integrations’ resources at a glance in the new tree view:

Click the links under Integration Explorer to open any resource throughout your integrations. The explorer allows you to copy and paste text that you’ve tested with the advanced field editors (AFEs) in Dev playground.

Context-sensitive connection setup help

When you’re creating a connection to an application, you can now click the connection guide link to walk you through setting it up.

Enhanced connectors

We’re continuing to improve the built-in API connectors and align with the providers’ features:

Improved connection debugging

When you start the connection debugger from the Connections tab in Flow Builder, you can immediately view the debug log. You can also clear the debug log history with a single click.

Enhanced handlebars helper

We’ve enhanced the timestamp helper in your handlebars statements to include the timezone using {{timestamp "DDMMYY" "US/Central"}} and other supported time zones. Note that the timezone used will be the one you have set on your own user profile.

integrator.io export data processing enhancementsWe've improved how we handle data processing in the export step of our platform to reduce the number of possible export errors during flow runs.

Improved sorting of resources in an integration

Flows, users, and connections are now sorted alphabetically by name instead of by last updated timestamp. This makes it easier for you to find flows and resources in lists.

Increased scope size for HTTP connections

In previous versions, new HTTP connections would test successfully, but if a large amount of scopes were selected, the connection might generate an error and go offline. We’ve increased the number of scopes allowed, to account for greater HTTP connection access.

Improved Integration App and template listing pages

For our partners, we've added more detail to these listing pages to make it easier to manage the integration apps and templates you create, including what applications each has, when it was last updated, and the website URL.

Customer-reported issues resolved

The following articles have been added to Celigo integrator.io documentation:

The following topics have been substantially revised based on customer feedback and ongoing quality efforts:

The following template readmes and support articles have also been published since the last quarterly release: