JSON Parsing in Windows Phone using C#

Question

I am just learning JSON implementation in Windows Phone 8 app
I got link of Earthquake News feeding, I want to use below link and fetch the all data to my Windows Phone app, I am completely noob in this, so please tell me how I can implement it in simple way in C# language.
Link: http://earthquake-report.com/feeds/recent-eq?json

Ramesh Maruthi · Answer

I am unable to connect your team viewer string s = Convert.ToString(e.Result); DataContractJsonSerializer serializer = new DataContractJsonSerializer(typeof(List )); MemoryStream ms = new MemoryStream( Encoding.UTF8.GetBytes(s)); var list = (List )serializer.ReadObject(ms); TaskListBox.ItemsSource= list

Ramesh Maruthi · Answer

hey Aditya I agree with you and I know about Json.Net before 6 months it self when I used to work with mongodb using c# yesterday I was using trail windows sdk that to 2010 so it's hard to install extended packages I didn't find Nuget to do that anyways thanks once again it's good sharing knowledge with you and I have seen ur hard work and trouble as newbie keep going buddy all the best :)

Aditya Patil · Answer

Atlast worked for me too Thanx @Ramesh Sir for your big help

Ramesh Maruthi · Answer

ok try in this way final public class Earthquake { public string title { get; set; } public string magnitude { get; set; } public string location { get; set; } public string depth { get; set; } public string latitude { get; set; } public string longitude { get; set; } public string date_time { get; set; } public string link { get; set; } } public class Earthquakelist:List { } foreach(Earthquake q in jsondata ) { TaskListBox.ItemsSource = new Earthquakelist {Add (new Earthquake { title = q.title magnitude = q.magnitude location=q.location depth=q.depth latitude=q.latitudelongitude=q.longitudedate_time=q.date_timelink = q.link})}; }

Ramesh Maruthi · Answer

TaskListBox.ItemsSource = new Earthquake(){title = q.title magnitude = q.magnitude location=q.location depth=q.depth latitude=q.latitudelongitude=q.longitudedate_time=q.date_timelink = q.link}; SORRY close with flower brace and try it once if not I have another idea lets c with that

Ramesh Maruthi · Answer

did u try the above for each loop ?

Ramesh Maruthi · Answer

Hello Aditya Can you paste at least 2 items from a list of result json data what your getting at that point ? And can you give a try like this List jsondata = JsonConvert.DeserializeObject >(e.Result); foreach(Earthquake q in jsondata ) { TaskListBox.ItemsSource = new Earthquake() {title = q.title magnitude = q.magnitude............link =q.link) }

Zia ur Rehman · Answer

This link will make easy your life using JSON. http://nkishorchandra.blogspot.com/2012/10/parsing-json-in-windows-phone.html#comment-form

Ramesh Maruthi · Answer

Here is the code dude private void Updates_SelectionChanged(object sender SelectionChangedEventArgs e) { int index = Updates.SelectedIndex; MessageBox.Show(Index + index); if (Updates.SelectedIndex == -1) return; else { Earthquake s = (Earthquake) e.AddedItems[0]; string url = s.link; WebBrowserTask webBrowserTask = new WebBrowserTask(); webBrowserTask.Uri = new Uri(url UriKind.RelativeOrAbsolute); webBrowserTask.Show(); } }

Aditya Patil · Answer

WebBrowserTask webBrowserTask = new WebBrowserTask(); webBrowserTask.Uri = new Uri(eop.link UriKind.RelativeOrAbsolute); webBrowserTask.Show(); What parameter should pass at eop.link. When I click on 1st Index of listbox its link should open in WebBrowser if click on 5th Data then link of 5th should get open. Can anyone tell me the parameter so that it can take link of selected index. Please.

Aditya Patil · Answer

Hey I Binded properly all data to the Listbox and arranged in well mannner Atlast the big data can be seen in the whole screen too I want more help now getting stucked When I will click on one data or value it contain one link too I want to User should navigate to that link. How I can do that?

Aditya Patil · Answer

For JSON Parsing whatever you did its right but I think its long method. For parsing JSON content in the Windows Phone app there is Reference Json.NET which we can add in the references so it may be easy and least number of steps to parse JSON. Also I heard there is SimpleJson Reference id there nwhich also can help us to parse JSON easily no need to create Serializer and MemoryStream. So if you want to research go for Json.NET of Newtonsoft.JSON. may be helpful for us.

Ramesh Maruthi · Answer

