|Term or acronym
|Every integrator.io account is provisioned with API tokens. API clients must transmit a token in the authorization request header field using the Bearer authentication scheme. You can generate tokens with limited scope or an auto-purge window to solve problems where a connection needs specific access on a temporary basis.
|Most API endpoints limit the number of requests that you can make in parallel. Concurrency is a setting on the integrator.io connection that governs how many parallel API calls to make while running integration flows. See also, Appendix: Governance policies for common apps.
Connections are used to store credentials, along with other access information for an application or system. integrator.io supports hundreds of pre-built connectors that you can configure for a system, as well as generic connection types like HTTP that allow you to configure your own request headers and other parameters. Some of the mostly used connection types are NetSuite, HTTP, SFTP/FTP, Amazon MWS, and AS2.
integrator.io has two classes of data:
Electronic Data Interchange (EDI) is a standard format for the digital exchange of business information. integrator.io supports converting between ISA EDI or fixed-width files and JSON files.
Each application or technology service that you create a connection to in integrator.io. Unlimited connections to each application are allowed and only count as one endpoint.
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 legacy 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 extract data from an application or system. Exports can run standalone or in the context of a flow:
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 your settings, and imports the processed data into another system.
The integrator.io REST API supports the following custom HTTP headers:
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 preSavePage, 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.
Imports regulate the flow of data into a destination application by adding, updating, uploading, or deleting files or records, according to the system’s configuration. Imports can run standalone or in the context of a flow:
An integration contains 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 container that organizes these flows is an integration; and, it is represented by a rectangular tile in the grid view or a specific row in the list view of the Home page. You can group flows into integrations however you like. You can click the integration in either the grid or list view to manage and monitor the flows within the integration.
Integration apps represent fully functional pre-built integrations that you can install into your integrator.io account from the 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. All components created in a customer’s account are tagged with the integration app’s _id (via the _connectorId field). An integration app can modify only those components tagged with its own _id. The schema primarily serves the purpose of listing an integration app in the integrator.io marketplace with a description, imageURL, websiteURL, and so forth.
Integration views indicate how integrations are displayed. integrator.io provides two integration views, namely Tile view and List view. The tile view (default) displays integrations as tiles; whereas, the list view displays integrations in a list. You can switch from one integration view to another by clicking the view icons in the upper-right corner of the Home page.
|integrator.io is an API-first platform. Features are released in the API first, and then shortly after in the web interface. The 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 (where you write custom code to handle requirements that cannot be implemented via configuration alone). Any integrations that you build can be listed in the integrator.io marketplace for easy installation to any other account.
|iPaaS, or integration Platform as a Service, is a platform that standardizes how applications are integrated into an organization, making it easier to automate business processes and share data across applications. By leveraging iPaaS technologies, growing companies can eliminate manual processes, reduce dependency on spreadsheets and email, while increasing visibility, speed, and accuracy across their organization.
|Lookup (flow step)
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 look up transaction data for the customer (based on a saved search) and add the new data to the original export data by means of response mapping.
|Lookup (import mapping type)
|When mapping fields between the source and destination apps, you can perform a Lookup operation to handle mapping based on a query of the destination records. For more information, see HTTP Import: Static and dynamic lookups.
|NetSuite bundle exports
If you are using integrator.io to build NetSuite-based integrations, we highly recommend you install the Celigo integrator.io bundle, a SuiteApp installed directly in your NetSuite account. Once installed, it enables a powerful export engine that can export NetSuite data in real time, intercepting events in NetSuite as they happen, and also run batch-based exports that utilize NetSuite SuiteScript APIs for more advanced and efficient search and custom logic capabilities.
If installing the bundle in your NetSuite account is not an option, you can still create NetSuite exports that use the NetSuite 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 install anything right away.
|NetSuite bundle imports
If you are using integrator.io to build NetSuite-based integrations, we highly recommend you install the Celigo integrator.io bundle, a SuiteApp installed directly in your NetSuite account. Once installed, it enables a rich import engine that can be used to map and load NetSuite data in very creative (and efficient) ways.
Differences in imports when you install the bundle:
If installing the bundle in your NetSuite account is not an option, you can still create NetSuite imports that use the NetSuite 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 install anything right away.
|integrator.io will also pass single-use 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 granted access to invoke resources exclusively 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 invoking exports and imports already defined in the integrator.io account.
You may want to take the ID of the submission response and use this ID to reference another record and call other data flows from one flow. For example, you could check if the customer exists before inserting an order. If it doesn’t exist, insert the customer first and then insert the order.
The integrator.io API is rate-limited using a leaky-bucket algorithm with a bucket size of 1,000 and a fill rate of 300 tokens every second, allowing up to approximately 1,080,000 requests per hour.
|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.
|Software as a service.
|A test or beta environment.
|Reports on controls at a service organization, which is relevant to security, availability, processing integrity, confidentiality, or privacy. These reports are intended to meet the needs of a broad range of stakeholders who need to understand internal control at a service organization.
A webhook is an HTTP callback: an HTTP POST that occurs when something happens; a simple event-notification via HTTP POST. integrator.io is capable of receiving events from any application that supports webhook adaptors.
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. The following webhooks are built into integrator.io:
A wrapper is a mechanism for any developer to build your own API and plug imports or exports to the integrator.io platform. This allows you to do custom transformations and connect to systems that do not have direct adapters. This is also Celigo’s answer to on-premise application integrations.