Parsing JSON data from a stream

Question

Parsing JSON data from a stream

I have been working with an API lately that provides data in JSON format, and I know the fields it contains. I am trying to deserialize this data into a list format. I checked out the Newtonsoft.Json namespace for help, but unfortunately, the article I came across didn't quite address my specific issue since I am not familiar with the key/value pairs used. You can find the article here: http://www.newtonsoft.com/json/help/html/deserializeobject.htm

Here is a snippet of my code:

static void GetShares()
{
    WebRequest request = WebRequest.Create("https://shares.ppe.datatransfer.microsoft.com/api/v1/data/shares/");

    request.Method = "GET";
    request.Headers.Add("Authorization","Basic "+
    Convert.ToBase64String(
    Encoding.ASCII.GetBytes("useridandpassword")));
    request.ContentType = "application/json";
    WebResponse response = request.GetResponse();
    Stream dataStream = response.GetResponseStream();

    // Open the stream using a StreamReader for easy access.
    StreamReader reader = new StreamReader(dataStream);

    // Read the content.
    string responseFromServer = reader.ReadToEnd();

    Console.WriteLine(responseFromServer);
}

javascript c#json asp.net-mvc json.net

Answer 1

Answer №1

After running the code provided, the console output is displaying data in a non-indented format as shown below:

[
  {
    "browse_count": 0,
    "bytes_free_string": null,
    "bytes_total_string": null,
    "bytes_unknown": true,
    "comment_added_at": null,
    "content_added_at": null,
    "created_at": "2016-06-09T17:23:53-07:00",
    "directory": "/",
    "error_bytes_free_size": null,
    "error_percent_free": null,
    "home_share": false,
    "id": 63,
    "name": "linuxServerRoot",
    "node_id": 5,
    "percent_free": null,
    "status": null,
    "status_at": "2016-12-06T21:24:26-08:00",
    "status_message": null,
    "updated_at": "2016-12-06T21:24:26-08:00",
    "warn_bytes_free_size": null,
    "warn_percent_free": null
  },
  // more JSON data here...
]

In order to display this JSON data in a readable format on the console, you need to deserialize it. To achieve this, you can utilize the Newtonsoft.Json library by adding the Json.NET NuGet package to your project and including the following code snippet before the

Console.WriteLine(responseFromServer);

statement:

JToken jsonToken = JToken.Parse(responseFromServer);
responseFromServer = jsonToken.ToString(Newtonsoft.Json.Formatting.Indented);

By implementing the above code, the JSON data will be formatted and displayed in a readable manner on the console window.

Answer 2

After running the code provided, the console output is displaying data in a non-indented format as shown below:

[
  {
    "browse_count": 0,
    "bytes_free_string": null,
    "bytes_total_string": null,
    "bytes_unknown": true,
    "comment_added_at": null,
    "content_added_at": null,
    "created_at": "2016-06-09T17:23:53-07:00",
    "directory": "/",
    "error_bytes_free_size": null,
    "error_percent_free": null,
    "home_share": false,
    "id": 63,
    "name": "linuxServerRoot",
    "node_id": 5,
    "percent_free": null,
    "status": null,
    "status_at": "2016-12-06T21:24:26-08:00",
    "status_message": null,
    "updated_at": "2016-12-06T21:24:26-08:00",
    "warn_bytes_free_size": null,
    "warn_percent_free": null
  },
  // more JSON data here...
]

In order to display this JSON data in a readable format on the console, you need to deserialize it. To achieve this, you can utilize the Newtonsoft.Json library by adding the Json.NET NuGet package to your project and including the following code snippet before the

Console.WriteLine(responseFromServer);

statement:

JToken jsonToken = JToken.Parse(responseFromServer);
responseFromServer = jsonToken.ToString(Newtonsoft.Json.Formatting.Indented);

By implementing the above code, the JSON data will be formatted and displayed in a readable manner on the console window.

