Parse json request in Xamarin.Android

Question

I´ve searched for a long time but without success...

I want to parse a json response from an API in Xamarin.Android.

My json responsee is like this:

[
  {
    "id": "21",
    "date": "2018-01-01",
    "name": "Name1"
  },
  {
    "id": "22",
    "date": "2018-01-02",
    "name": "Name2",
  }
]

As you see, it contains 2 rows. The numer of rows can change. Sometimes the there are 6 rows but sometimes only 2...

So i want to get the value of each id, date and name tag, for each row. I tryed with an for each loop but don't succeed...

Could someone help me with DataSet and DataTable?

I saw this code but get an error with DataSet and DataTable:

string json = @"{
  'Table1': [
    {
      'id': 0,
      'item': 'item 0'
    },
    {
      'id': 1,
      'item': 'item 1'
    }
  ]
}";

DataSet dataSet = JsonConvert.DeserializeObject<DataSet>(json);

DataTable dataTable = dataSet.Tables["Table1"];

Console.WriteLine(dataTable.Rows.Count);
// 2

foreach (DataRow row in dataTable.Rows)
{
    Console.WriteLine(row["id"] + " - " + row["item"]);
}
// 0 - item 0
// 1 - item 1

Thank you in advance!

Yes i tryed, but didn´t undesrstand... Could you help me with DataSet and DataTable ? This is, what i dont understand. — JonasPTFL
– JonasPTFL, Commented Jul 9, 2018 at 15:47

Brandon Minnick · Accepted Answer · 2018-07-09 16:30:04Z

5

You can use Json.net JsonConvert.DeserializeObject function

Make a ObjModel class to carry your json data.

public class ObjModel
{
    [JsonProperty("id")]
    public string Id { get; set; }

    [JsonProperty("date")]
    public string Date { get; set; }

    [JsonProperty("name")]
    public string Name { get; set; }
}

ObjModel[] datas = JsonConvert.DeserializeObject<ObjModel[]>(jsonData);

c# online:https://dotnetfiddle.net/UybCQ1

if you want to DeserializeObject to DataTable it can work too.

DataTable  dt = JsonConvert.DeserializeObject<DataTable>(jsonString2);

foreach(DataRow row in dt.Rows){
  Console.WriteLine(row["id"]);
}

edited Jul 9, 2018 at 16:30

Brandon Minnick

15.8k16 gold badges84 silver badges147 bronze badges

answered Jul 9, 2018 at 15:47

D-Shih

46.5k6 gold badges37 silver badges56 bronze badges

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

5 Comments

JonasPTFL Over a year ago

It works! Is there any way to get the number of rows?

D-Shih Over a year ago

simple way you can use for loop to count array then the index be your number.dotnetfiddle.net/UybCQ1 you can add the number in to your model

D-Shih Over a year ago

look like this.

string jsonString2 = "[{\"id\": \"21\",\"date\": \"2018-01-01\",\"name\": \"Name1\"},{\"id\": \"22\",\"date\": \"2018-01-02\", \"name\": \"Name2\"}]";

D-Shih Over a year ago

If your string want to contain " double quotes another way you need to add \ before double quotes

JonasPTFL Over a year ago

Could you cancle your code on dotnetfiddle.net, so that i can take a look at the for loop again?

Collectives™ on Stack Overflow

Parse json request in Xamarin.Android

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related