current community

your communities

more stack exchange communities

Stack Exchange
tour help
stack overflow careers
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 0 down vote favorite

I've got JSON data that looks like this...

{
     "generated" : "Sat, 20 Dec 3049 12:30:01",
     "1" : { ... },
     "2" : { ... },
     ...
     "2400" : { ... },
}

Personally, I would've expected an array of objects to be outputted using the JSON array syntax (this is my first foray into JSON). I'm using Json.Net to try parse this mess into an object model for querying purposes and eventually display.

I was going to use the JsonSerializationAttribute method of transforming the JSON into an object model. I've already tried going straight to XML instead but apparently this particular JSON file is not XML compatible ("1" is an invalid XML element name).

My initial object model class representing the high level snippet of JSON above is as follows:

public class MwoMapData
{
    [JsonProperty(PropertyName = "generated")]
    public DateTime Generated { get; set; }
    [JsonArray]
    public List<Planet> Planets { get; set; }
}

The resources I've read basically say that an array is not represented the way this has been and I'm totally stumped on how to parse this with Json.Net into my object model.

My question is: How do I translate the object properties into an array using Json.Net and JsonSerializationAttributes?

share|improve this question
    
Where is an array? There is JSON object with fields, but no arrays –  Sergey Berezovskiy Dec 20 '14 at 12:55
    
In Java I have worked with Jackson (mkyong.com/java/how-to-convert-java-object-to-from-json-jackson) in order to pass a JSON into an object. It allows you to get the JSON as you want (e.g., as a Map). –  Marc Manzano Dec 20 '14 at 12:56
    
@Sergey: The "fields" are a dynamic list of items which are clearly IDs for the objects referenced. Why would someone serialise a property with the name "1", for example, especially when the array syntax exists? This is clearly a large dataset rather than an actual object with properties. –  toadflakz Dec 20 '14 at 13:07
    
@Marc: Irrelevant and I'm using C# and the question is about how to deserialize those properties as an array. –  toadflakz Dec 20 '14 at 13:11
    
@toadflakz Why would someone serialise a property with the name "1", for example, especially when the array syntax exists? JSON has an array syntax, and your JSON is not using it. It would be rather presumptuous of your deserializer to assume it was an array just because it had numeric property names (especially when it has a non-numeric property name). –  JLRishe Dec 20 '14 at 14:28

2 Answers 2

up vote 1 down vote accepted

If you are using Json.NET you can implement custom Deserialzer by creating a class that inherits from abstract class JsonConverter. You can then override method called ReadJson:

class CustomJson : JsonConverter
    {
        public override void WriteJson(JsonWriter writer, object value, JsonSerializer serializer)
        {
            //if you only deserialize, you will probably not need this
        }

        public override object ReadJson(JsonReader reader, Type objectType, object existingValue, JsonSerializer serializer)
        {
            var output = new object(); //instance of your class
            do
            {
                if (reader.TokenType == JsonToken.PropertyName)
                {
                    int number;
                    if (int.TryParse(reader.Value.ToString(), out number))
                    {
                        //detecting the number
                    }
                    else
                    {
                        //not a number
                    }
                }
                else
                {
                    //read other stuff
                }    
            } while (reader.Read());

            return output;
        }

        public override bool CanConvert(Type objectType)
        {
            //detect your type
        }
    }

And then use it:

var deserialized = JsonConvert.DeserializeObject<YourClass>(json, new CustomJson());

For other hints how to implement JsonConverter class see this posts:

share|improve this answer
    
Thanks - I was hoping it was default functionality, but oh well! –  toadflakz Dec 20 '14 at 13:27
1  
Json.NET deserializes objects as they are represented in JSON string. Only if input JSON have different syntax (like in your example) and you want to parse properties in a different way - then you implement JsonConverter class. –  Marcin Zablocki Dec 20 '14 at 13:30
up vote 0 down vote

You deserialise it using this code

Dictionary<string,Yourclass> data = JsonConvert.DeserializeObject<Dictionary<string,Yourclass>>(jsonString);

You can then iterate through your dictionary

share|improve this answer
    
Even tho' it has that "generated" property in the JSON? –  toadflakz Dec 20 '14 at 14:24

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.