JSON Transformation

The JSON Transformation tool is a step that transforms simple and complex JSON data using JSONata language.

Next, learn how to add it to the canvas and configure its form.

Add JSON Transformation to the Canvas

  1. Click on the icon tool icon with plus sign on the left editing menu.

  2. Select JSON Transformation to add it to the canvas. You can use the search bar search steps icon to find it.

    You can add it as many times as you need. In this case, each time you add this tool, a number is added next to its name (JSON Transformation 1, JSON Transformation 2, JSON Transformation 3).
  3. Connect JSON Transformation to the flow steps. This tool can connect to a previous step and a following step.

To copy the step, click the copy icon button. If the step form is already configured, the settings will be copied too.

To remove JSON Transformation from the canvas, select it and click the trash can icon trash can icon.

Configure the Form

  1. Select JSON Transformation on the canvas.

  2. Click the pencil icon editing icon.

  3. Fill in the following form fields:

    • Name: enter a unique name for the step. By default, you will see it as "JSON Transformation".

    • Input Data: select the step and its payload of origin to apply the data transformation. You will see the connector’s request and response data and the request data from the trigger.

  4. Click the GO TO JSONATA button open in newIcon. You will be redirected to the JSONata Exercise.

  5. Ask the application provider for the data model for your input mapping.

  6. Enter the data model on the left side of the screen.

  7. Build your script in the top right-hand corner of the screen using the JSONata language. If you have any doubts, you can refer to JSONata documentation.

  8. Use version 2.0.x. You can find it in the top right-hand corner of the screen.

  9. Copy the finished script.

  10. Return to the JSON Transformation screen on Sensedia Integrations.

    • In the JSONata field, paste the script obtained in step 7 and copied in step 9 to map the data for the transformation process.

      If the script has any errors, you will see an error message in red in the bottom right corner of this field.
  11. Click SAVE.

Setting up a script in JSONata Exercise

jsonata en

To use the response in connectors, see the documentation for Data Mapping with Full Body.
Thanks for your feedback!
EDIT
How useful was this article to you?