Object Handling

There are two object manipulation methods available in Flow Studio that are particularly important for creating a flow:

Multiple parameter inputs for JSONata transformation

With Flow Studio, you can manipulate data using JSONata code, sourced from various previous modules or different flow variables. To perform this operation, you need to use the "Data Transformation" module, which is a tool module in Skyone Studio.

To get started, in the editing and configuration window of the module in your flow, follow these steps:

1. Go to the "Source Data" tab;

2. Drag the variables from your flow into the "Value" column;

3. Choose the "Type of variable" (text, number, etc);

4. Give a name to the "Key".

You can also configure the variables you want using a JSON object in the "Source JSON" tab.

Completing the flow variables on the Source Data tab

When using "Data Source", note that the visualization can be done by clicking on the arrow located on the right side of the variable.

An example of how the data is displayed when you click on the variable

When you click "Next" on the "Data Transformation" module configuration screen, these variables should be accessed in the JSONata code as shown below:

JSON example:

{
  "data": {
    "date": "19 de dezembro",
    "offset": "0",
    "password": "pass123",
    "row_count": "5",
    "username": "integra.user"
  }
}

After writing the JSONata, click on "Execute". To finish the configuration, click "Save".

Handling variables

You can manipulate variables by clicking directly on the component parameters. This makes it easier to access and manipulate sub-objects or objects within the result parameters of the previous components, making the process more intuitive and straightforward.

To manipulate the variables, follow these steps:

1. Click on the arrow to the right of the variable in the "value" column.

2. In the Path field, note that there is a JSON base associated with it which you can change using brackets [ ]. Manipulate as necessary.

Example of manipulating the variable where we add [0].text to get a specific result

Accessing an Object's Internal Data

We often want to reference only one property within an object. To do that, we must specify it within the flow, even if that internal variable is not explicit, even if that internal variable is not explicit, so that we can use only what we need.

In the following example, the Data Transformation module, which precedes the module we are configuring in our flow, generates an object called data, whose content is as follows:

{
   "result": {
      "date":"19 de Dezembro",
      "username":"integra.user",
      "password":"pass123",
      "offset":"0",
      "row_count":"5"
   }
}

We can reference the internal variables of this object in another step of the flow. Using date as an example, you'll need to enter the path of the variable. You can perform the same operation using a SMOP, which allows you not only to reference, but also to perform operations with an object's internal parameters.

In the next example below, we use the date parameter from the Data Transformation module in param1 of a SMOP and, to create the expression, we reference the offset parameter, a flow parameter whose current value is "0":