How can i read the json file in C#?

Francisco Leal

I want to retrieve the Id, profileIconId etc.. in variables or in one array.
Here is the json:

{"kiko298": { "id": 23076700, "name": "kiko298", "profileIconId": 748, "revisionDate": 1419104454000, "summonerLevel": 30 }}

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Francisco Leal11y ago
Oh, u just gave me an idea that probably will work. Thanks very much!
Vulpes11y ago
Unfortunately, that won't work as attribute arguments must be compile time constants.

The best I can suggest would be to use a regular expression to replace A's property name within the json string, whatever it might be, with "kiko298" BEFORE it's deserialized.

For example, this is working OK:

using System;
using System.IO;
using System.Text;
using System.Runtime.Serialization;
using System.Runtime.Serialization.Json;
using System.Text.RegularExpressions;

namespace ParseJson
{
class Program
{
static void Main(string[] args)
{
string json = "{\"whatever\": { \"id\": 23076700, \"name\": \"kiko298\", \"profileIconId\": 748, \"revisionDate\": 1419104454000, \"summonerLevel\": 30 }}";
Regex r = new Regex(@""".*?""");
json = r.Replace(json, @"""kiko298""", 1);
byte[] data = Encoding.UTF8.GetBytes(json);
var ms = new MemoryStream(data);
var dcjs = new DataContractJsonSerializer(typeof(A));
A a = (A)dcjs.ReadObject(ms);
Console.WriteLine(a.Kiko298);
Console.ReadKey();
}
}

// etc
}
Francisco Leal11y ago
[EDITED]
Ok i've found the reference but the first kiko298 may change, depending of the json im reading.
Is there a way to make something like this:

[DataContract]
public class A
{
[DataMember(Name = File.ReadAllText(Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData) + "\\ID.li"))]
public B Kiko298 { get; set; }
}

because i need it to change according to the json i read!
Vulpes11y ago
Incidentally, if you don't have one already, a reference needs to be added to System.Runtime.Serialization.dll for the above code to work (.NET 3.5 or later).
Francisco Leal11y ago
Thanks very much!!
Vulpes11y ago
Here's one way of doing it without leaving the .NET framework:

using System;
using System.IO;
using System.Text;
using System.Runtime.Serialization;
using System.Runtime.Serialization.Json;

namespace ParseJson
{
class Program
{
static void Main(string[] args)
{
string json = "{\"kiko298\": { \"id\": 23076700, \"name\": \"kiko298\", \"profileIconId\": 748, \"revisionDate\": 1419104454000, \"summonerLevel\": 30 }}";
byte[] data = Encoding.UTF8.GetBytes(json);
var ms = new MemoryStream(data);
var dcjs = new DataContractJsonSerializer(typeof(A));
A a = (A)dcjs.ReadObject(ms);
Console.WriteLine(a.Kiko298);
Console.ReadKey();
}
}

[DataContract]
public class A
{
[DataMember(Name = "kiko298")]
public B Kiko298 { get; set; }
}

[DataContract]
public class B
{
public B() { }

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

[DataMember(Name = "name")]
public string Name { get; set; }

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

[DataMember(Name = "revisionDate")]
public long RevisionDate { get; set; }

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

public override string ToString()
{
return String.Format("Id = {0}\nName = {1}\nProfile Icon Id = {2}\nRevision Date = {3}\nSummoner Level = {4}", Id, Name, ProfileIconId, RevisionDate, SummonerLevel);
}
}
}

The output is:

Id = 23076700
Name = kiko298
Profile Icon Id = 748
Revision Date = 1419104454000
Summoner Level = 30

As I don't know what these objects represent, I've just called them class A and class B for now but you can, of course, call them what you like.