Parsing JSON Name Pair in C#

Question

Using C# to parse JSON URL I am facing some issues. 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 any thing on the console! can you please let me know what I am doing wrong?

Possible duplicate of [How to get a json string from url?](http://stackoverflow.com/questions/5566942/how-to-get-a-json-string-from-url) — scrappedcola, Mar 31 '17 at 18:14
What error are you getting? You are eating up the exception. Try write to console and see the error — Ankit Vijay, Mar 31 '17 at 18:14
how do u know u are not getting error when u are ignoring exceptions? — Selman Genç, Mar 31 '17 at 18:16
@scrappedcola, This actually different question as I have not issue on downloading the JSON ! my question is how to filter the result to show only the name pair Please read the question again, thanks — Behseini, Mar 31 '17 at 18:18

score 2 · Answer 1 · answered Mar 31 '17 at 18:52

2

Use Newtonsoft JSON:

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

answered Mar 31 '17 at 18:52

Renats Stozkovs

2,549
10
22
26

score 0 · Answer 2 · answered Mar 31 '17 at 19:03

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.

score 0 · Answer 3 · edited May 23 '17 at 11:46

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);    
    }

Parsing JSON Name Pair in C#

3 Answers3