string s = Convert.ToString(e.Result); //IEnumerable resu; DataContractJsonSerializer serializer = new DataContractJsonSerializer(typeof(IEnumerable )); MemoryStream ms = new MemoryStream( Encoding.UTF8.GetBytes(s)); var list = (IEnumerable )serializer.ReadObject(ms); List datasource = new List (); //Earthquakelist eyp = new Earthquakelist(); foreach (Earthquake eop in list) { datasource.Add(new Earthquake{title =eop.title magnitude = eop.magnitudelocation=eop.locationdepth=eop.depthlatitude=eop.latitudelongitude=eop.longitudedate_time=eop.date_timelink=eop.link}); } listBox1.ItemsSource = datasource;

Ramesh Maruthi · Answer

Dude its working for me now :)

Aditya Patil · Answer

I moved to other system try here if worked here check the code I written right or not? Please Join me Teamviewer details 593 940 517 6840

Ramesh Maruthi · Answer

Sorry Aditya Even I tried on mine pc its not displaying the Earthquake class items Its just displaying as EarthQuake as 32 times but in program at TaskListbox it showing me even the values but dont know y its not displaying there :(

Aditya Patil · Answer

I tried above code its not showing the Earthquake details on screen Teamviewer details 593 940 517 6840

Aditya Patil · Answer

944 847 769 3257

Ramesh Maruthi · Answer

Give your team viewer details

Aditya Patil · Answer

namespace Earthquake_Updates { public partial class MainPage : PhoneApplicationPage { // Constructor public MainPage() { InitializeComponent(); WebClient webClient = new WebClient(); webClient.DownloadStringCompleted += webClient_DownloadStringCompleted; ProgressBarRequest.Visibility = System.Windows.Visibility.Visible; webClient.DownloadStringAsync(new Uri(http://earthquake-report.com/feeds/recent-eq?json)); } void webClient_DownloadStringCompleted(object sender DownloadStringCompletedEventArgs e) { try { if (!string.IsNullOrEmpty(e.Result)) { //Parse JSON result List jsondata = JsonConvert.DeserializeObject >(e.Result).ToList(); ; foreach (Earthquake q in jsondata) { TaskListBox.ItemsSource = new Earthquakelist { Add(new Earthquake { title = q.title magnitude = q.magnitude location = q.location depth = q.depth latitude = q.latitude longitude = q.longitude date_time = q.date_time link = q.link }) }; } } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { ProgressBarRequest.Visibility = System.Windows.Visibility.Collapsed; } } } public class Earthquakelist : List { } public class Earthquake { public string title { get; set; } public string magnitude { get; set; } public string location { get; set; } public string depth { get; set; } public string latitude { get; set; } public string longitude { get; set; } public string date_time { get; set; } public string link { get; set; } } } My Current code Error still persist on Add As dzone link they added all items in public class MovieList : List Same way I tried to add all in public class Earthquakelist : List { } Its shows error to jsondata

Aditya Patil · Answer

Still Error remains at Add?? it creates new stub of Add

Ramesh Maruthi · Answer

Aditya Please try to implement in this way http://dotnet.dzone.com/news/how-bind-data-listbox-windows

Aditya Patil · Answer

Error for Add Error 2 The name 'Add' does not exist in the current context C:\Users\Aditya\Desktop\Earthquake Updates\Earthquake Updates\Earthquake Updates\MainPage.xaml.cs 37 72 Earthquake Updates

Aditya Patil · Answer

I closed it still same error at TaskListBox.ItemsSource = new Earthquake() Screenshot: http://prntscr.com/45ke4t Error Message Error 2 Cannot implicitly convert type 'Earthquake_Updates.Earthquake' to 'System.Collections.IEnumerable'. An explicit conversion exists (are you missing a cast?) C:\Users\Aditya\Desktop\Earthquake Updates\Earthquake Updates\Earthquake Updates\MainPage.xaml.cs 37 51 Earthquake Updates Error Screen: http://prntscr.com/45kekh

Aditya Patil · Answer

Getting Error Error 8 Cannot implicitly convert type 'Earthquake_Updates.MainPage.Earthquake' to 'System.Collections.IEnumerable'. An explicit conversion exists (are you missing a cast?) C:\Users\Aditya\Desktop\Earthquake Updates\Earthquake Updates\Earthquake Updates\MainPage.xaml.cs 37 51 Earthquake Updates for below code if (!string.IsNullOrEmpty(e.Result)) { //Parse JSON result List jsondata = JsonConvert.DeserializeObject >(e.Result); foreach(Earthquake q in jsondata) { TaskListBox.ItemsSource = new Earthquake(){title = q.title magnitude = q.magnitude location=q.location depth=q.depth latitude=q.latitudelongitude=q.longitudedate_time=q.date_timelink = q.link); //Error here } }

Aditya Patil · Answer

See Screenshot http://prntscr.com/45k8l5

Aditya Patil · Answer

@Ramesh I changed few code and then tried but I am not getting how to bind the data to the ListBox so help me. List jsondata = JsonConvert.DeserializeObject >(e.Result); I changed this code of line. My Whole code looks like this namespace Earthquake_Updates { public partial class MainPage : PhoneApplicationPage { // Constructor public MainPage() { InitializeComponent(); WebClient webClient = new WebClient(); webClient.DownloadStringCompleted += webClient_DownloadStringCompleted; ProgressBarRequest.Visibility = System.Windows.Visibility.Visible; webClient.DownloadStringAsync(new Uri(http://earthquake-report.com/feeds/recent-eq?json)); } void webClient_DownloadStringCompleted(object sender DownloadStringCompletedEventArgs e) { try { if (!string.IsNullOrEmpty(e.Result)) { //Parse JSON result List jsondata = JsonConvert.DeserializeObject >(e.Result); TaskListBox.ItemsSource = jsondata; } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { ProgressBarRequest.Visibility = System.Windows.Visibility.Collapsed; } } } public class Earthquake { public string title { get; set; } public string magnitude { get; set; } public string location { get; set; } public string depth { get; set; } public string latitude { get; set; } public string longitude { get; set; } public string date_time { get; set; } public string link { get; set; } } } I think jsondata getting whole data but how nto bind it with ListBox that don't know. So please solve that and Check code too that I am right or not?

Aditya Patil · Answer

When I run app on 2G network got above exception but Now I tried my app on Wifi the Exception is changed. Now I am getting below Exception Unhandled Exception: Newtonsoft.Json.JsonSerializationException: Cannot deserial ize the current JSON object (e.g. {name:value}) into type 'System.Collection s.Generic.List`1[ApiPost.position]' because the type requires a JSON array (e.g. [123]) to deserialize correctly. To fix this error either change the JSON to a JSON array (e.g. [123]) or chang e the deserialized type so that it is a normal .NET type (e.g. not a primitive t ype like integer not a collection type like an array or List ) that can be de serialized from a JSON object. JsonObjectAttribute can also be added to the type to force it to deserialize from a JSON object. Path 'positions' line 1 position 13. at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateObject(Js onReader reader Type objectType JsonContract contract JsonProperty member Js onContainerContract containerContract JsonProperty containerMember Object exis tingValue) at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateValueInte rnal(JsonReader reader Type objectType JsonContract contract JsonProperty mem ber JsonContainerContract containerContract JsonProperty containerMember Obje ct existingValue) at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.Deserialize(Jso nReader reader Type objectType Boolean checkAdditionalContent) at Newtonsoft.Json.JsonSerializer.DeserializeInternal(JsonReader reader Type objectType) at Newtonsoft.Json.JsonConvert.DeserializeObject(String value Type type Jso nSerializerSettings settings) at Newtonsoft.Json.JsonConvert.DeserializeObject[T](String value JsonSeriali zerSettings settings)

Aditya Patil · Answer

namespace Earthquake_Updates { public partial class MainPage : PhoneApplicationPage { // Constructor public MainPage() { InitializeComponent(); WebClient webClient = new WebClient(); webClient.DownloadStringCompleted += webClient_DownloadStringCompleted; ProgressBarRequest.Visibility = System.Windows.Visibility.Visible; webClient.DownloadStringAsync(new Uri(http://earthquake-report.com/feeds/recent-eq?json)); } void webClient_DownloadStringCompleted(object sender DownloadStringCompletedEventArgs e) { try { if (!string.IsNullOrEmpty(e.Result)) { //Parse JSON result var root1 = JsonConvert.DeserializeObject (e.Result); this.DataContext = root1; TaskListBox.ItemsSource = root1.title; } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { ProgressBarRequest.Visibility = System.Windows.Visibility.Collapsed; } } } public class Earthquake { public string title { get; set; } public string magnitude { get; set; } public string location { get; set; } public string depth { get; set; } public string latitude { get; set; } public string longitude { get; set; } public string date_time { get; set; } public string link { get; set; } } } What is wrong in Above code I am getting below Exception.

Aditya Patil · Answer

I am not understanding it at all also no proper information is available to parse JSON link to Windows Phone app Simple but Sweet. I am completely new to JSON and parsing of it.

Ramesh Maruthi · Answer

Hello Aditya Can you try in this way it just an example http://stackoverflow.com/questions/18120092/how-to-parse-the-json-data-in-windows-phone-8 http://blogs.msdn.com/b/wsdevsol/archive/2013/09/04/how-to-store-json-data-in-windows-phone-8.aspx