Exception when attempting to get JSON array into DataTable C#

Question

I'm trying to get a range of json values into a C# DataTable. I'm at the point where Visual Studio recognises the json objects, but I'm getting this error:

Newtonsoft.Json.JsonSerializationException: 'Additional text found in JSON string after finishing deserializing object.'

Here is an example of the json array:

{
  "aaData": [
    [
      1,
      "Stop",
      "14/03 15:30:03",
      "14/03 15:30:58",
      0,
      "Address",
      "Lat, Long",
      184,
      0,
      9,
      "False"
    ],
    [
      1,
      "Stop",
      "14/03 15:30:03",
      "14/03 15:30:58",
      0,
      "Address",
      "Lat, Long",
      184,
      0,
      9,
      "False"
    ]
  ]
}

And I'm using this code:

JToken token = JObject.Parse(responsetext);
string apistatus = token.SelectToken("aaData").ToString();
DataSet table = JsonConvert.DeserializeObject<DataSet>(apistatus);

But it is at that last line that the exception is thrown.

If I print the string apistatus to the console I can see it has got the arrays - and even when using the JSON Visualiser in VS the arrays are being recognised - but not sure what is wrong. Here's the string apistatus in the console:

   [
    [
      1,
      "Stop",
      "14/03 15:30:03",
      "14/03 15:30:58",
      0,
      "Address",
      "Lat, Long",
      184,
      0,
      9,
      "False"
    ],
    [
      1,
      "Stop",
      "14/03 15:30:03",
      "14/03 15:30:58",
      0,
      "Address",
      "Lat, Long",
      184,
      0,
      9,
      "False"
    ]
  ]

What am I doing wrong? Or is there a much better way to get this particular json array of values into a DataTable?

Why using a DataSet instead of a C# object?

aloisdg
– aloisdg

2017-03-14 17:24:40 +00:00
Commented Mar 14, 2017 at 17:24 — aloisdg
– aloisdg, Commented Mar 14, 2017 at 17:24
stackoverflow.com/questions/39177907/…

Joab Santos
– Joab Santos

2017-03-14 17:38:29 +00:00
Commented Mar 14, 2017 at 17:38 — Joab Santos
– Joab Santos, Commented Mar 14, 2017 at 17:38
Possible duplicate of JSON object to Datatable in C#

Heretic Monkey
– Heretic Monkey

2017-03-14 17:38:58 +00:00
Commented Mar 14, 2017 at 17:38 — Heretic Monkey
– Heretic Monkey, Commented Mar 14, 2017 at 17:38

aloisdg · Accepted Answer · 2017-03-14 17:34:51Z

0

I am not sure about what you are trying to do. If you want to parse a json, you can directly use DeserializeObject:

Demo

using System;
using System.Collections.Generic;
using Newtonsoft.Json;

public class Data
{
    public List<List<object>> AaData { get; set; }
}    

public class Program
{
    public static void Main()
    {
        var json = ""; // your json here
        var m = JsonConvert.DeserializeObject<Data>(json);
        Console.WriteLine(m.AaData[0][0]);
        Console.WriteLine(m.AaData[1][2]);
    }
}

answered Mar 14, 2017 at 17:34

aloisdg

23.8k7 gold badges93 silver badges114 bronze badges

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

2 Comments

reviloRetals Over a year ago

Yes that is almost it.That deserialised JSON needs to go into a DataTable now but not sure how...?

reviloRetals Over a year ago

Any thoughts on how I can do that @aloisdg?

Collectives™ on Stack Overflow

Exception when attempting to get JSON array into DataTable C#

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related