Parsing a JSON dictionary that contains the same key with different casing

Question

I have a problem; I would to know if there is a method to parse json file without having a unique format. So it may have different attributes but all of them contain the attribute Status but it can be in double.

  {
  "requestid": "1111",
  "message": "db",
  "status": "OK",
  "data": [
    {
      "Status": "OK", // this one I would to test first to read the other attributes
      "fand": "",
      "nalDate": "",
      "price": 1230000,
      "status": 2
    }
  ]
}

I don't understand what you're asking... Maybe you could look at `JToken.Parse` (Newtonsoft Json library) and navigate the tree that way? — RQDQ, Oct 27 '17 at 13:56
Are you trying to ask whether you can parse a *dictionary* when it contains both `Status` and `status` keys? I'm not sure that's valid JSON to begin with — Panagiotis Kanavos, Oct 27 '17 at 13:58
@PanagiotisKanavos this Json is perfectly valid as the RFC 4627, RFC 7159 and ECMA-404 say's (you can validate it here https://jsonformatter.curiousconcept.com/) — fruggiero, Oct 27 '17 at 14:13
@fruggiero I checked the standard too. It says nothing about casing, except that *the implementations should agree* so anything goes. C# dictionaries are case-sensitive by default, property names as well, so this *should* deserialize without issue, at least for dictionaries. — Panagiotis Kanavos, Oct 27 '17 at 14:16
Just tried it now, Json.NET can deserialize directly to an object that has a `Status` and a `status` property. — Panagiotis Kanavos, Oct 27 '17 at 14:20
I have to notice that data may be an array of data and sometime not ! — Adouani Riadh, Oct 27 '17 at 14:29

score 1 · Answer 1 · answered Oct 27 '17 at 14:02

The defacto standard Json serializer for .NET is Newtonsoft.Json (How to install). You can parse the Json into an object graph and work on that in any order you like:

namespace ConsoleApp3
{
    using System;
    using Newtonsoft.Json.Linq;

    class Program
    {
        static void Main()
        {
            var text = @"{
                'requestid': '1111',
                'message': 'db',
                'status': 'OK',
                'data': [
                {
                    'Status': 'OK', // this one I would to test first to read the other attributes
                    'fand': '',
                    'nalDate': '',
                    'price': 1230000,
                    'status': 2
                }
                ]
            }";

            var json = JObject.Parse(text);

            Console.WriteLine(json.SelectToken("data[0].Status").Value<string>());
            Console.ReadLine();
        }
    }
}

score 1 · Accepted Answer · answered Oct 27 '17 at 14:03

1

With https://www.newtonsoft.com/json

Data data = JsonConvert.DeserializeObject<Data>(json);

And create the class Data with the interesting data inside the json

answered Oct 27 '17 at 14:03

Marco Salerno

5,131
2
12
32

The problem is data does not have a unique structure ! – Adouani Riadh Oct 27 '17 at 14:12
1

I understood it, that's why this library is great, it doesn't care at all ^^ – Marco Salerno Oct 27 '17 at 14:13
No, I tested before it does not work if the value of json data does not match with structure of the class, the deserialisation will be fail. – Adouani Riadh Oct 27 '17 at 14:21
I'm sure that you are wrong i use it for the same purpose, if it doesn't find anything it just doesn't populate the property – Marco Salerno Oct 27 '17 at 14:22
because it may be an array of object and it can be not ! – Adouani Riadh Oct 27 '17 at 14:28
So use a list ^^ – Marco Salerno Oct 27 '17 at 14:30
and it can be fall in the second Status rather than the first one – Adouani Riadh Oct 27 '17 at 14:31
What does it mean? – Marco Salerno Oct 27 '17 at 14:31
It may have a 2 status in the data entry and it get the last one not the first one, I tested right now – Adouani Riadh Oct 27 '17 at 14:32
I don't think so – Marco Salerno Oct 27 '17 at 14:32
string Status { get; set; } string status { get; set; } – Marco Salerno Oct 27 '17 at 14:37
i don't have any problem, just tested ^^ – Marco Salerno Oct 27 '17 at 14:37
Looking at your pic i can't see a problem, it's getting the status – Marco Salerno Oct 27 '17 at 14:38
Ah u put twice status then it may have a 3 status and it will get the last two element – Adouani Riadh Oct 27 '17 at 14:38
I suppose you don't understand, i give up :\ – Marco Salerno Oct 27 '17 at 14:39
maybe I don't see it clearyl right now Thanks anyway :) – Adouani Riadh Oct 27 '17 at 14:43
Anyway this is the solution to your problem focus on it, good luck ^^ – Marco Salerno Oct 27 '17 at 14:43

Parsing a JSON dictionary that contains the same key with different casing

2 Answers2