Use the JsonArrayToArray component
Convert a JSON object to an array of objects using the JsonArrayToArray component in the RPA Desktop Design Studio.
Before you begin
Role required: none
About this task
To configure the properties for the JsonArrayToArray component, see Properties of the JSON utilities.
Procedure
In the Toolbox pane, navigate to Utilities > JSON.
Drag the JsonArrayToArray component to the Design surface.
In the Toolbox pane, navigate to General > Variable.
Drag the Variable component to the Design surface.
Double-click the variable and enter a script.
An example of a script.
[{ "name": "Abel Tutor", "age": 30, "email": "abletutor@example.com", }, { "name": "Alex Tutor", "age": 32, "email": "alextutor@example.com", }]To configure the input field, see Configure port properties.
Connect the data and control ports of the JsonArrayToArray component to the corresponding ports of the other components as described in the following table and image.
| Port type | Port name | Data type | Description |
|---|---|---|---|
| Data In | JsonObject | Object | The JSON object to be converted to an array of objects. |
| Data Out | Return | Object\[\] | Used to return an array of JObjects. Each JObject has the same set of properties with different values for each property.To modify the details of a JObject, iterate over the JObjects in the array returned until the criteria is met. |
JsonArrayToArray component extracts data from the script in the Variable component.
To test the component, right-click the component bar and then click Run From Here.
To view the complete data output, right-click the Data port of JsonArrayToArray component and select Preview Data.
JsonArrayToArray component with Variable component
Data preview of the JsonArrayToArray component after execution.
Parent Topic:JSON