How can I parse a JSON string using ASP.NET?

Question

I am using Sendgrid API to send and retrieve statistics of mail sent. I want to store the response of API in database.

protected void btnBounces_Click(object sender, EventArgs e)
{
    try
    {
        string url = "https://api.sendgrid.com/api/bounces.get.json";
        GetResult(url);
    }
    catch (Exception ex)
    {
        lblError.Text = ex.Message.ToString();
    }
}
 public void GetResult(string url)
{
    string parameters = "api_user=xxxx&api_key=xxxx&date=1&start_date="+txtStartDate.Text+"&end_date="+txtEndDate.Text;
    // Start the request
    HttpWebRequest req = (HttpWebRequest)HttpWebRequest.Create(url);
    req.Method = "POST";
    req.ContentType = "application/x-www-form-urlencoded";
    StreamWriter streamWriter = new StreamWriter(req.GetRequestStream());
    streamWriter.Write(parameters);
    streamWriter.Flush();
    streamWriter.Close();
    // Get the response
    HttpWebResponse res = (HttpWebResponse)req.GetResponse();
    StreamReader streamReader = new StreamReader(res.GetResponseStream());
    string result = streamReader.ReadToEnd();
}

The response I will get will be like:

[
  {
    "status": "4.0.0",
    "created": "2011-09-16 22:02:19",
    "reason": "Unable to resolve MX host sendgrid.ne",
    "email": "[email protected]"
  },
  {
    "status": "4.0.0",
    "created": "2011-09-19 17:47:15",
    "reason": "Connection timed out",
    "email": "[email protected]"
  }
]

How can i extract value of each of the four fields and store them in table containing four fields?

Thanks Nagaraj S for editing my question but I want answer. Help me. — Ami
– Ami, Commented Jan 28, 2014 at 11:58
There are many ways to do this. What kind of database are you using? — bwest
– bwest, Commented Jan 29, 2014 at 16:44
So your question right now is extremely broad. It's basically "how do I interact with a mysql database using ASP.NET" and there a lot of ways to do that. What are you using to interact with the database from code right now? If you don't have any way to do that, you should do some research and choose a method, and then I can help you with the sendgrid-specific stuff. — bwest
– bwest, Commented Feb 5, 2014 at 16:37
I will be using SqlClient. This is not important. I just want to kno that how can I extract each value from reply. — Ami
– Ami, Commented Feb 6, 2014 at 6:16

Rafa Paez · Accepted Answer · 2014-02-23 17:49:27Z

4

If you do not want to create a Movie class, you can use System.Web.Script.Serialization to parse and get a dynamic object.

JavaScriptSerializer js = new JavaScriptSerializer();
dynamic movie = js.Deserialize<dynamic>(json);

answered Feb 23, 2014 at 17:49

Rafa Paez

4,87023 silver badges35 bronze badges

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

1 Comment

Andrey Burykin Over a year ago

It requires System.Web.Extensions reference.

bwest · Accepted Answer · 2014-02-06 16:38:49Z

3

To read a JSON string in .NET, I recommend using Newtonsoft Json.NET.

Here is a simple example of deserializing a string into an object and reading a property:

string json = @"{
  'Name': 'Bad Boys',
  'ReleaseDate': '1995-4-7T00:00:00',
  'Genres': [
    'Action',
    'Comedy'
  ]
}";

Movie m = JsonConvert.DeserializeObject<Movie>(json);

string name = m.Name;
// Bad Boys

Note that you will have to define the object that you want to deserialize the values into ahead of time; you can see that in this example there is a Type Movie that already exists, and the JsonConverter matches the properties in the JSON string to the properties of that type.

edited Feb 6, 2014 at 16:38

answered Feb 6, 2014 at 16:19

bwest

9,8923 gold badges31 silver badges60 bronze badges

Comments

Ami · Accepted Answer · 2014-02-07 04:02:03Z

I got the answer

     public class BouncesAndBlocks
{
    public string status { get; set; }
    public string created { get; set; }
    public string email { get; set; }
    public string reason { get; set; }
}
     protected void btnBounces_Click(object sender, EventArgs e)
{
    string url = "https://api.sendgrid.com/api/bounces.get.json";
    string JS = GetResult(url);
    List<BouncesAndBlocks> res = (List<BouncesAndBlocks>)JsonConvert.DeserializeObject(JS, typeof(List<BouncesAndBlocks>));
    foreach (var item in res)
    {
        //Store in database
        lbl.Text = "Date:" + item.created.ToString() + "    Status:" + item.status.ToString() + "     Email:" + item.email.ToString() + "       Message:" + item.reason.ToString() + "";

    }
}

VLAZ · Accepted Answer · 2025-02-11 13:03:31Z

0

best way for problem is using

var  jtoken = JToken.Parse(string)

edited Feb 11 at 13:03

VLAZ

29.6k9 gold badges65 silver badges88 bronze badges

answered Feb 11 at 10:15

yaserjalilian

1752 silver badges2 bronze badges

Collectives™ on Stack Overflow

How can I parse a JSON string using ASP.NET?

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related