Answer 3

Answer №2

Here is the solution:

WebRequest request = WebRequest.Create("https://shares.ppe.datatransfer.microsoft.com/api/v1/data/shares/");

request.Method = "GET";
request.Headers.Add("Authorization", "Basic " +
Convert.ToBase64String(
Encoding.ASCII.GetBytes("username:password")));
request.ContentType = "application/json";
WebResponse response = request.GetResponse();
Stream dataStream = response.GetResponseStream();

// Use StreamReader to read stream easily.
StreamReader reader = new StreamReader(dataStream);

// Read the content.
string responseFromServer = reader.ReadToEnd();

JArray items = JArray.Parse(responseFromServer);

Console.WriteLine($"{"Property Keys".PadRight(24)}Values");
Console.WriteLine($"{"".PadRight(50, '-')}");

foreach (JToken token in items)
{
    Dictionary<string, string> dictionary = token.ToObject<Dictionary<string, string>>();

    int length = 28;

    foreach (var property in dictionary)
    {
        Console.WriteLine($"{property.Key.PadRight(length)}{property.Value}");
    }

    Console.WriteLine($"----------------------");
}

This code snippet extracts keys from a deserialized JSON array by parsing it into a dictionary and displaying them with proper padding. Adjust the key length padding as needed for optimal display.

Answer 4

Here is the solution:

WebRequest request = WebRequest.Create("https://shares.ppe.datatransfer.microsoft.com/api/v1/data/shares/");

request.Method = "GET";
request.Headers.Add("Authorization", "Basic " +
Convert.ToBase64String(
Encoding.ASCII.GetBytes("username:password")));
request.ContentType = "application/json";
WebResponse response = request.GetResponse();
Stream dataStream = response.GetResponseStream();

// Use StreamReader to read stream easily.
StreamReader reader = new StreamReader(dataStream);

// Read the content.
string responseFromServer = reader.ReadToEnd();

JArray items = JArray.Parse(responseFromServer);

Console.WriteLine($"{"Property Keys".PadRight(24)}Values");
Console.WriteLine($"{"".PadRight(50, '-')}");

foreach (JToken token in items)
{
    Dictionary<string, string> dictionary = token.ToObject<Dictionary<string, string>>();

    int length = 28;

    foreach (var property in dictionary)
    {
        Console.WriteLine($"{property.Key.PadRight(length)}{property.Value}");
    }

    Console.WriteLine($"----------------------");
}

This code snippet extracts keys from a deserialized JSON array by parsing it into a dictionary and displaying them with proper padding. Adjust the key length padding as needed for optimal display.

Parsing JSON data from a stream

Answer №1

Answer №2

Similar questions

Python code for performing a surgical replacement of a JSON field with another in a file

Tips for automatically incorporating animation upon page initialization

How to utilize a parameter value as the name of an array in Jquery

How to exclude specific properties from JSON serialization in Spring MVC using Jackson?

Transform your .obj files into .glb files effortlessly with npm and Laravel

Animating slides with CSS Keyframes and React, incorporating toggle slide fade out and slide fade (back) in

Removing elements from an array within a function

Continuously make Ajax requests to populate numerous div elements

Refreshing Ajax in a different tab causes the selectize element to become unbound from the editing form in Rails 5

JavaScript concatenation of arrays

Using Ajax and JQuery to show a success message prominently

Issue with Jest: Mocked function not found by Vue Component

Transforming nested JSON files into nested jQuery divs

The JavaScript and CSS properties are not functioning properly with the HTML text field

Encountering an issue when attempting to host a Next.js application on Vercel

Typescript does not produce unused members

NEXT JS - Application renders twice due to rewrites in place

Tips for sending an object to an action method in ASP.NET Core MVC

Is it possible to combine the existing request parameters with a new parameter in JSP/JSTL/JQuery?

Setting the selected value of a static select menu in Angular 2 form