Breaking News: Grepper is joining You.com. Read the official announcement!

How to change a key value pair within a nested json structure C#

SAMER SAEID answered on May 14, 2022 Popularity 1/10 Helpfulness 1/10

answer How to change a key value pair within a nested json structure C#

How to change a key value pair within a nested json structure C#

Comment

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

// Read the JSON file. 
var json = JObject.Parse(File.ReadAllText("input.json"));

// Extract label by GUID. Note that GUID case is inconsistent within the file, so we force upper case.
var labelByGuid = json.SelectTokens("cases.procedure.version.forms[*].sections[*].rows[*].fields[?(@.guid && @.label)]")
                      .ToDictionary(t => t["guid"]!.ToString().ToUpperInvariant(),
                                    t => t["label"]!.ToString());

// Update entries.
foreach (var entry in json.SelectTokens("cases.content[?(@.field)]"))
{
    var field = entry["field"]!.ToString().ToUpperInvariant();
    if (!labelByGuid.TryGetValue(field, out var label))
        continue;
    
    entry["field"] = label;
}

// Write back the JSON object.
var settings = new JsonSerializerSettings { Formatting = Formatting.Indented };
var serializer = JsonSerializer.Create(settings);
await using var outputStream = File.CreateText(@"output.json");
serializer.Serialize(outputStream, json);

Popularity 1/10 Helpfulness 1/10 Language javascript

Source: Grepper

Tags: c# javascript key-value nested-json structure

Link to this answer
Share Copy Link

Contributed on May 14 2022

SAMER SAEID

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

How to change a key value pair within a nested json structure C#

Contents

More Related Answers

How to change a key value pair within a nested json structure C#

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.