Deserialize JSON dynamic array

Tommy

Hey guys,

I have JSON string:

{"results": {
"0001": [{
"type": "AA",
"Id": "420",
"service": false,
"description": "",
"imageUrl": "http://www.somelink.com/file.jpg",
"date": "1457608735000"
},
{
"type": "CC",
"Id": "114",
"service": true,
"description": "",
"imageUrl": "http://www.somelink.com/file.jpg",
"date": "1457611015000"
}]
}
}

In this example array 0001 will be dynamic id in numbers, it will be always random number. How can I deserialize this string into right order? I need to receive type, Id, service, description, imageUrl, date of the very last object (the one who's "type":"CC").

Please, somebody help. Thank you.

10 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajeev Punhani10y ago
Accepted answer
Hi Tommy,
Please find the below fiddle.
https://dotnetfiddle.net/JoPBu1
If the above solution is helpful then,accept the answer.
+2
Tommy10y ago
I'd like to thank you from the bottom of my heart to you all whotried to help me.
Rajeev Punhani- you really are a star of this one. Thank you so much, your code is exactly what I've been looking for.
+1
Ravi Sangtani10y ago
Hey Tommy,
try this code it may help you.
------------------------Code--------------------------
try
{
//Your Json Text
string json = "{\"0001\":[{\"type\":\"AA\",\"Id\":\"420\",\"service\":false,\"description\":\"\",\"imageUrl\":\"http://www.somelink.com/file.jpg\",\"date\":\"1457608735000\"},{\"type\":\"CC\",\"Id\":\"114\",\"service\":true,\"description\":\"\",\"imageUrl\":\"http://www.somelink.com/file.jpg\",\"date\":\"1457611015000\"}]}";
JObject obj = JObject.Parse(json);
//JArray a1 = (JArray)obj["items"];
for (int i = 0; i < obj.Count; i++)
{
foreach (var v in obj)
{
MessageBox.Show(v.Key.ToString());
JArray a1 = (JArray)v.Value;
foreach(var aa in a1)
Console.WriteLine(aa["type"].ToString());
}
}
}
catch (Exception) { }
------------------End Code------------------------
If it will help you then please approve my answer.
Thank you
(Ravi D. Sangtani)
+1
Tommy10y ago
Thank you to those who tried to help and offered their examples. But I'm looking for a different solution. Anyone has other ideas to this? Also, I need to have foreach() in the code.
0
Suthish Nair10y ago
try something like this...
const string j = "{\"0001\":[{\"type\":\"AA\",\"Id\":\"420\",\"service\":false,\"description\":\"\",\"imageUrl\":\"http://www.somelink.com/file.jpg\",\"date\":\"1457608735000\"},{\"type\":\"CC\",\"Id\":\"114\",\"service\":true,\"description\":\"\",\"imageUrl\":\"http://www.somelink.com/file.jpg\",\"date\":\"1457611015000\"}]}";
var serializer = new JavaScriptSerializer();
dynamic s = serializer.Deserialize(j);
+1
Tommy10y ago
No Suthish. Any ideas?
0
Suthish Nair10y ago
Tommy, did above reply helped your problem?
0
Tommy10y ago
Thank you both but this is not what I'm after. I know you are trying to help. Hima, I think you got my question wrong. Array is going to be dynamic, constantly changing. You set that as values (1, 2, 3 etc). Id will also be dynamic, based on the id received from json file. Please, can somebody help me with this bit of the code? I am looking for simple foreach() thanks.
0
kalu singh rao10y ago
you can deserialize json data in string, use in jquery code as given below.
var data = JSON.parse(JSONObject);
+1
Hima Bindu10y ago
With latest json you can use dynamic keyword to get this done
dynamic d = JObject.Parse("{id:114,type:'string', array: [1,2,3,4,5,6]}"); Console.WriteLine(d.id); Console.WriteLine(d.type); Console.WriteLine(d.array.Count);

+1