How to convert JSON to Dictionary

Help Studio
, ,
1

Hi Team,

How to convert JSON to Dictionary? Inside the JObject I can see multiple Object.

Sample JSON Object:
{
“Name”: “ABC”,
“Age”: 30,
“Location”: {
“City”: “Bangalore”,
“Country”: “India”
},
“Skills”: {
“Sport”: “Cricket”
“Technology”: “UiPath”
“Language”: “English”
}

I need to add all the Values to dictionary.
Name
Age
City
Country
Sport
Technology
Language

I need above value should add to Dictionary.

2

Hi!

Parse the string into a JObject
Then create a new dictionary and add the key-value pairs
Heres how you retrieve the values using the JObject:

dict("Name") = jsonObject("Name").ToString()
dict("Age") = jsonObject("Age").ToString()
dict("City") = jsonObject("Location")("City").ToString()
dict("Country") = jsonObject("Location")("Country").ToString()
dict("Sport") = jsonObject("Skills")("Sport").ToString()
dict("Technology") = jsonObject("Skills")("Technology").ToString()
dict("Language") = jsonObject("Skills")("Language").ToString()
3

I dont want to do any hardcode assign it should take automatically what ever the key have bot Take key and value from json

4

A generic parsing into a dictionary would work if that json was structured like this, ie just a list of key-value pairs with JsonConvert.DeserializeObject( of Dictionary(of String,Object)) ( yourJSONasAString)
{
“Name”: “ABC”,
“Age”: 30,
“City”: “Bangalore”,
“Country”: “India”,
“Sport”: “Cricket”,
“Technology”: “UiPath”,
“Language”: “English”
}
But since it’s nested you have to go the long way around

You could either do as I’ve mentioned or you have to use a coded workflow to define a new object and then use that object together with jsonconvert to parse your json to into that new object, and then retrieve the values from that new object.
How to deserialize JSON in C# - .NET | Microsoft Learn

5

@copy_writes,

Use this logic.

The image depicts a workflow in UiPath Studio that reads a JSON file, deserializes it, iterates through its properties, logs each property, and handles nested JSON objects recursively. (Captioned by AI)
The image depicts a workflow in UiPath Studio that reads a JSON file, deserializes it, iterates through its properties, logs each property, and handles nested JSON objects recursively. (Captioned by AI)807×1600 67.9 KB

Variables:

The image shows a table listing three variables (jsonString, dictOutput, jObject) with their corresponding types, scopes, and default values within a JSONDemo context. (Captioned by AI)
The image shows a table listing three variables (jsonString, dictOutput, jObject) with their corresponding types, scopes, and default values within a JSONDemo context. (Captioned by AI)1068×136 10.8 KB

Output:
The image displays the debugger output from a code execution environment, showing a dictionary with keys such as "Name," "Age," and "City," and their corresponding values. (Captioned by AI)

Code:
JSONDemo.xaml (12.6 KB)

Thanks,
Ashok :slight_smile:

2 Likes
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.