Converting list of objects to json array

Question

I have a List of class objects that have email address and status data members. I am trying to convert these to a json, making sure to have the "operations" word on the array.

This is my class:

class MyClass
{
    public string email {get; set; }
    public string status { get; set; }
}

This is my current code (not building):

List<MyClass> data = new List<MyClass>();
data = MagicallyGetData();

string json = new {
     operations = new {
          JsonConvert.SerializeObject(data.Select(s => new {
               email_address = s.email,
               status = s.status
          }))
     }
};

This is the JSON I am trying to get:

{
  "operations": [
    {
      "email_address": "email1@email.com",
      "status": "good2go"
    },
    {
      "email_address": "email2@email.com",
      "status": "good2go"
    },...
  ]
}

EDIT1 I should mention that the data I am getting for this comes from a DB. I am de-serializing a JSON from the DB and using the data in several different ways, so I cannot change the member names of my class.

Why are your annoying yourself with anonymous objects ? Use datacontrat instead or name attribute http://www.newtonsoft.com/json/help/html/JsonPropertyName.htm — cdie, Feb 26 '16 at 14:34
@ Arpit The closest I have gotten is the same output without the operations string before the array. — Blankdud, Feb 26 '16 at 14:48
I assume this was with [Json.NET from Newtonsoft](https://www.newtonsoft.com/json/help/html/Overload_Newtonsoft_Json_JsonConvert_SerializeObject.htm) — surfmuggle, Nov 24 '22 at 21:08

score 13 · Accepted Answer · edited Nov 24 '22 at 21:34

13

I believe this will give you what you want. You will have to change your class property names if possible.

Given this class

class MyClass
{
   public string email_address { get; set; }
   public string status { get; set; }
}

You can add the objects to a list

List<MyClass> data = new List<MyClass>()
{ 
   new MyClass(){email_address = "e1@it.io", status = "s1"}
   , new MyClass(){ email_address = "e2@it.io", status = "s1"}
};

Using an anonymous-type you can assign data to the property operations

var json = JsonConvert.SerializeObject(new
{
   operations = data
});

edited Nov 24 '22 at 21:34

surfmuggle

5,527
7
48
77

answered Feb 26 '16 at 14:38

James Dev

2,979
1
11
16

With a few tweaks, this is the solution I went with. Thanks, appreciate it. – Blankdud Feb 26 '16 at 17:45
1

What, if I don't want either data or operations at the beginning? – Hafiz H Oct 13 '16 at 16:34
1

@HafizH if you don't want "operations" at the beginning simply do: `var json = JsonConvert.SerializeObject(operations)` – Valip Apr 20 '17 at 11:09

score 3 · Answer 2 · answered Mar 27 '18 at 18:30

class MyClass
{
     public string email_address { get; set; }
     public string status { get; set; }
}

List<MyClass> data = new List<MyClass>() { new MyClass() { email_address = "email1@email.com", status = "good2go" }, new MyClass() { email_address = "email2@email.com", status = "good2go" } };

//Serialize
var json = JsonConvert.SerializeObject(data);

//Deserialize
var jsonToList = JsonConvert.DeserializeObject<List<MyClass>>(json);

score 0 · Answer 3 · answered Feb 26 '16 at 14:50

0

You can try with something like this:

using System.Web.Script.Serialization;
var jsonSerialiser = new JavaScriptSerializer();
var json = jsonSerialiser.Serialize(data);

answered Feb 26 '16 at 14:50

Claudio

642
3
12

score -1 · Answer 4 · answered Jun 06 '21 at 13:37

-1

Here is the simple code

JArray.FromObject(objList);

answered Jun 06 '21 at 13:37

Syed Nazir Hussain

441
6
10

To be able to understand your answer more details are needed. Currently it looks to me that this will not work. – surfmuggle May 05 '22 at 10:50

Converting list of objects to json array

4 Answers4

Here is the simple code

Linked