Extract specific JSON data with Transformation integration connector

JSONata is a powerful open-source language for querying and transforming JSON.

It helps extract specific meaningful data from it using a relatively simple logic that somewhat resembles the one used in Excel.

About Transformation integration connector

This is a private connector to work with the JSON in your integration flows and it was developed specifically to run on elastic.io platform.

Because of its role in the integration workflows, the Transformation integration connector only supports the action functionality, which means that you can use it to execute a certain event. In the case of this particular connector, you can perform even complex transformations while being in the process of mapping the systems and actually see whether you’re doing it the right way.

For example, you can remove a currency acronym from a price if the only thing you are interested in is the number, or split the field “Full name” into fields “First name” and “Last name”.

Due to the fact that it is under the proprietary license, you cannot change or extend this connector yourself. It comes by default in the elastic.io mapper. If you have any questions, you’re welcome to contact our pre-sales team at ps[at]elastic.io.

PLEASE NOTE: You need to be registered on the elastic.io integration platform in order to use the Transformation integration connector. You can sign up for a free 14-day trial here.