Parsing JSON name pair in C#

Question

I am using C# to parse JSON URL. As you know JSON data is written as name/value pairs. Now in URL JSON I have these data:

{  
   "currentVersion":10.41,
   "serviceDescription":"There are some text here",
   "hasVersionedData":true,
   "supportsDisconnectedEditing":false,
   "syncEnabled":false,
   "supportedQueryFormats":"JSON",
   "maxRecordCount":1000
 }

and I want to only print out the name part of the JSON data using this code:

using (var wc = new WebClient())
{
    string json = wc.DownloadString("http://xxxxxxxxx?f=pjson");
    try
    {
        dynamic data = Json.Decode(json);
        for (int i = 0; i <= data.Length - 1; i++)
        {
            Console.WriteLine(data[0]);
        }
        
    }
    catch (Exception e)
    {

    }
}

but this is not printing anything on the console. What am I doing wrong?

What error are you getting? You are eating up the exception. Try write to console and see the error — Ankit Vijay
– Ankit Vijay, Commented Mar 31, 2017 at 18:14
how do u know u are not getting error when u are ignoring exceptions? — Selman Genç
– Selman Genç, Commented Mar 31, 2017 at 18:16

Renats Stozkovs · Accepted Answer · 2017-03-31 18:52:14Z

2

Use Newtonsoft JSON:

JObject jsonObject = JObject.Parse(json);
foreach(var jsonItem in jsonObject)
{
    Console.WriteLine(jsonItem.Key);
}
Console.ReadKey();

answered Mar 31, 2017 at 18:52

Renats Stozkovs

2,63510 gold badges24 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Tarzan · Accepted Answer · 2017-03-31 19:03:58Z

Create an object to hold the results

public class RootObject
{
    public double currentVersion { get; set; }
    public string serviceDescription { get; set; }
    public bool hasVersionedData { get; set; }
    public bool supportsDisconnectedEditing { get; set; }
    public bool syncEnabled { get; set; }
    public string supportedQueryFormats { get; set; }
    public int maxRecordCount { get; set; }
}

Use a JavaScriptSerializer to deserialize the result.

var serializer = new JavaScriptSerializer();
var rootObject= serializer.Deserialize<RootObject>(json);

Console.WriteLine(rootObject.currentVersion);
Console.WriteLine(rootObject.serviceDescription);
etc.

Community · Accepted Answer · 2017-05-23 11:46:24Z

If you are running this under Debug, see here: Attempt by method 'System.Web.Helpers.Json..cctor()' to access method 'System.Web.Helpers.Json.CreateSerializer()' failed once I unchecked Enable the Visual Studio hosting process it run with results. However, to get what I think you want (a listing of each of the key/value pairs I switched to a foreach and it printed it out nicely:

try   

    {    
        var data = Json.Decode(jsonData);    
        //for (var i = 0; i <= data.Length - 1; i++)    
        foreach (var j in data)    
        {    
            Console.WriteLine(j);    
        }    
    }    
    catch (Exception e)    
    {    
        Console.WriteLine(e);    
    }

Collectives™ on Stack Overflow

Parsing JSON name pair in C#

3 Answers 3

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Linked

Related