Contents
- What’s new
- What’s enhanced
- What’s fixed
- Celigo University
- Integration App articles
- Support: Help Center updates
Tell us what you think: You’re invited to share your opinion on specific features and the overall release (estimated time: 60 seconds).
What’s new
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:
- View all flows that are still in progress or waiting in queue
- View all flows that have completed within a specific time period
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,
- A new Microsoft Azure connector is also available to handle binary large object (blob) storage
- A built-in connector is now available for BrainTree; however, you must build the HTTP requests according to their API guide (a BrainTree “form view” is not available for flow steps)
New vendor-specific EDI templates
integrator.io is now able to export and import the following electronic data interchange (EDI) definitions:
- Cardinal Health EDI 810
- Cardinal Health EDI 850
- Cardinal Health EDI 855
- Cardinal Health EDI 856
- Grainger EDI 856
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:
- Orderful – NetSuite (updated to v3)
- BigCommerce – Microsoft Dynamics 365 Business Central (updated to v3)
- BigCommerce – QuickBooks (updated to v3)
- BigCommerce – Acumatica (updated to v3)
- BigCommerce – NetSuite (updated to v3)
What’s enhanced
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:
- Migration path eased – Existing accounts can migrate without having to pause running flows. After migrating, you can retry any existing errors in a flow running EM2.0.
- Fine-tune error resolution – You can now control which flows auto-resolve errors. Primarily, this feature allows you to disable Auto-resolve in cases where trace keys overlap and thus Auto-resolve might give false results.
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…
- Connector
- Export
- Flow lookup step
- Import
- File transfer
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:
- Amazon MWS – renamed Amazon Seller Central and beta support available for Amazon Selling Partner (SP-API) in the connection’s API type
- Tableau – updated to v3.10
- Freshdesk – additional endpoints added
- Square – marked deprecated endpoints
- Concur – added support for List v4; marked List v3 “to be deprecated”
- HubSpot – includes support for Blog Authors, Blog Tags API, and Files API
- 3pl Central – now supports additional “PUT” endpoints
- Shopify – migrated from version 2020-10 to 2021-07, with added support for 2021-07
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.
What’s fixed
Customer-reported issues resolved
- Removed multiple required API permissions from Microsoft Dynamics 365 CRM and SharePoint connector scopes
- When certain flows in an integration were disabled, they would be relocated to Standalone flows without connections or mappings
- Some flows with Amazon S3 imports would run until canceled
- Okta connections to emea-okta.com were redirecting to the main okta.com domain
- Administrator accounts were unable to register connections
- Customers were unable to install integration ZIP files if they included a connection with the same name as an existing connection
- In an Amazon MWS multipart/form-data import, the file was interpreted as XML, generated an error, and failed to upload
- The AWS Lambda Stack region label for US West (Oregon) was mislabeled as [us-east-2] instead of [us-west-2]
- ASCII characters entered in custom flow settings were incorrectly Unicode escaped
- Field-specific qualification criteria filters on Salesforce webhook listeners generated parsing errors
- Modified export (output) or import (input) filter operands were not refreshing when the field was changed
- The Borrow concurrency from setting in a connection generated errors when reset to the default value (Please select)
- Imports couldn’t be saved if there was a forward slash (/) character in the value for How should we find existing records? > Which field?
- In rare occurrences, accounts that had migrated to EM2.0 had unexpectedly reverted to the previous error management interface
- When cloning a flow, a single connection was applied to all NetSuite flow steps, and that connection could not be changed, even though alternate connections were required
- In a free integrator.io accounts, the option to reactivate a flow was missing
- FTP XML imports downloaded from the integrator.io dashboard were unexpectedly truncated and sometimes excluded data outside of the {#each} loop
- Some real-time flow data (initiated by webhook requests received by integrator.io) were experiencing delayed processing
- File transfer HTTP import data in the AFE 2.0 HTTP request body editor validated as XML instead of JSON
- The Handlebars editor interpreted Lookup URI data structures differently than how the data was processed during a flow run
- The Build SOQL query editor did not correctly support {#each} handlebars loops
- When exporting Salesforce opportunities, the records were not placed in descending order as configured
- Flow steps in Flow Builder rendered incorrectly in the Safari browser on OSX
- Mapping fields in the flow Salesforce Opportunity to NetSuite Sales Order Add/Update for the Salesforce – NetSuite Integration App (IO) prompted erroneous errors that had to be repeatedly closed
Tell us what you think: You’re invited to share your opinion on specific features and the overall release (estimated time: 60 seconds).
Celigo University
We are thrilled to announce Celigo University 2.0!
We are putting forth a more engaging and interactive learning experience. Check out the latest version of our Level 1: integrator.io Fundamentals Learning Path either as a refresher course or to work your way towards certification. Happy integrating!
Integration App articles – new and updated
- Amazon - NetSuite release notes v 1.24.0, June 2021
- Sync Amazon order taxes using the NetSuite SuiteTax feature
- Order failed to add in Shopify: Could not find a match for itemID
- Shopify Order stuck on Order Import
- Real-time import of Shopify web store orders
- Sync orders from NetSuite to Shopify
- Import Shopify orders in “Pending” payment status into NetSuite
- Shopify Tags and Order Notes
- Returnly – NetSuite (Nova Module) Integration app documentation
- ShipStation – NetSuite (Nova Module) Integration app documentation
- WooCommerce – NetSuite (Nova Module) Integration app documentation
Support: Help Center updates
The following articles have been added to Celigo integrator.io documentation:
- View all activity in the Account Dashboard
- Identify existing records when importing records from a data file
- Sort and group content for all file providers
- Enable NetSuite Assistant in Microsoft Edge or Google Chrome v91 and later
- Flow tutorial: Integrate with a Slackbot
- Migrate from deprecated SAP Concur API endpoints
- Migrate from deprecated Square API endpoints
- Set up an OAuth 2.0 HTTP connection to Azure Data Lake Storage Gen2
- Set up a connection to Freshservice
- Set up a connection to Looker
- Set up a connection to Omnisend
- Set up a connection to OneLogin
- Set up a connection to OrangeHRM
- Set up an OAuth 2.0 connection to PandaDoc
- Set up an token-based connection to PandaDoc
- Set up a connection to Paylocity
- Set up a connection to PagerDuty Events
- Set up a token-based connection to PagerDuty
- Set up an OAuth 2.0 connection to PagerDuty
- Set up a connection to Quickbase
- Set up a connection to ReCharge
- Set up a connection to SAP Business ByDesign
- Set up a connection to SAP SuccessFactors
- Set up a connection to Vend
- Set up a connection to Zenefits
- Pricefx - NetSuite quickstart integration template
- SAP Ariba Network – NetSuite template for Suppliers quickstart integration template
- Set up a custom HTTP connection to Walmart DSV
- Salesforce Nonprofit – NetSuite Social Impact V2 quickstart integration template
- Learn more with live training
- Handle multiple transaction sets (ST-SE segments) in an EDI file
- Restructure payload with a preSavePage hook
- Improve your Celigo experience by providing feedback
- Microsoft Dynamics 365 Business Central – NetSuite quickstart integration template
- Maximum file size limits
- Explore the integrator.io Marketplace
- Get started FAQs
- Shopify - Microsoft Dynamics 365 Business Central quickstart integration template
- Import data into Snowflake
- Filter HubSpot data to configure a delta export
- Import example: Add rows to a Google sheet
The following topics have been substantially revised based on customer feedback, changes from this release, and ongoing quality efforts:
- Celigo NetSuite Integrator SuiteApp 2.0 (beta)
- Transform your data records
- Create webhook listeners – Listener debug logs
- Govern concurrency of NetSuite connections
- Error: Connection has dependent export/import. Cannot update environment for NetSuite
- Assign concurrency levels to data transfer
- integrator.io REST API resources – Errors
- integrator.io REST API resources – Audit
- integrator.io key concepts
- Set up a connection to BambooHR
- Set up a token connection to Slack
- Fine-tune integrator.io for optimal data throughput – integrator.io page size
- Concur Expense (Best Practice & Enhanced) – Acumatica
- Concur Invoice (Best Practice & Enhanced) – Acumatica
- Concur Expense (Best Practice & Enhanced) – NetSuite
- Concur Invoice (Best Practice & Enhanced) – NetSuite
- Mark an FTP connection as a trading partner
- Orderful – NetSuite quickstart integration template
- eBay – NetSuite quickstart integration template
- API pagination
- Filter Intercom data to configure a delta export
- Configure and map custom NetSuite parent-child records
- Set up a connection to Greenhouse
Comments
0 comments
Please sign in to leave a comment.