How can get data from Json array in c#?

Question

I want to get data from this JSON array. I use some keywords but I get the error every time, How can I get the data?

JArray test1 = JArray.Parse(jsondata);
string ids = test1["id"];

if i write "id" so i'm not get ans 11

{[
  {
    "id": 11,
    "userName": null,
    "passWord": null,
    "email": "someone@gmail.com",
    "mobile": "9898989898",
    "fullName": "Ramesh Sharma",
    "location": "Rajkot",
    "city_id": 1
  }
]}

That's not valid JSON. Are you sure that's your JSON, without a property? — ProgrammingLlama, Jun 10 '18 at 15:35
_"I get the error every time"_ What is the exact error message? — CodeNotFound, Jun 10 '18 at 15:37
I am getting this type of json data, "[{\"id\":11,\"userName\":null,\"passWord\":null,\"email\":\"someone@gmail.com\",\"mobile\":\"9423422882\",\"fullName\":\"Ramesh Sharma\",\"location\":\"Rajkot\",\"city_id\":1}]" but for removing '\' i used `var results = JsonConvert.DeserializeObject(responseString);` this code then i get that type of array — kiran girase, Jun 10 '18 at 15:39
@kiran you can use the validator [here](https://jsonformatter.curiousconcept.com/) to see that your JSON is invalid. You ought to work on fixing that first. — ProgrammingLlama, Jun 10 '18 at 15:41
my proper data is this `"[{\"id\":11,\"userName\":null,\"passWord\":null,\"email\":\"someone@gmail.com\",\"mobile\":\"9423422882\",\"fullName\":\"Ramesh Sharma\",\"location\":\"Rajkot\",\"city_id\":1}]"` — kiran girase, Jun 10 '18 at 15:47

score 1 · Answer 1 · answered Jun 10 '18 at 16:10

In a comment to your question you said your JSON is:

[
  {
    "id": 11,
    "userName": null,
    "passWord": null,
    "email": "someone@gmail.com",
    "mobile": "9898989898",
    "fullName": "Ramesh Sharma",
    "location": "Rajkot",
    "city_id": 1
  }
]

Create C# classes for your JSON as shown here and you will get these classes:

public class Rootobject
{
    public Class1[] Property1 { get; set; }
}

public class Class1
{
    public int id { get; set; }
    public object userName { get; set; }
    public object passWord { get; set; }
    public string email { get; set; }
    public string mobile { get; set; }
    public string fullName { get; set; }
    public string location { get; set; }
    public int city_id { get; set; }
}

Then deserialize it like this:

var results = JsonConvert.DeserializeObject<RootObject>(yourJSON);

I understand it is a tool, but oh my those names suck big time — Camilo Terevinto, Jun 10 '18 at 16:30
@camiloterevinto Agree. Thats why it should be changed so it makes sense in your domain. — CodingYoshi, Jun 10 '18 at 16:35
@kirangirase What do you mean *model* class? I dont understand what you are saying. Sorry. — CodingYoshi, Jun 10 '18 at 18:00

Prany · Accepted Answer · 2018-06-10T19:24:02.570

1

You can get each value like this, then it is upto you which value you need to choose.

    foreach (JObject content in test1.Children<JObject>())
    {
          string Id = content["id"].ToString();
          string email = content["email"].ToString();
    }

By the way below is your correct formatted Json.

[{"id":11,"userName":null,"passWord":null,"email":"someone@gmail.com","mobile":"9423422882","fullName":"Ramesh Sharma","location":"Rajkot","city_id":1}]

edited Jun 10 '18 at 19:24

answered Jun 10 '18 at 16:59

Prany

2,078
2
13
31

Thanks Prany, I get answer from foreach loop but it will iterate everytime and and I will get value but I want specific values e.g fullName,id,cityid . can you please help me how i get this – kiran girase Jun 10 '18 at 17:45
@kirangirase Cheers Mate – Prany Jun 10 '18 at 18:11

How can get data from Json array in c#?

2 Answers2