c# JSON object dynamic variables

Question

I have a requirement to generate the following JSON using c# objects:

Right now Im using HttpResponseMessage (Web API) So I dont need any JSON.NET to do any extra conversion from my object.

returnVal = Request.CreateResponse(HttpStatusCode.OK, new Model.Custom.JsonResponse
                {
                    data = root,
                    success = true
                });

This is the JSON that I need to generate:

'data': [{
     'some var 1': 'value A',
     'some var 2': 'value B',
     'some var 3': 'value C'
 }, {
     'some var 1': 'value A',
     'some var 2': 'value B',
     'some var 3': 'value C'
 }, {
     'some var 1': 'value A',
     'some var 2': 'value B',
     'some var 3': 'value C'
 }]

Where 'some var' is dynamic.

Right now I was trying to use List<Dictionary<string,object>>(); but the problem is that with this approach I can only generate this:

 'data': [{
     'some var 1': 'value A'
 }, {
     'some var 1': 'value A'
 }, {
     'some var 1': 'value A'
 }]

My actual classes look like this:

public class RootObject {
    public bool success {
        get;
        set;
    }
    public List < Dictionary < string, object >> jsonData {
        get;
        set;
    }
}

var root = new RootObject();

root.jsonData = new List < Dictionary < string, object >> ();

// create new record
var newRecord = new Dictionary < string,object > ();
newRecord.Add("1", "H"); // 1 = some var 1, H = value A 
// add record to collection
root.jsonData.Add(newRecord);

// create new record
newRecord = new Dictionary < string, object > ();
newRecord.Add("5", "L");
// add record to collection
root.jsonData.Add(newRecord);

So this will output:

 'data': [{
     '1': 'H'
 }, {
     '5': 'L'
 }]

Any clue? Thanks

L.B · Accepted Answer · 2014-07-02 18:15:31Z

2

public class MyClass
{
    public List<JObject> data = new List<JObject>();
}

var m = new MyClass();
m.data.Add(new JObject());
m.data.Add(new JObject());

m.data[0]["some var 1"] = "value A";
m.data[0]["some var 2"] = "value B";
m.data[0]["some var 3"] = "value C";

m.data[1]["some var 1"] = "value A";
m.data[1]["some var 2"] = "value B";
m.data[1]["some var 3"] = "value C";

var json = JsonConvert.SerializeObject(m);

OUTPUT

{
  "data": [
    {
      "some var 1": "value A",
      "some var 2": "value B",
      "some var 3": "value C"
    },
    {
      "some var 1": "value A",
      "some var 2": "value B",
      "some var 3": "value C"
    }
  ]
}

answered Jul 2, 2014 at 18:15

L.B

116k20 gold badges189 silver badges229 bronze badges

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

Comments

Mike Hixson · Accepted Answer · 2014-07-02 18:12:22Z

0

You just need to add more elements to your dictionary:

newRecord.Add("1", "H");
newRecord.Add("2", "I");
newRecord.Add("3", "J");

answered Jul 2, 2014 at 18:12

Mike Hixson

5,2171 gold badge21 silver badges24 bronze badges

3 Comments

VAAA Over a year ago

This will just output {"1":"H"},{"2":"I"},{"3":"J"} instead of {"1":"H","2":"I", "3":"J"}

VAAA Over a year ago

Because after newRecord I have to add the newRecord to the Dictionary List.

Mike Hixson Over a year ago

Looks like you are getting the behavior of the crappy DataContractJsonSerializer. You may want to try swapping it out for JSON.NET instead: blogs.msdn.com/b/henrikn/archive/2012/02/18/…

Eric Scherrer · Accepted Answer · 2014-07-02 18:14:53Z

0

This is what I get when I paste your JSON into Visual Studio "as JSON":

public class Rootobject
{
    public Datum[] data { get; set; }
}

public class Datum
{
    public string somevar1 { get; set; }
    public string somevar2 { get; set; }
    public string somevar3 { get; set; }
}

answered Jul 2, 2014 at 18:14

Eric Scherrer

3,4091 gold badge21 silver badges35 bronze badges

2 Comments

VAAA Over a year ago

That wont be dynamic. Because the Class has the variable name fixed.

Eric Scherrer Over a year ago

Looks like @L.B. has your answer then.

Collectives™ on Stack Overflow

c# JSON object dynamic variables

3 Answers 3

Comments

3 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

3 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related