Parse JSON array with Json.net

Question

how can I read the JSON from this site (http://www.pegelonline.wsv.de/webservices/rest-api/v2/stations.json?includeTimeseries=true&includeCurrentMeasurement=true) in C# with the Json.net library? In this JSon there is only a array. I tested it with this code, but it doesn't work.

using (Stream stream = response.GetResponseStream())
{
  JsonReader reader = new JsonTextReader(new StreamReader(stream));
  dynamic info = JObject.Load(reader);
}

If i debug this, then VS says that the item is not an object. I try it with JArray.Load(reader); but then I don't know how to access the items.

Do you want to use only Json.net library or some other library solution are acceptable — Deepak Bhatia
– Deepak Bhatia, Commented Sep 21, 2013 at 15:13

meilke · Accepted Answer · 2013-09-21 16:21:29Z

1

You are right, JArray.Load is working correctly. The JArray then has a simple indexer to get to the individual items:

using (Stream stream = response.GetResponseStream())
{
  var reader = new JsonTextReader(new StreamReader(stream));
  var jsonArray = JArray.Load(reader);
  var item20 = jsonArray[19];
  var item20ShortName = (string)item20["shortname"];
}

edited Sep 21, 2013 at 16:21

answered Sep 21, 2013 at 15:09

meilke

3,2801 gold badge17 silver badges31 bronze badges

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

1 Comment

meilke Over a year ago

@user2025830 Adjusted the answer.

Collectives™ on Stack Overflow

Parse JSON array with Json.net

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related