Ошибка при десериализации json

I need to convert JSON data that I get from a REST API and convert them to CSV for some analytic. The problem is that the JSON data do not necessarily follow the same content, so I can’t define a type for mapping. This has become a challenge that is taking too much of my time. I have already created some code, but of course it is not working as it throws exception on this line

var data = JsonConvert.DeserializeObject<List<object>>(jsonData);

The error is:

Additional information: Cannot deserialize the current JSON object
(e.g. {«name»:»value»}) into type
‘System.Collections.Generic.List`1[System.Object]’ because the type
requires a JSON array (e.g. [1,2,3]) to deserialize correctly.

To fix this error either change the JSON to a JSON array (e.g. [1,2,3]) or change the deserialized type so that it is a normal .NET type (e.g. not a primitive type like integer, not a collection type like an array or List) that can be deserialized from a JSON object. JsonObjectAttribute can also be added to the type to force it to deserialize from a JSON object.

Path ‘data’, line 2, position 10.

please let me know what I can do to get this going.

A sample of data would be like this, the fields of data can change very often, for example a new field can be added the next day, so I don’t have the liberty to create a .Net class to map the data.

{
  "data": [
    {
      "ID": "5367ab140026875f70677ab277501bfa",
      "name": "Happiness Initiatives - Flow of Communication/Process & Efficiency",
      "objCode": "PROJ",
      "percentComplete": 100.0,
      "plannedCompletionDate": "2014-08-22T17:00:00:000-0400",
      "plannedStartDate": "2014-05-05T09:00:00:000-0400",
      "priority": 1,
      "projectedCompletionDate": "2014-12-05T08:10:21:555-0500",
      "status": "CPL"
    },
    {
      "ID": "555f452900c8b845238716dd033cf71b",
      "name": "UX Personalization Think Tank and Product Strategy",
      "objCode": "PROJ",
      "percentComplete": 0.0,
      "plannedCompletionDate": "2015-12-01T09:00:00:000-0500",
      "plannedStartDate": "2015-05-22T09:00:00:000-0400",
      "priority": 1,
      "projectedCompletionDate": "2016-01-04T09:00:00:000-0500",
      "status": "APR"
    },
    {
      "ID": "528b92020051ab208aef09a4740b1fe9",
      "name": "SCL Health System - full Sitecore implementation (Task groups with SOW totals in Planned hours - do not bill time here)",
      "objCode": "PROJ",
      "percentComplete": 100.0,
      "plannedCompletionDate": "2016-04-08T17:00:00:000-0400",
      "plannedStartDate": "2013-11-04T09:00:00:000-0500",
      "priority": 1,
      "projectedCompletionDate": "2013-12-12T22:30:00:000-0500",
      "status": "CPL"
    }
 ]
}



namespace BusinessLogic
{
    public class JsonToCsv
    {

       public string ToCsv(string jsonData, string datasetName)
       {
          var data = JsonConvert.DeserializeObject<List<object>>(jsonData);
          DataTable table = ToDataTable(data); 
          StringBuilder result = new StringBuilder();

            for (int i = 0; i < table.Columns.Count; i++)
            {
                result.Append(table.Columns[i].ColumnName);
                result.Append(i == table.Columns.Count - 1 ? "\n" : ",");
            }

            foreach (DataRow row in table.Rows)
            {
                for (int i = 0; i < table.Columns.Count; i++)
                {
                    result.Append(row[i].ToString());
                    result.Append(i == table.Columns.Count - 1 ? "\n" : ",");
                }
            }

            return result.ToString().TrimEnd(new char[] {'\r', '\n'});

        }

        private DataTable ToDataTable<T>( IList<T> data )
            {
            PropertyDescriptorCollection props = TypeDescriptor.GetProperties(typeof(T));
            DataTable table = new DataTable();
            for (int i = 0 ; i < props.Count ; i++)
                {
                PropertyDescriptor prop = props[i];
                table.Columns.Add(prop.Name, prop.PropertyType);
                }

            object[] values = new object[props.Count];
            foreach (T item in data)
                {
                for (int i = 0 ; i < values.Length ; i++)
                    {
                    values[i] = props[i].GetValue(item);
                    }

                table.Rows.Add(values);
                }

            return table;
            }


        }
}

Здравствуйте.

Имею вот такую JSON строку:

{"id":"3","companies_name":"{EQ\r\n"}
{"id":"6","companies_name":"testName Company"}
{"id":"7","companies_name":"testName Company324324"}
{"id":"8","companies_name":"testName Company"}
{"id":"9","companies_name":"testName Companydfgdfgf"}
{"id":"10","companies_name":"testName Company"}
{"id":"13","companies_name":"testName Company"}

Использую Newtonsoft.Json, вот так:

Companies restoredCompanies = JsonConvert.DeserializeObject<Companies>(result.message);

Если JSON приходит с 1 объектом, все ок, если несколько то возникает ошибка:
«Additional text encountered after finished reading JSON content: {. Path », line 1, position 37.»

Я понимаю причину ошибки, то что я несколько элементов пытаюсь записать в 1 объект, но я пытался сделать и вот так:

List<Companies> restoredCompanies = JsonConvert.DeserializeObject<List<Companies>>(result.message);
// и так:

Companies[] restoredCompanies = JsonConvert.DeserializeObject<Companies[]>(result.message);

А вот класс Companies:

class Companies
    {
        public string id { get; set; }
        public string companies_name { get; set; }
    }

Но что то не получается.

Я понимаю что вопрос мега тупой и очень простой, не судите пожалуйста)

P.S. Спасибо всем огромное!

I’m trying to deserialize some JSON response. With simple response I’ve no problem but with a complex response I get this error:

Cannot deserialize the current JSON object (e.g. {«name»:»value»})
into type
‘System.Collections.Generic.List`1[APIEffilogics.Usuari+Node]’ because
the type requires a JSON array (e.g. [1,2,3]) to deserialize
correctly.

