How to get output of http request in JSON file?

Question

I am making a http get request to a url and I am able to get data from that web page but I am not able to store it in JSON format and also not able to interpret data and get the required data.I am using ASP.NET and C# for it.

This is code for my CS file:

    using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Net;
using System.IO;
using Newtonsoft.Json;

namespace httprequest_web
{
    public partial class req : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            try
            {
                string baseu = "http://railenquiry.in/runningstatus/";

                string url = string.Concat(baseu, TextBox1.Text);
                var request = WebRequest.Create(url);
                string text;
                var response = (HttpWebResponse)request.GetResponse();

                using (var sr = new StreamReader(response.GetResponseStream()))
                {
                    request.ContentType = "application/json; charset=utf-8";
                    text = sr.ReadToEnd();
                }
                Label1.Text = text;
            }
            catch
            {
                Label1.Text = "No Data Found";
            }
            }

        }
    }

and screenshot of output I am receiving is:

I want to take output in a well structured JSON file and only want name of station, time of arrival and time of departure in it. Please tell me how to do it?

railenquiry.in/runningstatus is a web page... it doesn't return json? — Alex
– Alex, Commented Jul 24, 2015 at 8:41
in order to 'read' JSON the URL you're requesting must return json - this is just a normal web page. You'll need to scrape the returned html instead — Alex
– Alex, Commented Jul 24, 2015 at 8:43

wilovent · Accepted Answer · 2015-07-24 08:47:51Z

0

Take a look at this project : HtmlAgilityPack But you need to ask the owner of the website before using his data

answered Jul 24, 2015 at 8:47

wilovent

1,3741 gold badge12 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2017-05-23 11:51:11Z

0

The URL you're requesting is just a normal web page, it doesn't return JSON.

You'll need to scrape the response, in order to do what you want.

Take a look at this question for examples using HtmlAgilityPack:

Parsing HTML Table in C#

edited May 23, 2017 at 11:51

CommunityBot

11 silver badge

answered Jul 24, 2015 at 8:48

Alex

38.6k55 gold badges217 silver badges340 bronze badges

3 Comments

sikrigagan Over a year ago

Can you tell me how can I read the data I need and then export it in JSON file?

Alex Over a year ago

Take a look at the example link - We're not here to do your work for you!

EZI Over a year ago

@sikrigagan There isn't a simple rule to get your data. Every page has its own rules. You should read some documents.....

Collectives™ on Stack Overflow

How to get output of http request in JSON file?

2 Answers 2

Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related