|Term or acronym||Definition|
|2FA||Two factor authentication|
|Bearer Tokens||Every integrator.io account is provisioned with one API token. API clients should transmit this token using the authorization request header field and the "Bearer" authentication scheme.|
Connections are used to store credentials, along with other access information for an application or system. Currently integrator.io supports the following connection types.
For more information on connections, see Connections.
integrator.io supports over 150 connectors, including universal and database connectors, as well as webhooks.
To view all of our connectors, see connector solutions.
Electronic Data Interchange (EDI) is a standardized format used for the digital exchange of business information. integrator.io supports converting between ISA EDI or fixed-width files and JSON files.
Enterprise Service Bus
Extract Transform Load (ETL) is the process of extracting, transforming, and loading data in a database. It is also often used to retrieve data from external data storage or transmission sources. Legacy ETL technologies were designed to move large batches of structure data (rows and columns). While this strategy is optimal for initial migrations and periodic data loading requirements, some integrations require both real time and batch transfers. Modern cloud integration platforms go beyond data loading and point-to-point use cases with event-based orchestration and big data integration bulk loading and data transformation for analytics. An on-premise enterprise service bus (ESB) or single-tenant hosted versions of a legacy vendors of on-prem software typically communicate only via XML and SOAP. Modern cloud integration technologies can work with these formats and protocols and are designed to take advantage of JSON and REST. Celigo supports Extract (Export flow), Transform (Field mapping transformation UI) and Load (Import Flow and Data Loader).
Exports are used to extract data from an application or system. Exports can run standalone, or in the context of a Flow.
Standalone exports are useful for integrations where user actions (like clicking a button) need to invoke an external application's API in real time and return the results immediately. Standalone exports are especially useful for applications that integrate with more than one application when the development environment is inconveniently designed and writing native API client code would be counterproductive. Celigo uses standalone exports extensively for spreadsheet and email synchronization.
Exports running in the context of a flow execute asynchronously. The data is broken into one or more pages, and integrator.io uses those pages to pass data into the one or more imports. For more information, see Exports.
A flow is a stream of data between two or more systems or applications. A flow exports the data from one or more systems, processes the data according to user-defined settings, and imports the processed data into another system. For more information, see Flows.
Our integrator.io REST API supports the following custom HTTP headers:
Imports insert data into a destination application. Imports can run standalone or in the context of a flow.
Standalone imports are useful for integrations where user actions (like clicking a button) need to invoke an application's API in real time and return the results immediately. Standalone imports are especially useful for applications that integrate with multiple other applications or applications with inconveniently designed development environments and writing native API client code would be counterproductive. Celigo uses standalone imports for spreadsheet and email synchronization.
Imports running in the context of a flow execute synchronously, but the results return back to the flow for statistical reporting in a job record.
An integration is one or more flows set up to achieve your needs for manipulating and moving data between systems. An integration can refer to a single flow or a set of flows grouped together in a folder. The folder that contains the flow(s) is an integration and is represented by a rectangular tile on the Home page. You can group flows into integrations however you like. Click the integration tile to manage and monitor the flows within the integration.
Integration apps represent fully functional pre-built integrations that any user can install into their integrator.io account from our integrator.io marketplace. They include an installer, an uninstaller, and a settings interface. Developers can push updates at any time for any connector to their entire install base. Integration apps are mostly made up of code (that uses the integrator.io API to interact with a user's account). You can use an integration app to create any number of components in a user's account. All components created in a user's account are tagged with the integration app's _id (via the _connectorId field). An integration app can only modify components tagged with its own _id. The schema primarily serves the purpose of listing an integration app in the integrator.io marketplace (i.e. description, imageURL, websiteURL, etc...).
Integrator.io is an API first platform. Features are released in the API first, and then shortly after in the UI. Our integrator.io API is RESTful, uses JSON, and is secured by Bearer Tokens. The target audience for the API is developers building integration-based apps. Complementing the API, integrator.io supports a rich extension framework. The integrations you build can include an installer, settings pages, and any number of hooks or wrappers (hooks and wrappers give you the ability to write your own custom code, and are useful for requirements that cannot be implemented via configuration alone). Any integrations that you build can be listed in the integrator.io marketplace for easy installation by any other user.
Wrapper is a mechanism for any developer to build your own API and plug imports or exports to the IO platform. This allows you to do custom transformations and connect to systems that do not have direct adapters. This is also our answer to on-premise application integrations.
Hooks are custom code that can run at different stages during the execution of a flow to modify the behavior of export and import processes. Hooks can be run during the export or import stages, including preSave, postResponse, preMap, postMap, postSubmit, and postAggregate.
If you are using NetSuite exports, you can also execute these SuiteScript hooks during your data flow. SuiteScript hooks are run entirely in NetSuite.
For more information on hooks, see Hooks for integrator.io.
Lookups allow you to find deeper levels of information for a record, and transfer that information later in the flow.
For example, if you export 10 Shopify customers to NetSuite, for each of those records, you can lookup transaction data for the customer (based on a saved search), and add that data to the original export data. Once the lookup step does this, you can use this data later in the flow, once you make a response mapping that includes all the data you just found with the saved search. For more information, see HTTP Import: Static and dynamic lookups.
|One Time Tokens||integrator.io will also pass one-time tokens to back-end components implementing hooks, wrappers, installer, uninstaller, or settings interfaces. These tokens are passed in the options argument of each function and can be used similarly to Bearer Tokens to call back into integrator.io. One-time tokens will automatically expire after use (determined via a return statement, or after a 15 minute timeout). For integration apps, tokens passed are only granted access to invoke resources belonging to the integration app itself (determined via the _connectorId property). For hooks and wrappers not belonging to an integration app, one-time tokens are limited to only invoking Exports and Imports already defined in the integrator.io account.|
|NetSuite Distributed Adaptor Exports||If you are using integrator.io to build NetSuite-based integrations, we highly recommend you install our Distributed Adaptor (DA for short). It's a SuiteApp that gets installed as a Bundle directly in your NetSuite account. Once installed, it enables a super powerful export engine that can both export NetSuite data in real time, intercepting events in NetSuite as they happen, and also run batch based exports that utilize NetSuite's SuiteScript APIs for more advanced and efficient search and custom logic capabilities.|
|NetSuite Distributed Adaptor Imports||
If you are using integrator.io to build NetSuite-based integrations, we highly recommend you install our Distributed Adaptor (DA for short). It's a SuiteApp that gets installed as a Bundle directly in your NetSuite account. Once installed, it enables a super rich import engine that can be used to map and load NetSuite data in very creative (and efficient) ways.
Differences between NetSuite Distributed and Non-Distributed Imports
|NetSuite (Non-Distributed) Adaptor Exports||If installing the Distributed Adaptor in your NetSuite account is not an option, you can still create NetSuite exports that use NetSuite's web services API. The capabilities are slightly more limited and the performance can also be slower depending on the complexity of your exports, especially related to the number of dynamic searches each record will require before export. Using the web services API enables you to get started immediately without involving a NetSuite admin to to install anything right away.|
|NetSuite (Non-Distributed) Adaptor Imports||
If installing the Distributed Adaptor in your NetSuite account is not an option, you can still create NetSuite imports that use NetSuite's web services API. The capabilities are slightly more limited and the performance can also be slower depending on the complexity of your imports, especially related to the number of dynamic internal id lookups each record in NetSuite will require before import.
Using the web services API enables you to get started immediately without involving a NetSuite admin to to install anything right away.
Differences between NetSuite Distributed and Non-Distributed Imports
You may want to take the ID of the submission response and use this ID to reference another record. Customers and Orders. Call other data flows from one flow. E.g. check if the customer exists before inserting an order. If it doesn't exist, insert Customer first and then insert Order.
|Rate Limiting||integrator.io's REST API is rate limited using a token bucket algorithm with a bucket size of 100 and a fill rate of 30 tokens every 1 second, which approximates to 108,000 requests allowed per hour.|
|REST||A RESTful API is an application program interface (API) that uses HTTP requests to GET, POST, and DELETE data. Representational state transfer (REST), which is used by browsers, can be thought of as the language of the Internet. Now that cloud usage is on the rise, various application programming interfaces (APIs) are emerging to expose Web services and REST is a logical choice for building APIs that allow end users to connect and interact with cloud services.|
|REST API Adaptor Exports||integrator.io supports the ability to define exports for any RESTful JSON API.|
|REST API Adaptor Imports||integrator.io supports the ability to define imports for any RESTful JSON API.|
|SaaS||Software as a service.|
|SOC Compliance||Reports on Controls at a Service Organization. This is relevant to Security, Availability, Processing Integrity, Confidentiality or Privacy. These reports are intended to meet the needs of a broad range of users that need to understand internal control at a service organization as it relates to security, availability, processing integrity, confidentiality and privacy.|
A Webhook is an HTTP callback: an HTTP POST that occurs when something happens; a simple event-notification via HTTP POST.IO is capable of receiving events from any application which supports webhooks. IO Supports Webhook Adaptor Exports.
integrator.io also supports the ability to integrate with any JSON based webhook. An export record is used to register a listener that can then be posted to. IO supports the following webhooks:
In addition, we support custom webhooks that a user can configure via our UI. Learn more: https://webhooks.pbworks.com/w/page/13385124/FrontPage
|Webhook Adaptor Exports||integrator.io also supports the ability to integrate with any JSON-based webhook. An export record is used to register a listener that can then be posted to.|