Search and Update Record in JSON file

Question

Hi,

I have the below json file. I wanted to know using C# how can I open the file, search for the FilePath that is equal to:

/Users/jassim/Projects/MauiPad/SampleText/2.txt

Then Update the LastModified to current date?

[  
   {  
      "Id":"a2622858-1ea8-47f1-bb0e-e34906233cd6",  
      "FileName":"1",  
      "FilePath":"/Users/jassim/Projects/MauiPad/SampleText/1.txt",  
      "LastModified":"2022-09-19 22:53:54"  
   }  
   {  
      "Id":"a2622858-1ea8-47f1-bb0e-e34906233cd6",  
      "FileName":"2",  
      "FilePath":"/Users/jassim/Projects/MauiPad/SampleText/2.txt",  
      "LastModified":"2022-09-19 22:53:54"  
   }  
   {  
      "Id":"a2622858-1ea8-47f1-bb0e-e34906233cd6",  
      "FileName":"3",  
      "FilePath":"/Users/jassim/Projects/MauiPad/SampleText/2.txt",  
      "LastModified":"2022-09-19 22:53:54"  
   }  
]  

Thanks,
Jassim

Answer 1

Please make an effort to write this code on your own first.

Read the file and deserialize the contents into a C# type.

How to serialize and deserialize (marshal and unmarshal) JSON in .NET
https://learn.microsoft.com/en-us/answers/questions/699941/read-and-process-json-file-with-c.html

Use LINQ to find the item with the file path you're looking for.

var item = items.FirstOrDefault(i => i.FilePath == "/Users/jassim/Projects/MauiPad/SampleText/2.txt");  

Make the update.

item.LastModified = DateTime.Now;  

Sterilize the items back into a file.