Deserialze Jason for particular value

[Sahil_Garg1]

Hi Everyone,

I have one jason api

{
Name : XYZ
Age : 23
},
{
Name : ABC
Age : 25
},

I wanted to deserialze age key for particular value of name coming as input.

Can anyone guide me on this ?

Regards,
Sahil Garg

[ppr (Peter)]

we can do filtering with the help on LINQ and get the age

Your JSON snippet is incompletet. Please let us know the full JSON as we have to know if the JObjects are nested into another jobject or items of a JArray

[ppr (Peter)]

but you can tell us if it resides within an object or are items of JArray

[Sahil_Garg1]

It is inside JArray

[ppr (Peter)]

Find some starter help

myJArray.ToString
@"[
{
““Name””: ““XYZ””,
““Age””: 23
},
{
““Name””: ““ABC””,
““Age””: 25
}
]"

 myJArray.Where(Function(x) x("Name").Value(Of String).Equals("ABC"))
 Enumerable.WhereEnumerableIterator<JToken> { JObject(2) { JProperty(1) { [ABC] }, JProperty(1) { [25] } } }
 myJArray.Where(Function(x) x("Name").Value(Of String).Equals("ABC")).First()("Age").Value(Of Int32)
 25

[ppr (Peter)]

As an alternate we can also use the SelectToken method along with a filter statement
JSONPath - XPath for JSON

[Sahil_Garg1]

Hi Peter,

This is good one, but just wanted to know

I wanted to convert Age key into datatable, i have dt Variable with speicifc columns name,

Apologies if my eg is not clear.

{
Name : ABC
Age : [{“Value”:“77014”,“Code”":“26”}]
}

Age key is like this format, for that i need to deserialize it

[Sahil_Garg1]

Can u guide me if i can use any expression , so that for a particular input name i can deserialize Age key

[ppr (Peter)]

feel free to:

• split it into sub statements and using variables
• adopt it to a more dynamic value grabbing e.g.

[Sahil_Garg1]

Mate,

Adding toArray one is fine, but it is not taking JArray variable, is this deserializing same ?

[ppr (Peter)]

@Sahil_Garg1

Adding toArray one is fine, but it is not taking JArray variable

unclear what was meant with this.

For shortcutting it:

• provide sample input data, reflecting in the same way your JSON data is about
• provide expected output

Based on this we will check.

[Sahil_Garg1]

[
{
“Id”: “2331”,
“Data”: “[{“Code”:“77014”,“Modifiers”:“26”}]”
},
{
“Id”: “2332”,
“Data”: “[{“Code”:“741778”,“Modifiers”:“26”}]”
}
]

Check this one, i have j array of this api, now just finding how can i deserialize Data key for input Id ( into Data JArray), so that i can convet same in Datatable.

Output

JArray Variable which is having data of Data key, for ID 2332.

[ppr (Peter)]

expected output / result?

[Sahil_Garg1]

Edited same mate

[ppr (Peter)]

@Sahil_Garg1

JArray Variable which is having data of Data key, for ID 2332.

vs.

@Sahil_Garg1

so that i can convet same in Datatable.

this confusing us

[Sahil_Garg1]

Peter,

I just need JArray for data key.

I will loop through same to convert in datatable for specific columns.

Challenge i am facing,

I am not able to access particular block for input ID.

[Sahil_Garg1]

Adding to above,

Like a filter so that i can access particular data key

[Sahil_Garg1]

@ppr

myJArray.Where(Function(x) x("Name").Value(Of String).Equals("ABC")).First()("Age").Value(Of Int32)

Hi Peter,

I just used this expression, getting the string of particular block which can be deserialized.

Thanks you your guidance, will ping you again if any issues come.

Regards,
Sahil Garg

[ppr (Peter)]

@Sahil_Garg1

[
{
“Id”: “2331”,
“Data”: “[{“Code”:“77014”,“Modifiers”:“26”}]”
},
{
“Id”: “2332”,
“Data”: “[{“Code”:“741778”,“Modifiers”:“26”}]”
}
]

Check t

have a look on this : “[{“Code”:“741778”,“Modifiers”:“26”}]”

if your JSON looks in this way we have the case that the value of Data is a serialized JObject / Dictionary

we filter to the particular JObject
then we can parse / deserialize the JSON string back to a JOBject