JSON parsing in C#

Question

JSON parsing in C#

I'm struggling to parse JSON in c# that is structured like the example below. The code snippet I have been using is somewhat functional, but it lacks stability.

(I'm also looking for guidance on how to parse JSON in Javascript, which is another task on my plate.)

Take a look at the JSON format I am working with:

{"72": { "Rejected": true }, "271": { "PreApproved": true}}

Here's a snippet of the code I've been working with:

List<SSKChanges> lstSSK = new List<SSKChanges>();
string sskSource = "";
string sskStatus = "";
bool sskStatusBool = false;
int i = 0;
int iList = 0;
JsonTextReader reader = new JsonTextReader(new StringReader(jsonExample));
while (reader.Read())
{
    if (reader.Value != null)
    {
        if (i == 0)
        {
            int n;
            bool isNumeric = int.TryParse(reader.Value.ToString(), out n);
            if (isNumeric)
            {
                sskSource = reader.Value.ToString();
                i = 1;
            }
            else
            {
                sskStatus = reader.Value.ToString();
                i = 2;
            }
        }
        else if (i == 1)
        {
            sskStatus = reader.Value.ToString();
            i = 2;
        }
        else
        {
            sskStatusBool = (bool)reader.Value;
            i = 0;
            sskSource = "";
            sskStatus = "";
            sskStatusBool = false;
        }
    }
}

javascript c#json

Answer 1

Answer №1

If you're already utilizing json.net (which seems to be implied by your reference to json.net's JsonTextReader), you can import your JSON data into a JObject and then utilize LINQ to JSON to query the object.

For example, consider the following class:

public class SSKChanges
{
    public string SskSource { get; set; }
    public string SskStatus { get; set; }
    public bool? SskStatusBool { get; set; }
}

You can perform the following:

        var obj = JObject.Parse(jsonExample);
        var lstSSK = (from property in obj.Properties()
                      select new SSKChanges
                      {
                          SskSource = property.Name,
                          SskStatus = property.Value.Children<JProperty>().Select(p2 => p2.Name).FirstOrDefault(),
                          SskStatusBool = property.Value.Children<JProperty>().Select(p2 => (bool?)p2.Value).FirstOrDefault()
                      }).ToList();

Regarding your additional query in your question, about not knowing how to parse in JavaScript and needing assistance with that, it might be best to post a separate question specifically for JavaScript experts.

Answer 2

If you're already utilizing json.net (which seems to be implied by your reference to json.net's JsonTextReader), you can import your JSON data into a JObject and then utilize LINQ to JSON to query the object.

For example, consider the following class:

public class SSKChanges
{
    public string SskSource { get; set; }
    public string SskStatus { get; set; }
    public bool? SskStatusBool { get; set; }
}

You can perform the following:

        var obj = JObject.Parse(jsonExample);
        var lstSSK = (from property in obj.Properties()
                      select new SSKChanges
                      {
                          SskSource = property.Name,
                          SskStatus = property.Value.Children<JProperty>().Select(p2 => p2.Name).FirstOrDefault(),
                          SskStatusBool = property.Value.Children<JProperty>().Select(p2 => (bool?)p2.Value).FirstOrDefault()
                      }).ToList();

Regarding your additional query in your question, about not knowing how to parse in JavaScript and needing assistance with that, it might be best to post a separate question specifically for JavaScript experts.

Answer 3

Answer №2

If you're already working with Json.net, consider utilizing it like this:

string json = @"{""72"": { ""Rejected"": true }, ""271"": { ""PreApproved"": true}}";
var jobj = JObject.Parse(json);

foreach (var entry in jobj.Children().Cast<JProperty>())
{
    var kv = entry.Value.First() as JProperty;
    Console.WriteLine(entry.Name + "=>" + kv.Name + ":"  + kv.Value);
}

Answer 4

If you're already working with Json.net, consider utilizing it like this:

string json = @"{""72"": { ""Rejected"": true }, ""271"": { ""PreApproved"": true}}";
var jobj = JObject.Parse(json);

foreach (var entry in jobj.Children().Cast<JProperty>())
{
    var kv = entry.Value.First() as JProperty;
    Console.WriteLine(entry.Name + "=>" + kv.Name + ":"  + kv.Value);
}

JSON parsing in C#

Answer №1

Answer №2

Similar questions

What is the method to fetch a JSON URL data set (using Ajax and jQuery) in order to generate a dynamic chart display that updates automatically on a Wordpress webpage?

What is the best approach for retrieving a User from my Angular front-end service?

Encountering the "EHOSTUNREACH" error message while attempting to establish a connection to an API through the combination of Axios and Express

Issue with Google Tag Manager click event not propagating to parent element

Instructions for transferring numerous chosen files (such as .doc, .pdf, .jpeg, .png) to a server from an Android device

Press the button to automatically scroll to a designated div section

Problem with sortable columns in DataTables

Angular Card Flip Directive and Its Isolated Scope

Guide on extracting the keys from an object_construct and displaying them in their own distinct column

Tips for utilizing playFromPositionAsync method with expo-av Video in React Native

The appearance of an escape character has been detected within the JSON output

Storing a temporary value within an ng-repeat iteration in AngularJS

Ways to attach an item using its lower point instead of its upper coordinate

Utilize angular to call a function when navigating

I keep encountering a 404 error page not found whenever I try to use the useRouter function. What could

Unable to transfer a file to an FTP server if it is currently being edited by another application in C#

There are multiple 'ConvertFromString' methods for the type that are compatible with the provided arguments

What is the best way to share dynamic content from a DIV or SPAN element on WhatsApp using jQuery?

Running an ESNext file from the terminal: A step-by-step guide

Obtain the Model linked to the relevant View using HtmlHelper