How do I parse this json-response?

Question

The response is structured like this, this is an extract, might be missing a curly brace:

{"2":{"date":1306411951,"price":4.8003,"low":"4.80000000","high":"4.80060000","nicedate":"15:12"},"6":{"date":1306418941,"price":4.654175,"low":"4.40000000","high":"4.80000000","nicedate":"17:02"}

And I get cast exceptions when parsing the response string even though all the datamembers in the object are strings.

I'm using System.Runtime.Serialization.Json to deserialize the objects.

Right now I'm doing it like this:

        Currency[] MapJSONToObjects(string jsonString)
    {
        using (var ms = new MemoryStream(Encoding.Unicode.GetBytes(jsonString)))
        {
            //Parse
            var ser = new DataContractJsonSerializer(typeof(Currency[]));
            Currency[] currencies = (Currency[])ser.ReadObject(ms);
            return currencies;
        }
    }

This is not valid JSON. There's at least a curly brace missing at the end. — Codo
– Codo, Commented Jun 2, 2011 at 12:26

Community · Accepted Answer · 2017-05-23 12:04:20Z

2

As mentioned already, you're missing a trailing } from the JSON. Assuming that what you receive is properly formatted and consistent JSON, then your Currency class should look something like this:

[DataContract]
public class Currency
{
    [DataMember(Name = "date")]
    public int Date { get; set; }
    [DataMember(Name = "price")]
    public double Price { get; set; }
    [DataMember(Name = "low")]
    public string Low { get; set; }
    [DataMember(Name = "high")]
    public string High { get; set; }
    [DataMember(Name = "nicedate")]
    public string NiceDate { get; set; }
}

Your deserialization code looks fine, though you could consider using JSON.NET if you're still having problems, as described here: Deserializing variable Type JSON array using DataContractJsonSerializer

edited May 23, 2017 at 12:04

CommunityBot

11 silver badge

answered Jun 2, 2011 at 12:41

Derek Lakin

16.3k38 silver badges51 bronze badges

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

3 Comments

Phil Over a year ago

The response is fine, I checked with a json-validator. My class looks exactly like your suggestion (no, really, exactly like that) but I think the problem lies in the index. It doesn't cast correctly since there's no property for the index and the index isn't named either. I don't know how to handle that specific scenario...

Phil Over a year ago

Checking JSON.NET now, seems sweet.

Phil Over a year ago

Although this didn't solve my problem, it is indeed the best way in most cases.

Collectives™ on Stack Overflow

How do I parse this json-response?

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related