To fix this error either change the JSON to a JSON array (e.g.
[1,2,3]) or change the deserialized type so that it is a normal .NET
type (e.g. not a primitive type like integer, not a collection type
like an array or List) that can be deserialized from a JSON object.
JsonObjectAttribute can also be added to the type to force it to
deserialize from a JSON object.

It seems that I have a problem with the type of I put when deserialize the string. The JSON string is like this:

{

        nodes: [
          {
            id: 5,
            global_id: 5,
            description: "Oven",
            room_id: 2,
            floor_id: 1,
            building_id: 1,
            client_id: 2,
            nodemodel_id: 2,
            nodetype_id: 1
          },
          {
            id: 39,
            global_id: 39,
            description: "Fridge",
            room_id: 2,
            floor_id: 1,
            building_id: 1,
            client_id: 2,
            nodemodel_id: 8,
            nodetype_id: 1
          }, ...
        ],
        limit: 10,
        offset: 0
    }

And those are the classes:

public class Node : Usuari      //Estructura nodes
{            
   [JsonProperty("limit")]
   public int limit { get; set; }
   [JsonProperty("offset")]
   public int offset { get; set; }
   [JsonProperty("nodes")]
   public List<Node_sub> nodes_sub { get; set; }
}
public class Node_sub : Node
{
    [JsonProperty("id")]
    public string nid { get; set; }
    [JsonProperty("global_id")]
    public string gid { get; set; }
    [JsonProperty("description")]
    public string descrip { get; set; }
    [JsonProperty("room_id")]
    public string rid { get; set; }
    [JsonProperty("floor_id")]
    public string fid { get; set; }
    [JsonProperty("client_id")]
    public string cid { get; set; }
    [JsonProperty("building_id")]
    public string bid { get; set; }
    [JsonProperty("nodemodel_id")]
    public string model { get; set; }
    [JsonProperty("nodetype_id")]
    public string type { get; set; }
}

The code is:

public void Request(string url, string metode, string value)
        {
            try
            {
                //Enviem la petició a la URL especificada i configurem el tipus de connexió
                HttpWebRequest myReq = (HttpWebRequest)WebRequest.Create(url);

                myReq.KeepAlive = true;
                myReq.Headers.Set("Cache-Control", "no-store");
                myReq.Headers.Set("Pragma", "no-cache");
                myReq.Headers.Set("Authorization", usuari.token_type + " " + usuari.access_token);
                myReq.ContentType = "application/json";

                if (metode.Equals("GET") || metode.Equals("POST"))
                {
                    myReq.Method = metode;  // Set the Method property of the request to POST or GET.
                    if (body == true)
                    {
                        // add request body with chat search filters
                        List<paramet> p = new List<paramet>();
                        paramet p1 = new paramet();
                        p1.value = "1";
                        string jsonBody = JsonConvert.SerializeObject(value);
                        var requestBody = Encoding.UTF8.GetBytes(jsonBody);
                        myReq.ContentLength = requestBody.Length;
                        //myReq.ContentType = "application/json";
                        using (var stream = myReq.GetRequestStream())
                        {
                            stream.Write(requestBody, 0, requestBody.Length);   //Enviem el cos de la petició
                        }
                        body = false;
                    }
                }
                else throw new Exception("Invalid Method Type");

                //Obtenim la resposta del servidor
                HttpWebResponse myResponse = (HttpWebResponse)myReq.GetResponse();
                Stream rebut = myResponse.GetResponseStream();
                StreamReader readStream = new StreamReader(rebut, Encoding.UTF8); // Pipes the stream to a higher level stream reader with the required encoding format. 
                string info = readStream.ReadToEnd();

                if (tipus == 0) jsonclient = JsonConvert.DeserializeObject<List<Usuari.Client>>(info);
                else if (tipus == 1) jsonedif = JsonConvert.DeserializeObject<List<Usuari.Building>>(info);
                else if (tipus == 2) jsonplanta = JsonConvert.DeserializeObject<List<Usuari.Floor>>(info);
                else if (tipus == 3) jsonhab = JsonConvert.DeserializeObject<List<Usuari.Room>>(info);
                else if (tipus == 4) jsonnode = JsonConvert.DeserializeObject<List<Usuari.Node>>(info);
            }

            catch (WebException ex)
            {
                // same as normal response, get error response
                var errorResponse = (HttpWebResponse)ex.Response;
                string errorResponseJson;
                var statusCode = errorResponse.StatusCode;
                var errorIdFromHeader = errorResponse.GetResponseHeader("Error-Id");
                using (var responseStream = new StreamReader(errorResponse.GetResponseStream()))
                {
                    errorResponseJson = responseStream.ReadToEnd();
                }
                //var errorCode = JsonObject.Parse(errorResponseJson).Object("responseStatus")["errorCode"];
                //var errorMessage = JsonObject.Parse(errorResponseJson).Object("responseStatus")["message"];
            }
        }

Why I’m having this error? List<Usuari.Node> is an array that contains all the items of JSON message. I try to fix the error but I’m not able to find and answer. How can I fix it?

Thanks