Bind json file data into list

Question

0.00/5 (No votes)

See more:

i have a json file and json data is something like that:-

{
      "Partdetails ": [
				{
					"key": "pincode",
					"value": "34598702"
				},
				{
					"key": "deliveryStatus",
					"value": "OptedOut"
				},
				{
					"key": "deliveryDate",
					"value": "2022-09-02T00:00:00"
				},
				{
					"key": "Status",
					"value": "successfully dispatch"
				}
			]
}

i have a modal class :

public class Partdetail
 {
     public string key { get; set; }
     public object value { get; set; }
 }

i want to access this json data from json file and bind into a List<partdetail> or in a dictionary whatever suitable for such kind of data.

can any one suggest me the solution

What I have tried:

public static class JsonFileReader
{
    public static T Read<T>(string filePath)
    {
        string text = File.ReadAllText(filePath);
        var json= JsonSerializer.Deserialize<T>(text);
        return json;

    }
}

Partdetails item = JsonFileReader.Read<Partdetails >(@"C:\filepath\data.json");

this code successfully fatch the data from my file but not Deserialize into json.

Posted 16-Sep-22 2:10am

TCS54321

Updated 16-Sep-22 14:57pm

v3

Add a Solution

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard MacCutchan · Answer 1 · 2022-09-16T02:27:00

Solution 1

You need to use the proper context for deserialization: https://docs.microsoft.com/en-us/dotnet/api/system.text.json.jsonserializer?view=net-6.0[^].

Posted 16-Sep-22 2:27am

Richard MacCutchan

Comments

Graeme_Grant 16-Sep-22 20:47pm

Not that simple

Richard MacCutchan 17-Sep-22 4:00am

I have a sample that pretty much is.

Graeme_Grant 17-Sep-22 7:44am

I can see that you posted it...

Graeme_Grant · Answer 2 · 2022-09-16T14:57:00

You need to write a custom converter to handle this: How to write custom converters for JSON serialization - .NET | Microsoft Learn[^]. I have also written an article on writing custom converters: Working with System.Text.Json in C#[^]

Here is the converter:

C#

public class DictionaryConverter : JsonConverter<PartDetails>
{
	public override PartDetails? Read(ref Utf8JsonReader reader,
                                      Type typeToConvert, JsonSerializerOptions options)
	{
        if (reader.TokenType != JsonTokenType.StartObject)
            return default;
		
		PartDetails? result = new();

		while (reader.TokenType != JsonTokenType.EndArray)
		{
			reader.Read();

			if (reader.TokenType == JsonTokenType.StartObject)
			{
				string key = string.Empty, value = string.Empty;
				foreach (KeyValuePair<string, JsonNode?> item in
                         JsonSerializer.Deserialize<JsonObject>(ref reader,
                                                                options)!)
				{
					if (item.Key == "key") key = item.Value!.ToString();
					if (item.Key == "value") value = item.Value!.ToString();
				}

				result.Items.Add(key, value);
			}
		}

		reader.Read(); // move to the end of the object

		return result;
	}

	public override void Write(Utf8JsonWriter writer, PartDetails value,
                               JsonSerializerOptions options)
	{
		throw new NotImplementedException();
	}
}

The class used with the converter attached:

C#

[JsonConverter(typeof(DictionaryConverter))]
public class PartDetails
{
	public Dictionary<string, string> Items { get; set; } = new();
}

NOTE: We can't use the attribute JsonPropertyName on the class, so we need to tell the serializer to ignore case:

C#

JsonSerializerOptions options = new()
{
	PropertyNameCaseInsensitive = true,
};

Now we can deserialize the Json data...

C#

PartDetails? list =
    JsonSerializer.Deserialize<PartDetails>(rawJson, options);

foreach (KeyValuePair<string, string> item in list!.Items!)
	Console.WriteLine($"{item.Key}, {item.Value}");

Bind json file data into list

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Bind json file data into list

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us