Please help to deserialize my JSON file on C#

Question

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.

Rajeev Punhani · 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.

Tommy · Answer

Anyone else has anymore ideas?

Raja T · Answer

HiTry 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

Tommy · Answer

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!

Tommy · Answer

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 T · Answer

Hi i try like i have done one static json file to deserialize . 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(); } }

Please, help to deserialize my JSON file on C#