json to c# deserilization

Question

I want to convert this JSON return from php file into c#. But as a newbie don't know how, please help.

{"response": [
    {"user_id":"26","crtloc_lat":"47.678238","crtloc_lng":"-122.131416"},
    {"user_id":"27","crtloc_lat":"9.350192","crtloc_lng":"-95.391006"},
    {"user_id":"28","crtloc_lat":"47.678238","crtloc_lng":"-122.131416"}
]}

The above JSON is returned from my PHP file.

WebRequest request = WebRequest.Create("http://localhost/abh/returntest.php");
WebResponse response = await request.GetResponseAsync();
List<Response>  json ;
using (var stream = new StreamReader(response.GetResponseStream()))
{
    json = JsonConvert.DeserializeObject<List<Response>>(stream.ReadToEnd());
}
foreach (var item in json)
{
    Console.WriteLine("id={0},latitude={1},longitude={2}",item.user_id,item.crtloc_lat,item.crtloc_lng);
}

The Classes I am using are:

public class Response
{
    public string user_id { get; set; }
    public string crtloc_lat { get; set; }
    public string crtloc_lng { get; set; }
}

public class RootObject
{
    public List<Response> response { get; set; }
}

I am getting this error:

Cannot deserialize the current JSON object (e.g. {"name":"value"}) into type 'System.Collections.Generic.List`1[afterall.Response]' because the type requires a JSON array (e.g. [1,2,3]) to deserialize correctly.

If anyone want to check actual Php file is present at this link . [anybodyhere.net/returntest.php][http://anybodyhere.net/… — Waqas Kanju
– Waqas Kanju, Commented Oct 8, 2015 at 11:56

Dietz · Accepted Answer · 2015-10-08 17:54:43Z

3

The following line is wrong based on your sample JSON.

json = JsonConvert.DeserializeObject<List<Response>>(stream.ReadToEnd());

Try changing it to:

json = JsonConvert.DeserializeObject<RootObject>(stream.ReadToEnd());

Edit:

WebRequest request = WebRequest.Create("http://localhost/abh/returntest.php");
WebResponse response = await request.GetResponseAsync();
RootObject json;
using (var stream = new StreamReader(response.GetResponseStream()))
{
    json = JsonConvert.DeserializeObject<RootObject>(stream.ReadToEnd());
}
foreach (var item in json)
{
    Console.WriteLine("id={0},latitude={1},longitude={2}",item.user_id,item.crtloc_lat,item.crtloc_lng);
}

edited Oct 8, 2015 at 17:54

answered Oct 8, 2015 at 11:03

Dietz

5785 silver badges14 bronze badges

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

3 Comments

Uwe Hafner Over a year ago

@WaqasKanju: Dietz is correct. This fixes your problem. Tested with you code and gave in the string you posted.

Dietz Over a year ago

@WaqasKanju you have to change the declaration of the json variable aswell.

Waqas Kanju Over a year ago

Foreach will not work after this edit: You have to use this

Console.WriteLine(json.response[0].user_id); Console.WriteLine(json.response[1].user_id);  Console.WriteLine(json.response[2].user_id);

Mainak · Accepted Answer · 2015-10-08 11:08:46Z

0

rewrite the following line :

json = JsonConvert.DeserializeObject<List<Response>>(stream.ReadToEnd());

as

json = JsonConvert.DeserializeObject<Response>(stream.ReadToEnd());

answered Oct 8, 2015 at 11:08

Mainak

4683 gold badges10 silver badges33 bronze badges

1 Comment

Waqas Kanju Over a year ago

After changing that line: it shows this error, can not implicitly convert type RootObject to System.Collection.Generics.List

Uwe Hafner · Accepted Answer · 2015-10-08 12:38:05Z

From your testlink in the comment of your post. Your response is not:

{"response": [
    {"user_id":"26","crtloc_lat":"47.678238","crtloc_lng":"-122.131416"},
    {"user_id":"27","crtloc_lat":"9.350192","crtloc_lng":"-95.391006"},
    {"user_id":"28","crtloc_lat":"47.678238","crtloc_lng":"-122.131416"}
]}

as you post but rather:

connected{"response": [
         {"user_id":"26","crtloc_lat":"47.678238","crtloc_lng":"-122.131416"},
          {"user_id":"27","crtloc_lat":"9.350192","crtloc_lng":"-95.391006"},
          {"user_id":"28","crtloc_lat":"47.678238","crtloc_lng":"-122.131416"
          }]
    }

This is not corresponding to your sample code. Remove the

connected{ }

wrapping or return correct json for a connected object (whatever the connect is). If you remove the wrapping it should work as @Dietz posted.

Collectives™ on Stack Overflow

json to c# deserilization

3 Answers 3

3 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related