How to Read Json File Data in Asp.Net Core of Specific Json

Adhikar Patil

Hello,

I want to read json file data with specific json object array one by one using Foreach loop in Asp.net Core.

I Have MasterData.json file

So, Now i want to read one by one and insert into database. Below is my code

[HttpPut("copyMasterData/{id}")]
public async Task CopyMasterData(int id, bool isCopiedData)
{
try
{
var folderDetails = Path.Combine(Directory.GetCurrentDirectory(), $"wwwroot\\{"MasterData\\masterdata.json"}");
var JSON = System.IO.File.ReadAllText(folderDetails);
dynamic jsonObj = Newtonsoft.Json.JsonConvert.DeserializeObject(JSON);
var response = 0;
foreach (var item in jsonObj["M203structureKind"])
{
var m203StructureKind = new M203structureKind
{
Code = item ["Code"].ToString(),
Description = item ["Description"].ToString(),
AgencyId = id,
IsActive = true,
IsDeleted = false,
AddedBy = User.GetUserId(),
ModifiedBy = User.GetUserId()
AddedOn = DateTime.Now,
ModifiedOn = DateTime.Now
};
response = await _m203structkindService.AddAsync(m203StructureKind);
}
n response > 0 ? Ok(new { message = "Agency details added successfully." }) : StatusCode(500, "An error occured while adding agency details. Please try again...");
}
catch (Exception ex)
{
return StatusCode(500, ResponseMessages.GetErrorMessage(ResponseMessages.MessageType.Add, ex.Message));
}
}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

I would recommend you to create a strongly-typed class for your JSON object like this:

Then you should be able to deserialized it like in the following:

var jsonStirng = "{ \"M203StructureKind\":[ { \"Code\":\"1\", \"Description\":\"BRIDGE\" }, { \"Code\":\"2\", \"Description\":\"CULVERT\" }, { \"Code\":\"3\", \"Description\":\"TUNNEL\" }, { \"Code\":\"4\", \"Description\":\"TRAIL BRIDGE\" }, { \"Code\":\"5\", \"Description\":\"OTHER\" } ]}";
var root = Newtonsoft.Json.JsonConvert.DeserializeObject(jsonStirng);
foreach(var item in root.M203StructureKind)
{
var code = item.Code;
var desc = item.Description;
//Your DB INSERT logic here
}

asas