Parse Json response and create List of files

Question

how can i parse this json response and create c# object

{"Response":"valid","Files":{"0":{"FileURL":"htp:\/\/somedomain.com\/1.exe","FileVersion":1},"1":{"FileURL":"htp:\/\/somedomain.com\/1.exe","FileVersion":2}}}

i have c# class

public class Files
{
public string fileURL;
public string fileVersion;
}


WebClient wc=new WebClient();
string code=wc.DownloadString("http://somedomain.com/GetLatestFiles.php");
List<Files> f=ParseJson(code);

how can i parse this json please help. I need to implement ParseJson which will return files list or can i deserialize this response to c# class?

Thankyou

Edit implemented some solution but its very slow?

public class LatestFile
    {
        public string fileURL;
        public string fileVersion;
    }


private List<LatestFile> ParseJson(string code)
        {
            List<LatestFile> files = new List<LatestFile>();

            dynamic jObj = JsonConvert.DeserializeObject(code);

            foreach (var child in jObj.Files.Children())
            {
                string index = child.Name;
                string url = child.First.FileURL.Value;
                string version = child.First.FileVersion.Value.ToString();
                LatestFile f = new LatestFile();
                f.fileURL = url;
                f.fileVersion = version;
                files.Add(f);

            }
            return files;
        }

Based on @Brian Rogers answer below i am able to implement the generic solution working fast and efficiently.Thanks

https://dotnetfiddle.net/tC0Dws

Brian Rogers · Accepted Answer · 2015-04-01 01:14:29Z

2

Try defining your classes like this:

public class RootObject
{
    public string Response { get; set; }
    public Dictionary<string, LatestFile> Files { get; set; }
}

public class LatestFile
{
    public string FileURL { get; set; }
    public string FileVersion { get; set; }
}

And make your helper method like this:

private List<LatestFile> ParseJson(string json)
{
    RootObject obj = JsonConvert.DeserializeObject<RootObject>(json);
    return obj.Files.Values.ToList();
}

Fiddle: https://dotnetfiddle.net/vpre5H

answered Apr 1, 2015 at 1:14

Brian Rogers

130k31 gold badges315 silver badges315 bronze badges

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

4 Comments

Ikram Khan Over a year ago

thankyou! Brian Rogers. it solve my issue. also one question can i parse that "0":{" so suppose if i want to add one more property string index to latestfile class can i parse that what need to be done?

Ikram Khan Over a year ago

dotnetfiddle.net/tC0Dws see this modification i can get index now i don't know if its best practice

Brian Rogers Over a year ago

@IkramKhan If you need the index, then yes, you'd need to get it from the KeyValuePair like you are doing. You can simplify it a bit using Linq (assuming you're comfortable with lambda expressions), but what you have will work fine.

Ikram Khan Over a year ago

well yes thats a great solution you have provided Thanks alot!. Actually theres another json response which have database ID for transactions just like here we have for index and we need to parse and insert that in db i will use similar technique.your solution save my time

PiotrWolkowski · Accepted Answer · 2015-04-01 02:23:38Z

1

According to the JSON you provided you have three different objects there. First with Response and Files fields. Second - it looks like it's intended to be a collection but with current implementation it's an object - with fields 0 and 1. And third one with fields FileURL and FileVersion.

You can use DataContractJsonSerializer which is available starting from .Net 4.5. It's in System.Runtime.Serialization.Json namespace.

To parse your JSON you need following data structure:

[DataContract]
public class JsonResponse
{
    [DataMember(Name = "Response")]
    public string Response { get; set; }

    [DataMember(Name = "Files")]
    public Files Files { get; set; }
}
[DataContract]
public class Files
{
    [DataMember(Name = "0")]
    public MyFile Frst { get; set; }

    [DataMember(Name = "1")]
    public MyFile Scnd { get; set; }
}

[DataContract]
public class MyFile
{
    [DataMember(Name = "FileURL")]
    public string FileURL { get; set; }

    [DataMember(Name = "FileVersion")]
    public int FileVersion { get; set; }
}

To make testing easier I'm using your sample as a string but you can easily use URL or a Stream:

static string json = @"
{
    ""Response"":""valid"",
    ""Files"":
    {
        ""0"":
        {
            ""FileURL"":""htp:\/\/somedomain.com\/1.exe"",""FileVersion"":""1""
        },
        ""1"":
        {
            ""FileURL"":""htp:\/\/somedomain.com\/1.exe"",""FileVersion"":""2""
        }
    }
}";

static void Main(string[] args)
{
    var serializer = new DataContractJsonSerializer(typeof(JsonResponse));

    DataContractJsonSerializer js = new DataContractJsonSerializer(typeof(JsonResponse));
    using (MemoryStream ms = new MemoryStream(System.Text.ASCIIEncoding.ASCII.GetBytes(json)))
    {
        JsonResponse response = (JsonResponse)js.ReadObject(ms);
    }
}

And that's the result:

enter image description here

answered Apr 1, 2015 at 2:23

PiotrWolkowski

8,8007 gold badges53 silver badges77 bronze badges

2 Comments

Ikram Khan Over a year ago

nice but still not generic. and i guess its not possible for this type of json right meaning if more files are there i need to add more datamembers in Files right?

PiotrWolkowski Over a year ago

If you have an option to slightly modify your JSON and make it a list the solution will be way simpler. Something like this will do the trick:

"Files": [{"FileURL":"htp:\/\/somedomain.com\/1.exe","FileVersion":"1"}, {"FileURL":"htp:\/\/somedomain.com\/1.exe","FileVersion":"2"}]

. Then, in JsonResponse the Files property is actually a List<MyFile>.

Collectives™ on Stack Overflow

Parse Json response and create List of files

2 Answers 2

4 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related