integrator.io release notes v6.9.1.0, September 2020

Contents

• What’s new
• What’s enhanced
• What’s fixed
• Integration app releases
• Support: Help Center updates

What’s new

New connectors
Built-in connectors are now available for G2, Microsoft Dynamics 365 Supply Chain Management, MYOB Advanced, Precisely, and Snowflake.

Preview panel available for lookups
You can now preview the requests and responses made during destination lookups. The familiar Preview panel (already available for exports) now allows you to see similar sample data for lookup apps.

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

• Boots EDIFACT DESADV
• Boots Order
• InSource EDI 856
• Pfizer EDI 856
• QVC EDI 219
• QVC EDI 846
• Superdrug Purchase Order
• Target EDI 860
• Target EDI 864

What’s enhanced

Added NetSuite import file attach & detach
You can now attach files to and detach them from a NetSuite file cabinet during import.

Able to uninstall Integration App
You cannot remove an Integration App that contains an unexpired API token. Starting with this release, you can delete API tokens (shown in the Admin tab for the integration tile), which then allows you to uninstall the Integration App successfully.

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

• Anaplan – token-based authentication added
• HubSpot – updated to support V3 of the HubSpot API
• Pitney Bowes – APIs updated (see new Precisely connector for accessing removed options)

Headers available in response mapping
When selecting a value for response mapping, you can now map values to headers in HTTP lookups.

More Advanced Field Editors available within forms
Several Advanced Field Editors (such as the Transform mapping and JavaScript editors for exports and imports) earlier appeared as popup modal dialogs, disabling any other interaction with integrator.io. For ease of use, these AFEs now are available within the forms or panes that slide in from the right.

Refresh Salesforce import mapping
There is now a Refresh button that allows you to view your latest Salesforce columns, if anything has changed since your last import mapping.

Preview panel easier to read 
You can now preview the requests and responses in a viewer with syntax coloring, similar to the Advanced Field Editors. 

What’s fixed

Retry data display improved
After a flow runs, generating an import error, you can view the record that failed in your dashboard and take appropriate action. Previously, the Retry data JSON was not always formatted properly, and long strings would force scrolling to the right. With this release, Retry data is shown in a wider field with syntax coloring and formatted whitespace for line wrapping and child hierarchies.

OpenAir export fully supported
The OpenAir connector is now also available in the current integrator.io UI.

Integration app releases

• Cash Application Manager | May 2018 (version 2.8.0)
• eBay – NetSuite release notes v1.10.1, September 2020
• Sync Amazon unit case packing quantity to NetSuite transfer order
• Sync item aliases to NetSuite transfer order
• Sync NetSuite Transaction Financials to Salesforce Financials

Support: Help Center updates

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

• Regular expressions (regex) examples
• Build Integration Apps
• Connect to a SOAP/XML web service
• Connect to the Braintree GraphQL API
• Fundamentals of HTTP connections
• Integration tutorial: ActiveCampaign – NetSuite
• Build a database query based on multiple exported values
• Set up an OAuth 2.0 connection to Acumatica
• Set up a token-based auth connection to Anaplan
• Set up a connection to G2
• Set up a connection to Google Mail
• Set up a connection to Microsoft Dynamics 365 Supply Chain Management
• Set up a cookie-based connection to MYOB Advanced
• Set up an OAuth 2.0 connection to MYOB Advanced
• Set up a connection to Precisely
• Set up an OAuth 2.0 connection to Shopify
• Set up a connection to Snowflake
  • Export data from Snowflake
  • Import data into Snowflake
• Example hook: Add a line item to a NetSuite order
• Format CSV records in a transform
• JavaScript example: Detect an empty FTP directory
• Example 2: Run a virtual export in My APIs
• Example 4: My APIs call with Shipworks authentication

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

• Advanced field editors (AFEs)
• Create a flow with Flow Builder
• Data Loader
• Example 1a: Set up My API to run an export
• Import data into NetSuite
• Set up a basic auth [cookie] connection to Acumatica
• Set up a basic auth connection to Anaplan
• Set up an OAuth 2.0 connection to HubSpot
• Set up a token-based connection to HubSpot
• Set up a connection to PostgreSQL
• Set up a basic auth connection to Shopify