Developer activities

• JSON String - The string containing the JSON to be deserialized. The JSON should be written without indents, and between double quotes. Strings inside the JSON should be written with single quotes. For example, the following JSON is valid: "{'TenancyName': 'Documentation', 'UsernameOrEmail': 'Documentation', 'Password': 'Documentation'}".
• JSON Sample - A sample of the JSON used to generate the output object properties. The sample must be in JSON format. The activity converts this sample into a similar object that you can use during design time.

Advanced options​

Input​

• Serializer settings - Custom deserializer settings to be used when deserializing the JSON string. Use this property when you want to fully control how the JSON string is deserialized.
• Output type - A drop-down list that lets you choose the argument type of the object to deserialize into.
  Note:

  In Studio Web, generating the output structure from the JSON Sample property makes the Output type property read-only.

Output​

• JSON object - The deserialized JSON, returned as an object of the type selected in the Output type property. When the default type is used, the result is a Newtonsoft.Json.Linq.JObject variable. Read more information on Newtonsoft.Json.Linq.JObject objects.

1. Add a Deserialize JSON activity to your workflow.

2. In the JSON String field, enter the JSON to deserialize. For example: "{'name': 'John Doe', 'age': 30, 'address': {'city': 'New York'}}".

3. In the JSON Sample field, paste a representative sample with the same structure:

   assignment

   {
     "name": "John Doe",
     "age": 30,
     "address": {
       "city": "New York"
     }
   }
   {
     "name": "John Doe",
     "age": 30,
     "address": {
       "city": "New York"
     }
   }
   

   The activity reads the sample and generates an output object that mirrors this structure. The Output type property updates to the generated type.

4. In a subsequent activity, reference the deserialized values directly through the property names defined in your sample, for example JsonObject.name and JsonObject.address.city, instead of using JsonObject.SelectToken("name").

Result​

VB.NET​

New JsonDeserializationSettings With {
.MissingMemberHandling = JsonMissingMemberHandling.Ignore,
.NullValueHandling = JsonNullValueHandling.Ignore,
.DateParseHandling = JsonDateParseHandling.DateTime,
.DateTimeZoneHandling = JsonDateTimeZoneHandling.Utc,
.FloatParseHandling = JsonFloatParseHandling.Double
}
New JsonDeserializationSettings With {
.MissingMemberHandling = JsonMissingMemberHandling.Ignore,
.NullValueHandling = JsonNullValueHandling.Ignore,
.DateParseHandling = JsonDateParseHandling.DateTime,
.DateTimeZoneHandling = JsonDateTimeZoneHandling.Utc,
.FloatParseHandling = JsonFloatParseHandling.Double
}

C#​

new JsonDeserializationSettings
{
MissingMemberHandling = JsonMissingMemberHandling.Ignore,
NullValueHandling = JsonNullValueHandling.Ignore,
DateParseHandling = JsonDateParseHandling.DateTime,
DateTimeZoneHandling = JsonDateTimeZoneHandling.Utc,
FloatParseHandling = JsonFloatParseHandling.Double
}
new JsonDeserializationSettings
{
MissingMemberHandling = JsonMissingMemberHandling.Ignore,
NullValueHandling = JsonNullValueHandling.Ignore,
DateParseHandling = JsonDateParseHandling.DateTime,
DateTimeZoneHandling = JsonDateTimeZoneHandling.Utc,
FloatParseHandling = JsonFloatParseHandling.Double
}

Properties panel​

Common​

• DisplayName - The display name of the activity.

Input​

• JSON Sample - The JSON sample for the output structure. The activity converts this sample into a similar object which you can use during design time.
• JsonString - The string containing the JSON to be deserialized. Write the JSON without indents, and between double quotes. Strings inside the JSON should be written with single quotes. For example, the following JSON is valid: "{'TenancyName': 'Documentation', 'UsernameOrEmail': 'Documentation', 'Password': 'Documentation'}".

Misc​

• Private - If selected, the values of variables and arguments are no longer logged at Verbose level.
• TypeArgument - A drop-down list that enables you to select the type of output returned. The provided JSON string will be converted to an object of the selected type.

Output​

• JsonObject - The deserialized JSON, as a Newtonsoft.Json.Linq.JObject variable. Read more information on Newtonsoft.Json.Linq.JObject objects.

1. Open Studio and create a new Process.
2. Drag a Sequence to the Workflow Designer.

   • Create the following variables:

     Variable Name	Variable Type	Default Value
     JsonText	String
     JsonObj	JObject
     Age	GenericValue

3. Drag a Read Text File activity inside the sequence container.
   • In the Properties panel, add the value "JsonString.txt" in the FileName field.
   • Add the variable JsonText in the Content field.
4. Add a Deserialize JSON activity after the Read Text File activity.
   • In the Properties panel, add the variable JsonText in the JsonString field and the variable JsonObj in the JsonObject field.
   • Select the value Newtonsoft.Json.Linq.JObject from the TypeArgument drop-down list.
5. Place an Assign activity under the Deserialize JSON activity.
   • Add the variable Age in the To field and the expression JsonObj.SelectToken("age").ToString in the Value field.
6. Drag a Write Line activity after the Assign activity.
   • Add the variable Age in the Text field.
7. Run the process. The robot extracts the age value from the .json file and displays it in the Output panel.