How to create JSON array using Newtonsoft.Json for this specific structure

Question

How do I create a JSON array using Newtonsoft.JSON (json.net) from this json string

[
  {
    "Cells": {
      "results": [
        {
          "Key": "Title",
          "Value": "hello",
          "ValueType": "Edm.String"
        },
        {
          "Key": "Size",
          "Value": "54549",
          "ValueType": "Edm.Int64"
        },
        {
          "Key": "Path",
          "Value": "http://somesite/a/hello.pptx",
          "ValueType": "Edm.String"
        },
        {
          "Key": "Summary",
          "Value": "Some summary <ddd/> interesting reading <ddd/> nice book <ddd/> ",
          "ValueType": "Edm.String"
        },
        {
          "Key": "Name",
          "Value": "http://somesite",
          "ValueType": "Edm.String"
        }
      ]
    }
  },
  {
    "Cells": {
      "results": [
        {
          "Key": "Title",
          "Value": "hi joe",
          "ValueType": "Edm.String"
        },
        {
          "Key": "Size",
          "Value": "41234",
          "ValueType": "Edm.Int64"
        },
        {
          "Key": "Path",
          "Value": "http://someothersite/interesting/hi.pptx",
          "ValueType": "Edm.String"
        },
        {
          "Key": "Summary",
          "Value": "Some summary <ddd/> interesting reading <ddd/> nice book <ddd/> ",
          "ValueType": "Edm.String"
        },
        {
          "Key": "Name",
          "Value": "http://somesite",
          "ValueType": "Edm.String"
        }
      ]
    }
  }
]

json2csharp gives me following classes for this structure

public class Result
{
    public string Key { get; set; }
    public string Value { get; set; }
    public string ValueType { get; set; }
}

public class Cells
{
    public List<Result> results { get; set; }
}

public class RootObject
{
    public Cells Cells { get; set; }
}

How do I use these classes to create json array?

UPDATE AND SOLUTION

this will work

static void Main(string[] args)
{
    RootObject ro = new RootObject();
    Cells cs = new Cells();
    cs.results = new List<Result>();

    Result rt = new Result();
    rt.Key = "Title";
    rt.Value = "hello";
    rt.ValueType = "Edm.String";
    cs.results.Add(rt);

    Result rs = new Result();
    rs.Key = "Size";
    rs.Value = "3223";
    rs.ValueType = "Edm.Int64";
    cs.results.Add(rs);

    ro.Cells = cs;

    string json = JsonConvert.SerializeObject(ro);
}

Rather than including the answer in your question, you could answer your own question and accept the answer so the rest of us can tell your question is resolved. — dbc
– dbc, Commented Jun 1, 2017 at 20:00

pixel · Accepted Answer · 2017-06-01 20:09:51Z

2

this will work

static void Main(string[] args)
{
    RootObject ro = new RootObject();
    Cells cs = new Cells();
    cs.results = new List<Result>();

    Result rt = new Result();
    rt.Key = "Title";
    rt.Value = "hello";
    rt.ValueType = "Edm.String";
    cs.results.Add(rt);

    Result rs = new Result();
    rs.Key = "Size";
    rs.Value = "3223";
    rs.ValueType = "Edm.Int64";
    cs.results.Add(rs);

    ro.Cells = cs;

    string json = JsonConvert.SerializeObject(ro);
}

answered Jun 1, 2017 at 20:09

pixel

10.8k21 gold badges103 silver badges196 bronze badges

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

Comments

Kyle · Accepted Answer · 2017-06-01 19:33:56Z

1

You're looking for the function DeserializeObject<T>:

var json = ""; // string up above in your code
var jObect = JsonConvert.DeserializeObject<RootObject>(json);

// Use

var cells = jObject.Cells;
var result1 = cells.results.FirstOrDefault();

answered Jun 1, 2017 at 19:33

Kyle

5,6077 gold badges38 silver badges48 bronze badges

3 Comments

pixel Over a year ago

Thanks, but I need to produce json string from my objects, see Update above.

Kyle Over a year ago

@pixel Going in the opposite direction is var jsonStr = JsonConvert.SerializeObject(myObject).

pixel Over a year ago

Actually, what I need next is to convert it back to JArray not jsonString :)

Ben Brown · Accepted Answer · 2017-06-01 19:45:47Z

0

Given an example of a POCO below:

    public class Account
{
    public string Email { get; set; }
    public bool Active { get; set; }
    public DateTime CreatedDate { get; set; }
    public IList<string> Roles { get; set; }
}

This can be achieved by deserializing your JSON string show below:

    string json = @"{
   'Email': '[email protected]',
   'Active': true,
   'CreatedDate': '2013-01-20T00:00:00Z',
   'Roles': [
     'User',
     'Admin'
   ]
 }";

Account account = JsonConvert.DeserializeObject<Account>(json);

Console.WriteLine(account.Email);

Reference Newtonsoft's documentation below: http://www.newtonsoft.com/json/help/html/DeserializeObject.htm

answered Jun 1, 2017 at 19:45

Ben Brown

3292 silver badges9 bronze badges

1 Comment

pixel Over a year ago

Thanks, I dont want to use json string. I am providing json string above just to show the structure.

user1587368 · Accepted Answer · 2017-06-01 19:49:03Z

0

If you want the string representation of an object, especially a json object, the most relevant is .ToString (). But, it could fail for other reasons ...

answered Jun 1, 2017 at 19:49

user1587368

3162 silver badges6 bronze badges

Collectives™ on Stack Overflow

How to create JSON array using Newtonsoft.Json for this specific structure

4 Answers 4

Comments

3 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

3 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related