DeserializeJsonArray

Estimated reading: 4 minutes

This activity is used to convert the details of an input file, a JSON object or a variable to an array of data. An array of data is a list of values. (Navigate to the bottom of this page to download the sample file for this activity).

Properties

MISC

Display Name: Displays the name of the activity. You can also customize the activity name to help in troubleshooting.

SkipOnError: It specifies whether to continue executing the workflow even if it throws an error. This supports only Boolean value “True or False.”
True: Continues to execute the workflow irrespective of any error thrown.
False: The workflow aborts if it throws any error.

Version: Specifies the version of the Json feature in use.

OUTPUT

JsonArray:* It helps to view the output of the JSON file in an array format.

Result: Returns the success state of the activity in Boolean value.

* Represents mandatory fields to execute the workflow

Use Case

The following usecase helps us to understand how the deserialization of JSON is used in the workflow. Here the input is a JSON file which contans a combination of mixed variables such as name of the person,age and name of the car.

The following are the scenarios covered in the example.

Scenario 1: Utilizing the input file to iterate and convert the values to an array format.
Scenario 2: Utilizing the array variable to iterate and convert the values to Jobject.

Scenario 1

In the following steps, we are using the deserialize Json array and ForEach activity to iterate and convert each value to an array format from the input file.

Steps to execute the bot

1. Drag and drop the deserialize Json array activity into the Get Json Object activity.
2. Declare a variable here in the JsonArray box of the output segment. Here it is Jarray.
3.Drag and drop a ForEach activity into the workflow.
4. Navigate to the property section and change the Type Argument as Object from the drop down.
5. Now we need to assign a value for each item in the Foreach activity. Here the value for ForEach is changed from “item to obj” as it is the variable declared above, which is Jarray.

Scenario 2

It’s a continuation from scenario1. The input here will be the variable declared (Obj) in ForEach activity. From this variable (Obj) we are going to iterate and convert the Jobject value and get the key and value for each property.

6. Now drag and drop a sequence activity into the Foreach activity.
7. Drag and drop a deserialize json object activity into the sequence.
8. Click on the activity and navigate to the property window, specify the input variable as obj.ToString().
9. Declare a variable in the JsonObject box of the output segment in the Deserialize Json Object property window. Here it isJObject.
10. Drag and drop another ForEach activity below this activity as the values stored in the variable is stored as JObject and we need to extract each property from it.
11. Click on the for each activity in the workflow and navigate to the property section. Change the Type Argument asJProperty.
12. Nowwe need to assign a value for each item in the Foreach activity. Here the value for ForEach is changed from “item to prop” and in is the variable declared above, which is JObject.properties.
13. Now drag and drop two write line activities below this, as we have two different properties for three different objects. For example we have a key which is “name” and we have a value for that which is “XXXX1″.
14. So let’s use a “key” and “value” tag for each property that we extract from the above JObject.
15. Here the input string that we use is“Key : ” + prop.name.tostring() “Value : ” + prop.Value.ToString() Use this as the input string in each of the write line activity.
16. Execute the workflow.

The bot executes the activity, converts the given json file to an array of data and then uses the deserialize json object activity to deserialize the array of data and give an output as individual detail. Please find the attached Sample Json file for reference below in creating a workflow.

DeserializeJsonArray

Properties

Use Case

Scenario 1

Scenario 2

DeserializeJsonArray

CONTENTS