What API Orchestration Tools are Available to Tame your Data?

Published on by Daniel Twigg

Updated on

API Orchestration Tools for taming data

How often is integration as simple as initiating a direct transfer of equivalent data from A to B? If all APIs were built the same, and all integrations simple, then maybe it would be common. In reality, dealing with APIs can be a messy affair. This is because each has its own bespoke structure and formatting. These have been built to fit their SaaS application, not others.

What you need is the ability to make the APIs play nicely together – to orchestrate that data.

In this blog, we provide an overview of some of the key API Orchestration components of Cyclr.

Field Mapping

As a minimum, you typically need to map the data fields between the applications you want to integrate. This can be simple, and when it comes to data types such as strings it is. However, what do you do when you have APIs that expect data in a particular format that differs from your source application?

A simple example might be that application A stores DateTime data in US format (MM/DD/YYYY), while application B stores it in UK format (DD/MM/YYYY). Simply sending one value from A to B isn’t going to give you the desired result in your target application.

It is from these simple examples, through to more advanced requirements, that the capacity to orchestrate your data becomes valuable. It gives you the ability to translate the data into your required format while it’s in transit. Within Cyclr you can set up the data translation rules to enable the smooth transfer of data from one system to another, even if the formats are different.

Field Mapping in an Integration Workflow

Transferring only the Data you Need

Another main challenge is how you sort, manage and filter collections of data. Most integration outcomes are unlikely to need the same batch of data to be sent over and over from one application to another. It can make much more sense to only send the latest and most recently updated records.

Orchestrate Data: Get New Contacts Step

However, not all APIs have the ability to do this. This is where Cyclr’s orchestration tool can add value by selecting and sending only the records that have been created or updated since the last time integration has been run. It offers efficiency for both integration performance and the destination server’s load.     

For example:

A common information integration between two applications could be:

Application AGet All Contacts —-> Application BAdd/Update Contacts

A more efficient approach would be:

Application AGet New Contacts —> Application BAdd/Update Contacts

If ‘Get New Contacts’ doesn’t exist in Application A’s API then Cyclr can be configured to achieve that outcome and enhance the functionality of the API.

Combining Methods into One Workflow

Another challenge to orchestrating data may be that Application B has separate methods for adding contacts and updating contacts. Cyclr’s Orchestration tool gives you the ability to handle this situation simply.

By fetching Application B’s contact list and using an add/update logic step (we have a decision logic step to check and sort data), you can check Application B’s contacts to see if your new contacts from Application A are already present.

If they are, you can branch the data output, sending the data to an Update Contacts method in Application B, leaving new contacts to travel down the false branch to the Add Contact method.

Updating contact data integration workflow

How can I select specific data within an integration workflow?

Orchestrate Data: Create logic rules with the decision step

By using the “Decision” logic step, you can split data on a true or false branch, continuing the workflow separately along both. You can compare values from previous steps in your integration workflow, look for values above/below a set parameter or look for a set value within a data set to split the data. An extra layer of intelligence that can enhance the typical configuration of an API.

Time-Based Constraints

While the vast majority want their data transferred as quickly as possible, some use cases can have a more finessed requirement.

You might require data to be put ‘on hold’, either for a specific amount of time or until a date when the integration should continue.

Cyclr’s Orchestration tools allow you to handle time delays or ‘wait until’ dates before performing an action.

How can I temporarily delay an integration’s data flow?

Orchestrate Data: Set delays between steps

By using the “Delay” logic step in the Cyclr integration builder, you can set a fixed amount of time you would like the integration to wait before continuing along its remaining steps. Perhaps to stop automation from sending too many alerts and/or messages in quick succession, or to allow time for a user to take an action that might influence subsequent steps within automation.

Workflow Delay Example

How do I set a date to continue an integration workflow?

Orchestrate Data: Wait Until Step

You can use the “Wait Until” step in the Cyclr workflow builder to set a specific time when you want a triggered integration to continue along its intended path.

This is particularly common in the event industry- where, for example, customised messages (email campaigns or SMS messages) are sent to checked-in attendees to notify them about a relevant talk or a message from a sponsor.

The infinite possibilities of your users’ requirements

Another major blocker of creating ‘one integration to rule them all is your users’ inevitable bespoke requirements. While many will be using similar software stacks, the level of customisation available in most SaaS platforms means that two instances of the same system will be rarely the same.

So how do you keep up when making integrations between your SaaS platform and your users’ most valuable business assets?

Customisable Integration Templates

You could build completely custom integrations for them; eating into developer resources and adding to your maintenance backlog. Or you could use an orchestration platform that allows you to design templated solutions that can be customised and deployed for your users without the need for additional development.

This Orchestration function allows you to adapt a template to accommodate custom requirements and map fields to meet your customers’ precise needs without eating up developer bandwidth.

Customising your Client’s Connectors

So you have some integration templates ready to go but need to map data to custom fields? No problem.

Within Cyclr you, or your users, can make account-specific alterations to your users’ connectors.

By entering your user’s account within Cyclr, you can examine and test their installed connectors. By delving deeper, you can make direct changes to the request and response fields, adding in any necessary custom fields that you need to be applied to an integration template.   

Modifying a customer's connector

Communicating with Different API Types

One of the main issues with creating and maintaining integrations between services is the lack of standardisation around API creation and development. As well as the various API formats, including REST, SOAP and GraphQL, there are various forms of authentication each may choose to implement.

So how can you maintain consistency when dealing with a wide range of services?

The Cyclr approach is through SaaS connectors. We’ve developed connectors that take a 3rd party application’s API and map it to a standardised format, greatly simplifying the process of integrating multiple services. REST can speak to SOAP can speak to GraphQL can speak to CSV and so on.

Can I add Custom Scripting to my Integrations?

In order to service more rigid, complex systems you may need to add the script to your integration to function as desired.

Cyclr assists with this by giving you the ability to add your own custom JavaScript code within your integrations, at the step level.

You can write a script to call external API endpoints. This is especially useful if the API returns a URL which contains the real response object.

Complex objects need not be a problem. Adding in additional code to handle key-value pairs will allow you to retrieve data in a useful way, which can be used in further steps in your integration workflow.

It’s even possible to handle custom 3rd party API errors and status codes, giving you tighter control over error handling.

In Step Integration Scripting

Integration Toolkit Developments to Come

SaaSs are ever-evolving and changing, which is why Cyclr is constantly developing and striving to make users’ integration experience better.

As well as a continuous stream of new connectors to integrate between, we’re working on new tools to assist users with building advanced integration quicker and more robustly.

These developments include auto field mapping, for faster building, and programmable logic steps, expanding the possibilities of our logic tools for managing data in transit.

Expect to see new developments and tools in the near future, all with the aim of giving you the most powerful and flexible data orchestration tools available.

Other Orchestrate Data Resources

About Author

Avatar for Daniel Twigg

Daniel Twigg

With over 12 years experience in the Digital Marketing arena, covering industries including IoT, SaaS, fitness, computer gaming and music, Daniel has been Cyclr's marketing manager from the early days of the platform. Follow Daniel on LinkedIn

Ready to start your integration journey?

Book a demo to see Cyclr in action and start creating integration solutions for your customers

Recommended by G2 users