Deserializing JSON with numbers as field using JsonSerializer

Question

I need to deserialize this weird JSON (image below). I've seen some deserialization hints using Dictionary<>, etc. but the problem is that "parameters" contains different data, then previous keys.

Can I somehow get it to work using JsonSerializer deserializator without doing foreach loops and other suspicious implementations? I do need data from "data" in my application.

Here's some of my code:

using var client = new WebClient();
var json = client.DownloadString(GetJsonString());
var invoicesData = JsonSerializer.Deserialize<JsonMyData>(json, options);

If using Newtonsoft is necessary I might start using it.

Text

Does this answer your question? Deserialize JSON to anonymous object — Jawad
– Jawad, Commented Jan 4, 2020 at 20:42
Just to confirm, you're using system.text.json not json.net, correct? Also, can you please edit your question to include your JSON as text rather than as a bitmap? It's policy here not to to use images for textual data, see Discourage screenshots of code and/or errors and Why not upload images of code on SO when asking a question for why. A minimal reproducible example showing the code that does not work would increase your chances of getting an answer, for why see How to Ask. — dbc
– dbc, Commented Jan 4, 2020 at 22:22
Does the value of "parameters" have a different schema than the value for the indexed values "0", "1" etc etc? Do the indexed values have a shared, fixed schema, or is everything free-form? — dbc
– dbc, Commented Jan 4, 2020 at 22:26
Does this correspond to the situation described in How to deserialize a child object with dynamic (numeric) key names?? — dbc
– dbc, Commented Jan 4, 2020 at 22:35

David Browne - Microsoft · Accepted Answer · 2020-01-04 21:57:26Z

2

With Newtonsoft you can parse and access arbitrary JSON documents, even ones that can't reasonably be deserialized into a .NET object. So something like:

using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
using System;

namespace ConsoleApp35
{
    class Program
    {
        static void Main(string[] args)
        {
            var json = @"
{
                ""myData"" : 
    {
      ""0"" : { ""data"": { ""A"":1,""B"":2} },
      ""1"" : { ""data"": { ""A"":1,""B"":2} },
      ""2"" : { ""data"": { ""A"":1,""B"":2} },
      ""3"" : { ""data"": { ""A"":1,""B"":2} },
      ""parameters"" : { ""p"":""a""}
    },
 ""status"":{ }
}";

            var foo = JObject.Parse(json);
            var a = foo["myData"]["1"]["data"];
            Console.WriteLine(a);

            Console.WriteLine("Hit any key to continue");
            Console.ReadKey();
        }
    }
}

edited Jan 4, 2020 at 21:57

answered Jan 4, 2020 at 21:19

David Browne - Microsoft

90.7k7 gold badges52 silver badges87 bronze badges

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

3 Comments

Michał Droździk Over a year ago

I'll try it later and see what I've ended up with, thanks EDIT: I meant I need a collection of all "data" entries. So basically I have to foreach with everything? Full json is like +1000 entries of data

David Browne - Microsoft Over a year ago

Since you're transforming a JSON object into a collection, yes, you'll have to iterate them and add them to a collection.

Michał Droździk Over a year ago

Thanks a lot, at the end I figured out I could just remove "parameters" via JToken.Last.Remove() and then deserialized everything in foreach loop. Your reply was very helpful :)

Fedir Katushonok · Accepted Answer · 2020-01-04 21:07:14Z

1

I think you should really consider using Newtonsoft.Json instead of default JsonDeserializer, it is much easier to use in such situations.

answered Jan 4, 2020 at 21:07

Fedir Katushonok

4706 silver badges15 bronze badges

Comments

Jawad · Accepted Answer · 2020-01-05 03:18:21Z

If you are interested in processing this without foreach loops and wanting to access the data in a list format, I would suggest using Dictionary for this. When you use dictionary, you can use Objects as values that would compensate for differences in numbers (0, 1, 2, ..) and words (parameters).

    // Classes to Deserialize data we need.
    public class MyObject
    {
        [JsonProperty("data")]
        public Data Data { get; set; }
    }

    public class Data
    {
        public int A { get; set; }
        public int B { get; set; }
    }

Usage in Main

    // Read in the JSON
    var myData = JsonConvert.DeserializeObject<dynamic>(jsonString)["myData"];

    // Convert To Dictionary
    Dictionary<string, dynamic> dataAsObjects = myData.ToObject<Dictionary<string, dynamic>>();

    string searchFor = "3";
    dataAsObjects.TryGetValue(searchFor, out dynamic obj);
    if (obj != null)
    {
        // Conversion to int and matching against searchFor is to ensure its a number.
        int.TryParse(searchFor, out int result);
        if (result == 0 && result.ToString().Equals(searchFor))
        {
            MyObject myObject = obj.ToObject<MyObject>();
            Console.WriteLine($"A:{myObject.Data.A} - B:{myObject.Data.B}");
        }
        else if (result == 8 && result.ToString().Equals(searchFor))
        {
            // I am not clear on whats your parameters class look like.
            MyParameters myParams = obj.ToObject<MyParameters>();
        }
    }

Output

A:1 - B:2

With this method you can either access the numbers or the parameters element.

Collectives™ on Stack Overflow

Deserializing JSON with numbers as field using JsonSerializer

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related