Question 109348 in Json Question posted in
Our archive of expertly curated questions and answers provides insights and solutions to common problems related to this popular data interchange format. From parsing and manipulating JSON data to integrating it with various programming languages and web services, our archive has got you covered. Start exploring today and take your JSON skills to the next level

Json – Why does GetSection("test").GetChildren() returns sorted list of descendent sub-sections?

We are using these subsections to generate excel, and we want the list of sub-sections as it is stored in json file but GetSection("XPaths").GetChildren() is always returning sorted list of sub sections.

I am not able to understand why?
Here I want these Xpaths as it is stored in json file but I am always getting sorted data.

JSON: Here I shared only 4 values of XPath, in real it has more than 1000.

{
  "XPaths": {
    "CITY": "USER/@CITY",
    "STATE": "USER/@STATE",
    "COUNTRY": "USER/@COUNTRY",
    "GENDER": "USER/@GENDER"
            }
}

Code:

 public static Dictionary<string, string?> GetXpaths(string form)
        {
            var xPaths = new Dictionary<string, string?>();
            try
            {
                form = !File.Exists($"{form}.json") ? ($"{(int)FormToGetXpaths.Default}") : form;
               
                var xPathbuilder = new ConfigurationBuilder()
                        .SetBasePath(Directory.GetCurrentDirectory())
                        .AddJsonFile($"{form}.json", optional: true, reloadOnChange: true);

                var _xpathconfiguration = xPathbuilder.Build();

                 xPaths = _xpathconfiguration.GetSection("XPaths")
                    .GetChildren()
                    .ToList()
                    .ToDictionary(x => x.Key, x => x.Value);
            }
            catch (Exception ex)
            {
               Console.WriteLine($"Failed to get XPaths for {form}n{ex.Message}");
            }
            return xPaths;
        }
Tags:

2

Answers


  1. 0

    RFC7159 explicitly states that

    An object is an unordered collection of zero or more name/value
    pairs, where a name is a string and a value is a string, number,
    boolean, null, object, or array.

    So you can’t rely on the order being preserved. Some JSON serialization libraries might preserve it, some not, some others might have settings to control the sorting behavior, but in general, if you want your sections ordered in a specific way, you’ll have to add a sequence variable to each of them and then order them by that variable.

    Alternatively, you may consider turning your object with keys into an array of objects – the order in arrays is preserved according to the standard.

    Login or Signup to reply.
  2. 0

    Why you don’t try this instead of building config

    public static Dictionary<string, string?> GetXpaths(string form)
{
    try
    {
        form = !File.Exists($"{form}.json") ? ($"{(int)FormToGetXpaths.Default}") : form;
    
        var basePath = Directory.GetCurrentDirectory();
        var json = File.ReadAllText(Path.Combine(basePath, $"{form}.json"));

        return JObject.Parse(json)["XPaths"].ToObject<Dictionary<string, string>>();
    }
    catch (Exception ex)
    {
        Console.WriteLine($"Failed to get XPaths for {form}n{ex.Message}");
        return null;
    }
}
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search