Please, help to deserialize my JSON file on C#

Tommy

Hey smart people,

Hope you are all well. Please, can someone help me with my C# and json code, I'll be super grateful.

Here's the content of my mydata.json file which has to be loaded from URL

global.data.retrieve(
{
"Status": "SUCCESS",
"total": 3,
"results":
{
"Platform": [
{
"type": "AA",
"Id": "420",
"service": false,
"description": "",
"imageUrl": "http://www.somelink.com/file.jpg",
"date": "1457608735000"
},
{
"type": "BB",
"Id": "307",
"service": false,
"description": "",
"imageUrl": "http://www.somelink.com/file.jpg",
"date": "1457608782000"
},
{
"type": "CC",
"Id": "114",
"service": true,
"description": "",
"imageUrl": "http://www.somelink.com/file.jpg",
"date": "1457611015000"
}]
}
})

I've learnt a little about json, got to know what arrays and objects are but still stuck with my C# app.

Please guys, I need slight help with my code. I'm really stuck with it : (

On the click of the button I am looking to retrieve json data from the above file, which will be on the external web address: http://www.mydomain.com/mydata.json

By the way, I don't need all of the data. I'm looking to retrieve all json object data from "type":"CC" part only (in this case 3rd object).

I'm using json.net;

Another thing. Sometimes, mydata.json file might generate 3rd object "type":"CC" below twice or three times. However, the ID part on that CC will always be different.

{
"type": "CC",
"Id": "114",
"service": true,
"description": "",
"imageUrl": "http://www.somelink.com/file.jpg",
"date": "1457611015000"
}

If that to happen, I only need to retrieve data from the last "CC" object in this case.

Another case might happen is that sometimes mydata.json file will generate only first two objects "AA" and "BB". If this happens (IF type "CC" is not printed) I need in the code to have IF() statement, to determine what to do.

I very much need C# code to confirm (perhaps "success" label) that mydata.json content is loaded successfully before it will be shown on the window.

Please guys, can someone help me with the code bit? I need something simple, less messy.

I won't be able to give you a hug or contribute towards for your help, but definitely guarantee a genuine "Thank you" from a stranger. Hope this matters.

6 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 for you solution.
https://dotnetfiddle.net/0lNP9u
If the above solution is helpful then,accept the answer.
Tommy10y ago
Anyone else has anymore ideas?
Raja T10y ago
Hi,Try like
public void LoadJson()
{
using (StreamReader r = new StreamReader("file.json"))
{
string json = r.ReadToEnd();
List items = JsonConvert.DeserializeObject>(json);
}
}
public class Item
{
public int millis;
public string stamp;
public DateTime datetime;
public string light;
public float temp;
public float vcc;
}
dynamic array = JsonConvert.DeserializeObject(json);
foreach(var item in array)
{
Console.WriteLine("{0} {1}", item.temp, item.vcc);
}
More details check below links
http://stackoverflow.com/questions/13297563/read-and-parse-a-json-file-in-c-sharp
http://stackoverflow.com/questions/18538428/loading-a-json-file-into-c-sharp-program
http://www.newtonsoft.com/json/help/html/ReadJson.htm
Tommy10y ago
Hi Rajeev, I think your solution is what I am looking for and before I mark yours as accepted answer, couple of things. How wpuld you put your code that json will bw loaded from external url. Also, I am looking for if() statement to confirm that json data was succesfully received from the url. Also, allow me to explain how would I use this. Basically I got datagridview and each row will have a jason link to load json string from. I'm a little confused with the classes that has get set in each value. I understand those will be made public strings. So what if I need to use this class multiple times on same occasion? Because I've got 4 or 5 rows to load data from different json url with different data under same values. Worried. Please help. Thank you so much. You rock!
Tommy10y ago
Hi Raja T, thank you for your replay. I really appreciate you wanted to help and tried to lead me onto something. Please forgive me, but this is not what what I am after. I am looking for the code, which loads json file from external link online, then gets me the information which I need to retrieve. Thank you once again for offering your help. Have a good day.
Raja T10y ago
Hi, i try like, i have done one static json file todeserialize. Add one dll newtonsoft.json ..i have attached file in that all is there with dll also pls refer
for example
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
// string jsonstr = "{ \"Status\": { \"StatusCode\":\"143\", \"SubStatus\":\"0\", \"Description\":\"Ok\" }, \"ListofCredDetails\": [{ \"Client\":\"a\", \"CredID\":111, \"CredUserID\":\"abc\" },{ \"Client\":\"b\", \"CredID\":112, \"CredUserID\":\"def\" },{ \"Client\":\"c\", \"CredID\":113, \"CredUserID\":\"ghi\" }] }\"";
string jsonstr = "{ \"Status\": { \"StatusCode\":\"143\", \"SubStatus\":\"0\", \"Description\":\"Ok\" }, \"ListofCredDetails\": [{ \"Client\":\"a\", \"CredID\":111, \"CredUserID\":\"abc\" },{ \"Client\":\"b\", \"CredID\":112, \"CredUserID\":\"def\" },{ \"Client\":\"c\", \"CredID\":113, \"CredUserID\":\"ghi\" }] }\"";
JObject jsonDes = JObject.Parse(jsonstr);
string statuscode = jsonDes["Status"]["StatusCode"].ToString();
string SubStatus = jsonDes["Status"]["SubStatus"].ToString();
string Description = jsonDes["Status"]["Description"].ToString();
string Client1 = jsonDes["ListofCredDetails"].ElementAt(0)["Client"].ToString();
string CredID1 = jsonDes["ListofCredDetails"].ElementAt(0)["CredID"].ToString();
string CredUserID1 = jsonDes["ListofCredDetails"].ElementAt(0)["CredUserID"].ToString();
string Client2 = jsonDes["ListofCredDetails"].ElementAt(1)["Client"].ToString();
string CredID2 = jsonDes["ListofCredDetails"].ElementAt(1)["CredID"].ToString();
string CredUserID2 = jsonDes["ListofCredDetails"].ElementAt(1)["CredUserID"].ToString();
string Client3 = jsonDes["ListofCredDetails"].ElementAt(2)["Client"].ToString();
string CredID3 = jsonDes["ListofCredDetails"].ElementAt(2)["CredID"].ToString();
string CredUserID3 = jsonDes["ListofCredDetails"].ElementAt(1)["CredUserID"].ToString();
}
}