Update property in json file with C#

Question

I'm looking to change a specific property for each json record in my json file. I'd like to change the "Completed" property to "true" when a method finishes executing.

My json file looks like:

{
  "LoanRecords": [
    {
      "LoanGUID": "{70dbec7e-5e94-460d-831c-0a5dc2d085e2}",
      "RecordDT": "2020-11-10T14:44:34.378Z",
      "Completed": "false",
      "Environment": "TEBE",
      "ProcessType": "RateLock"
    },
    {
      "LoanGUID": "{70dbec7e-5e94-460d-831c-0a5dc2d085e2}",
      "RecordDT": "2020-11-10T14:53:12.187Z",
      "Completed": "false",
      "Environment": "TEBE",
      "ProcessType": "RateLock"
    }
    ]
}

My C# code is the following:

    private void ExecuteEvent(object sender, ElapsedEventArgs e)
    {
            string fileRecord = File.ReadAllText(jsonfile);
            LoanRecordRoot LoanRecord = JsonConvert.DeserializeObject<LoanRecordRoot>(fileRecord);
            foreach (var rec in LoanRecord.LoanRecords)
            {
                if (rec.Completed == "false")
                {
                    bool recordModified = ManipulateEncompass(rec.LoanGUID, rec.ProcessType);
                    if (recordModified)
                    {
                        // What should I do here to update "rec.Completed" to "true"
                        // for this particular record and write it back to the json file
                        // for that specific entry?
                    }
                }
            }
            Console.WriteLine("Successfully manipulated records!");
        }

Is there a way to flip the "Completed" property to "true" for the specific record in my "foreach" iteration, and update the json file accordingly for that specific record? I am hoping to avoid reading the entire file, deserializing, changing the property then writing the entire content back to the json file, I'm looking to just flip that specific property for each record in my "foreach" loop. -- I hope that makes sense.

I've looked at similar questions, which seem close to what I'm looking for, but the examples I've seen don't reflect writing back to the json file specifically without overwriting the file contents -- unless this specific action isn't possible, or I'm failing to understand the entire process (highly possible.)

Ex of a solution that's close to what I'm looking for: How to update a property of a JSON object using NewtonSoft -- but doesn't seem to quite fit the bill for what I'm wanting to do.

Thank you in advance for any helpful leads!

score 2 · Accepted Answer · edited Nov 10 '20 at 20:43

you need to save the complete JSON when you update a property of an element of the array

    static void Main(string[] args)
    {
        const string jsonPath = @"C:\Logs\recordRoot.json";
        var loanRecordRoot = JsonConvert.DeserializeObject<LoanRecordRoot>(File.ReadAllText(jsonPath));
        foreach (var record in loanRecordRoot.LoanRecords)
        {

            if (record.Completed == "false")
            {
                if (ManipulateEncompass(rec.LoanGUID, rec.ProcessType))
                {
                    record.Completed = "true";
                }
            }
        }

       //Save Json
       var json = JsonConvert.SerializeObject(loanRecordRoot, Formatting.Indented);
       File.WriteAllText(jsonPath, json);
    }

Thank you Mario for your example, works like a charm! – Michael Tucker Nov 10 '20 at 18:36 — Michael Tucker, Nov 10 '20 at 18:36

score 1 · Answer 2 · edited Nov 10 '20 at 18:03

1

Looking at your JSON, it appears the "Completed" property is being serialized as of type string

Therefore, all you need to do is set it to "Completed": "true" within your condition in your snippet.

 if (recordModified)
 {
     rec.Completed = "true";
 }

At the end of your processing, simply serialize your LoanRecord object and write it back to your file.

edited Nov 10 '20 at 18:03

Dharman

30,962
25
85
135

answered Nov 10 '20 at 17:57

Julius A

38,062
26
74
96

I see, so I was semi close, that does work, thanks Julius! I was thinking it was more complicated than that >.> – Michael Tucker Nov 10 '20 at 18:36

score 0 · Answer 3 · answered Jan 09 '22 at 08:54

using Kitchen_Mini_Project.Constants;
using Kitchen_Mini_Project.Moduls;
using Newtonsoft.Json;
using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Kitchen_Mini_Project.Services
{
    public class Update
    {
        public static void UpdateAnyProduct()
        {
            string readdedFile = File.ReadAllText(PathConst.ProductDBPath);

            IList<Restaurant> products = JsonConvert.DeserializeObject<IList<Restaurant>>(readdedFile);

            foreach (var product in products[0].FoodItems)
            {
                if (product.foodName == "Chicken Burrito")
                {
                    product.foodName = "Chicken Burrito is Update ha ha";
                }
            }

            var json = JsonConvert.SerializeObject(products, Formatting.Indented);
            File.WriteAllText(PathConst.ProductDBPath, json);
        }
    }
}

score -2 · Answer 4 · answered Dec 04 '21 at 06:32

1-install package Newtonsoft.Json https://learn.microsoft.com/en-us/nuget/consume-packages/install-use-packages-visual-studio

2-use

string json = File.ReadAllText("server_client _input.json");
        dynamic jsonObj = Newtonsoft.Json.JsonConvert.DeserializeObject(json);
        jsonObj["Bots"][0]["Password"] = "new password";
        string output = Newtonsoft.Json.JsonConvert.SerializeObject(jsonObj, Newtonsoft.Json.Formatting.Indented);
        File.WriteAllText("settings.json", output);

(For Install package use of this page :https://www.newtonsoft.com/json)

Update property in json file with C#

4 Answers4

Linked