JSON Deserialize issue

Learning Hub
1

Hi Guys,

I have a json like this

[{
“Result1”: 1,
“Result2”: 1,
“Result3”: 1,
“Name1”: “APPLE”,
“Name2”: “ORANGE”,
“Name3”: “BANANA”,
“Name4”: “GRAPS”,
“Columns”: [
{
“Name1”: “APPLE”,
“Name2”: “ORANGE”
},
{
“Name3”: “BANANA”,
“Name4”: “GRAPS”
},
{
“Name5”: “BANANA”,
“Name6”: “GRAPS”
}
]
}
]

here i want to split and need it as a separate text like

Result1 :1
Result2 :1
Result3 :1
Name1 :APPLE

like this inside the columns also…so how can i do this can any one help me out this.

Regards,
Saran.

2

Hi @suresh_kumar4,

Please use below format while defining json file

{
“Result1”: 1,
“Name1”: “APPLE”,
“Columns”:
{
“Columns”:
[
{ “Name1”: “APPLE”},
{ “Name2”: “ORANGE”},
]
}
}

use webapi.activities from uipath to Deserialize JSON and jsonoutput(“Result1”).ToString to retrieve the value.

Please mark as a solution if you found this useful

3

Use

jsonOutput.SelectToken(“Columns.Columns[0].Name1”).ToString

if you want to access nested json objects