What’s new
Homepage list view of integrations
Your integrator․io homepage defaults to the familiar “tile view,” and it also features a new list view that allows you to quickly scan a large number of integrations, or conveniently sort the list entries by column. In addition, you can perform common actions – downloading, cloning, and deleting – from the overflow (...) menu in either the tile or list view. You can also filter integrations by business application, and use the overflow menu to pin integrations to the top of your list.
Manage flows easier with flow groups
You can now organize flows within an integration into one or more flow groups.
Preview fields for data mapping
You can now see the structure of your source records and the expected output when you use lookup results, response, or import mappings. This feature helps you visualize your mappings so you can verify your accuracy, identify mistakes, and debug issues before you run the flow.
Gzip encoding allowed for HTTP connections
Gzip is fully supported as one of the compression options for files exported and imported through an HTTP connection.
Deprecation of integrator․io legacy user interface (UI)
Celigo is deprecating the legacy integrator․io UI, and it will no longer be accessible, not even via direct URL. If you experience any issues with the current UI, please submit a support ticket so that we can help resolve it.
Flow step debug logs
Enable debug logs on individual flow steps to see the communication between integrator․io and each application in a flow step (such as an export, lookup, or import). The debug logs display the request made to the application and the response it returns, including the request URL, methods, and response codes. You can also filter the logs by timestamp or response code.
New connectors
Prebuilt connectors are now available for 15Five, BarTender, Breezy HR, Confluence Cloud, Copper, Docebo, JazzHR, MercadoLibre, SAP Business One, Segment, and Zoho Expense.
New vendor-specific EDI templates
integrator․io is now able to export and import the following electronic data interchange (EDI) definitions:
- DSCO EDI 855
- ODW EDI 846
- ODW EDI 888
- ODW EDI 947
- Tractor Supply Co EDI 810
- Tractor Supply Co EDI 846
- Tractor Supply Co EDI 850
- Tractor Supply Co EDI 855
- Tractor Supply Co EDI 856
- Tractor Supply Co EDI 860
- Tractor Supply Co EDI 997
- Zoro Tools EDI 810
- Zoro Tools EDI 850
- Zoro Tools EDI 855
- Zoro Tools EDI 856
What’s enhanced
Additional EM2.0 features to manage errors efficiently
We are introducing new features in Error Management 2.0 to incorporate customer feedback and improve the user interface:
- You can now see requests and responses between integrator․io and Salesforce or NetSuite. When troubleshooting errors that occur during a flow run, you can pinpoint exactly which payload (records or data) was sent from or returned to integrator․io, the request URL and methods, and error response codes.
- When integrator.io classifies an error as Intermittent, auto-retry attempts occur for up to 10 hours.
- An integration-level Dashboard for each integration tile enables you to see all completed and running flows. (The dashboard that shows charts displaying flow run stats is now named Analytics.)
- You can now select an option under My Account settings to specify relative time display across all dashboards and resource tables instead of the absolute time, which is now the default. (For example, to see that a run completed “4 hours ago” instead of 2022-02-10 3:30:02 PM, enable this option.) This system-wide setting can be set separately for each user.
- Click the error count to see detailed stats for historical runs and analyze errors for a particular run.
- Hide empty runs or view only runs that have errors on the Run history dashboard.
- You can now use both time and date (whereas previously only date was possible) to filter runs based on the time period on the Run history dashboard.
Want to contribute your feedback on this and other features? Join our user research program.
Advanced field editor (AFE) continuity throughout Flow Builder
AFEs now reflect the current values for all fields, according to the output of the last executed flow step. For example, if you have a script in a preMap hook, the input data displayed in the next downstream AFE will be the result/output of that script.
HTTP request body no longer required for HTTP imports
You have the option to configure your own request body for an HTTP import. If you do not provide a custom body, the data coming from the last flow step will be sent as the request body to the outgoing HTTP API call.
Download audit logs
Easily download audit logs directly from integrator․io. Audit logs from up to one year ago are available, and you can specify the time period within that year to include in the CSV file. The download option is available in Flow Builder, integration tiles, Data Loader, and on connections, imports, exports, scripts, stacks, My APIs, and API tokens resources.
Ability to map subrecords with NetSuite SuiteScript 2.0
When you have chosen SuiteScript 2.0 for a NetSuite import, you can now provide the JSON path for subrecords and then map each of the subrecord’s fields. With this release, you now can take advantage of full, flexible subrecord mapping to NetSuite. Furthermore, all of the features in the Celigo integrator․io NetSuite bundle are now also supported in Celigo NetSuite Integrator SuiteApp 2.0.
Composite method options improved
When configuring an HTTP or REST API import with the Composite type Create new data and Update existing data, you can now identify an existing record using a specific field in the data or by running a dynamic lookup.
Exclude integrator․io endpoint from licensing
With this change, all connections to the integrator․io API are no longer counted as part of the endpoint entitlement calculation. Previously if your subscription was consuming all available endpoints, you could be prevented from certain operations that required special use of the integrator.io endpoint (for example, cloning some templates and integration apps, and accessing some flow errors). Now that it is no longer counted, these issues do not occur.
New status type for asynchronous exports
When creating or modifying an asynchronous export using Async Helper, you can now specify an additional status of ERROR, which is required by Amazon endpoints.
Note: For Integration Apps, the Async Helper is currently available only for Amazon and Walmart item feeds.
EDIFACT release character supported
You can now enable the release character (?
) so that when the EDIFACT file is parsed, integrator․io will escape other reserved characters.
Updated connectors
We’re continuing to improve the built-in API connectors and keep up with the providers’ features and make the settings more intuitive:
- Amazon Seller Central – Updated Selling Partner APIs
- SAP Business ByDesign – Added endpoints for sales order, purchase order, and inbound delivery; the Store URL setting is now labeled Tenant hostname
- Skubana – Subdomain is now automatically populated and editable
- SAP S/4HANA – Get x-csrf-token in the response header for every GET operation
- eBay – New settings for API type and API site ID, as well as Finance API scopes offered
- Miva – Timestamp support for all endpoints
- Microsoft Dynamics 365 Business Central – Updated the base URL to include the version and add the ping relative URL
- Shopify – Added version 2022-01 and removed 2021-04; updated older versions in customers’ saved connections
“Community” link under Help menu
Easily access the Celigo Community directly from integrator․io. A new link appears under the Help menu.
Page size setting in file exports
When downloading file metadata (in a Transfer flow step, as opposed to parsing records from a file), you can specify the Advanced > Page size setting of the export to control how many records a page contains.
Improved FTP bridge performance
With this enhancement, you can import large folders to an FTP server with faster performance.
Updated Node.js to version 14.8
The Node.js implementation is currently v14.8. It is compatible with previous versions and includes support for existing node modules and APIs.
Sample data option for AS2 flows
You can now add a sample file to AS2 exports to build the rest of the flow steps.
What’s fixed
Customer-reported issues resolved
- Prior to this enhancement, under heavy traffic the connection between integrator․io and an FTP server could fail repeatedly due to corruption of the Known_hosts file that resulted in a Base 64 error. With this enhancement, the connection failure problem is resolved.
- The JavaScript runtime method exports.runVirtualWithPaging() supports NetSuite restlet exports that needs pagination.
- The HTTP body setting for a cookie URL offers an Advanced field editor to build the values.
- In rare circumstances, flows to NetSuite with high volumes of data and low concurrency settings took a very long time to complete. Race conditions occurred, preventing the flow’s status from being accurately reported, and conflicting flow executions introduced an interdependent slowness.
- NetSuite import retried errors were marked as resolved when the job did not succeed, and no debug logs were generated.
- integrator.io was unable to download files from the Amazon Advertising Reports API.
- Customers were unable to save the client credentials location in the Lightspeed connector.
- The Zoho CRM connector did not include scope configuration settings for the Query API.
- The HTTP connector did not always reevaluate refreshed tokens referenced in body requests.
- The Use first row checkbox was checked automatically when grouping was disabled for import mappings.
- Exports using the FTP connector were unable to save file definitions for X12 EDI formats.
- HTTP import steps were not saved when changing the Override media type error response setting.
- SQL queries were not returning null date fields.
- integrator.io returned application errors when opening flow steps for some legacy integrations.
- Attempts to clone Salesforce – NetSuite (IO) Integration Apps from sandbox to production environments caused “Unable to fetch integration record” errors.
- EDI files from FTP and AS2 connections were not successfully exported.
- Successful CSV file uploads to PowerBI returned 408 errors.
- The Faire connector was unable to properly authenticate and returned errors.
- Some large volume eBay imports were canceling automatically with memory errors.
- Some real-time flows could not be triggered when invalid fields needed to be synced.
- Salesforce imports were not returning IDs in the response.
- NetSuite Assistant was not launching for Inbound Shipments.
- When exporting from or importing to Concur, the User field in the search parameter was left blank and the form saved, integrator.io defaulted the field value to “ALL” but did not update the API call.
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
- Levels 1 through 3 have been redesigned with new videos, reflecting the current interface, and enhanced content, thanks to our growing team and certificate earners’ feedback. It might be time for a refresher.
- Check out Live Training, free weekly sessions ranging from 30-60 minutes that provide an introduction to the integrator.io platform for new users and partners.
- We are always looking for opportunities to enhance your learning journey! You might have noticed the “Recommended for you” section. We hope it’s showing you courses that are aligned to some of our interests. If you have feedback, we’d love to hear from you. Please send a quick note to university@celigo.com.
Integration App articles – new and updated
- Amazon - NetSuite integration app R1 release notes, January 2022
- Cash Application Manager (IO) - NetSuite R1 release notes, January 2022
- Magento 2 - NetSuite integration app R1 release notes, January 2022
- Payout to reconciliation Automation for NetSuite R1 release notes, January 2022
- Salesforce – NetSuite (IO) R1 release notes, January 2022
- Shopify - NetSuite integration app R1 release notes, January 2022
- Fix JSON error when attempting to have Order and Tracking Details object flow update from NetSuite to Salesforce
- Subscription to cash for Salesforce and Zone Advanced Billing (NetSuite ZAB SuiteApp)
- Shopify v1.39.1 release note
- Amazon v1.27.3 release note
- Cash Application Manager (IO) v3.9.1 release note
- Amazon MCF v1.2.6 release note
- eBay v1.13.0 release note
- Payout to Reconciliation v1.0.4 release note
- Square v1.0.0 release note
- Magento 2 integration app compatible with Magento 2.4.3 edition
Support: Help Center updates
The following articles have been added to Celigo integrator.io documentation:
- ADP Workforce Now (API) – Acumatica integration template
- Admin approval and permissions in Microsoft
- Amazon MWS – Acumatica quickstart integration template
- Amazon MWS – Microsoft Dynamics 365 Business Central quickstart integration template
- BambooHR – NetSuite quickstart integration template
- BigCommerce – Acumatica quickstart integration template
- Data Warehouse Automation for Google BigQuery
- Employee Onboarding and Offboarding Business Process Automation for ADP
- Employee Onboarding and Offboarding Business Process Automation for Paylocity
- Employee Onboarding and Offboarding Business Process Automation for SAP SuccessFactors
- Example: Processing ContentDocuments from Salesforce
- Export Jira Service Management Cloud data
- Get help from the Community
- Google BigQuery Data Warehouse quickstart integration template
- Import and export data with OData and the Microsoft Dynamics 365 Business Central connector
- Import, export, and map data with OData web services and the SAP Business ByDesign connector
- Join our user research program
- Klaviyo – NetSuite quickstart integration template
- Microsoft Dynamics 365 Business Central – Salesforce quickstart integration template
- Miva – NetSuite quickstart integration template
- Organize flows with groups
- Print Nlapi debug logs in NetSuite
- Response mapping vs. results mapping
- Salesforce – Zendesk Support quickstart integration template
- Shopify – NetSuite quickstart integration template
- Shopify – SAP Business ByDesign quickstart integration template
- Set up a connection to 15Five
- Set up a connection to Autopilot
- Set up a connection to Breezy HR
- Set up a connection to Confluence Cloud
- Set up a connection to Copper
- Set up a connection to Docebo
- Set up a connection to JazzHR
- Set up a connection to Google Contacts
- Set up a MercadoLibre connection
- Set up a connection to Merchant e-Solutions
- Set up a connection to MessageMedia
- Set up a connection to Microsoft Outlook Mail
- Set up a connection to Mixpanel
- Set up a connection to PracticePanther
- Set up a connection to Propack (P3PL)
- Set up a connection to SAP Business One
- Set up a connection to SAP S/4HANA Cloud
- Set up a connection to Segment
- Set up a connection to Ware2Go
- Set up a connection to Zoho Expense
- ServiceNow – Jira cloud platform quickstart integration template
- Snowflake Data Warehouse quickstart integration template
- Submit a support ticket
- WooCommerce – NetSuite quickstart integration template
- Working with JSON data in integrator.io
- Zendesk Support – NetSuite quickstart integration template
The following topics have been substantially revised based on customer feedback, changes from this release, and ongoing quality efforts:
- Advanced field editors (AFEs) and the Dev playground
- Build HTTP request body editor and Relative URI editor
- Celigo NetSuite Integrator SuiteApp 2.0 (beta)
- Configure EDI and fixed-width files
- Configure SSO with Microsoft Azure
- Configure the Shopify - Acumatica quickstart integration template flows
- Export data from an HTTP source app
- Export files from an FTP server
- Handlebars helper reference
- Hooks for integrator.io
- Identify existing records when importing records
- Import files to an FTP server
- Initiate template installation from the SAP Concur App Center
- Install the integrator.io bundle in NetSuite
- Integration tabs
- Intro to Error Management 2.0
- Manage your profile
- Map source record fields to the destination
- Set up a connection to Amazon Seller Central
- Set up a connection to eBay
- Set up a connection to Microsoft Dynamics 365 Business Central
- Set up a connection to Miva
- Set up a basic auth connection to Shopify
- Set up an OAuth 2.0 connection to Shopify
- Supported SAP Business ByDesign APIs
- Set up a connection to SAP S/4HANA Cloud
- Set up a connection to Skubana
- Switch to Developer mode
- Troubleshoot Concur Quickstart integration templates
Comments
Please sign in to leave a comment.