Parsing web page to JSON

Question

I want to parse data from a web page and store it to a JSON file and use it when needed on ASP.NET webform web page. Please tell me how to do that? For example take this URL: http://www.railyatri.in/time-table/19718-chandigarh-jaipur-intercity-cdg-to-jp I want to parse name of station, time of arrival and time of departure in JSON file which I can later on use to display on my ASP.NET webform page.

Manas Mohapatra · Answer

Hi, Below link will help you to implement: https://jamessdixon.wordpress.com/2012/11/20/consuming-json-from-a-c-project/

Gagan Sikri · Answer

Hi Manas Actually the thing is I have to take input from user which is train number and then send a http get request to this url: http://railenquiry.in/runningstatus/ train_number / date and the stream of data which will be received, I have to store that data in JSON format. Can you show me a little demo how can I do that just show me by getting only name of stations to JSON.

Manas Mohapatra · Answer

Hi Gagan Just go through below link and understand what is JSON and where it is used.. http://www.tutorialspoint.com/json/ Secondly if you want to work display in client side then see below code Code Customers var xmlhttp = new XMLHttpRequest(); var url = "http://www.w3schools.com/website/Customers_MYSQL.php"; xmlhttp.onreadystatechange=function() { if (xmlhttp.readyState == 4 && xmlhttp.status == 200) { myFunction(xmlhttp.responseText); } } xmlhttp.open("GET", url, true); xmlhttp.send(); function myFunction(response) { var arr = JSON.parse(response); var i; var out = " "; for(i = 0; i out += " " + arr[i].Name + " " + arr[i].City + " " + arr[i].Country + " "; } out += " "; document.getElementById("id01").innerHTML = out; }

Gagan Sikri · Answer

I used a try catch block, its displaying me error message in catch block. Can you show me how can I do it by giving me tutorial for the scenario I explained, actually I have never worked with JSON and data parsing.

Manas Mohapatra · Answer

Hi, What is the exception you are getting when you are using above code? Please paste json data what are getting from the URL. Based on json data you need to parse(like I said declare a class with all attributes which are in json data) and display in your website.

Gagan Sikri · Answer

Hi Manas The code you provided is not working. Let me explain the scenario: Consider this URL: Click Here we have a ASP.NET web page and on that page there is a text box and a button. In textbox user will input the train number and we have to parse data from the url mentioned above. For eg user inputs train number: 19717 then url will be: http://railenquiry.in/runningstatus/ 19717 / 2015-07-24 I want to parse the name of stations and time of arrival and departure from data on this website in JSON file which I can later on use to display on my ASP.NET webpage.

Manas Mohapatra · Answer

Hi Gagan, Whatever code I provided is not working(throwing exception) or it doesn't meet requirement? Secondly please describe more what you need exactly?

Gagan Sikri · Answer

I am trying this solution you provided, but its not working, can you show me how to do parsing of data from a webpage. Let us take example of this URL . I simply need to generate a JSON containing station names.

Manas Mohapatra · Answer

Hi Gagan, As per your requirement please find below steps: Step 1 : Declare a station class. public class Station { public string name { get; set; } public DateTime arrival { get; set; } public DateTime departure { get; set; } } Step 2 : Add namespace using System.Web.Script.Serialization; Create a station list. For now I hard coded it but for your case you can retrieve it from database. List stationList = new List () { new Station() { name = "st1", arrival = DateTime.Now, departure = DateTime.Now.AddMinutes(10) }, new Station() { name = "st2", arrival = DateTime.Now, departure = DateTime.Now.AddMinutes(10) } }; // Creating serialization object JavaScriptSerializer serializer = new JavaScriptSerializer(); string test = serializer.Serialize(stationList); // Writing sesrialization data to json file System.IO.File.WriteAllText(@"D:\station.json", test); Step 3 : Now our data is saved in json file, we will read data from it... // Read data from json file string text = System.IO.File.ReadAllText(@"D:\station.json"); List stationListBack = serializer.Deserialize >(text); // Looping over station list foreach (var temp in stationListBack) { Response.Write(temp.name + " || " + temp.arrival + " " + temp.departure + " "); }