Json.NET not parsing string to json object

Question

I am using Json.NET to convert a json string to a .net object, i am using the next code which i got from this answer:

dynamic answer = JsonConvert.DeserializeObject(responseString);
Console.WriteLine(answer.ToString());
Console.WriteLine(answer["db"]);

The json string is this one:

[
   {
      "db":"6-y4XlvtqzR.sqlite",
      "users":"INSERT INTO users (id, first_name, last_name, password, email, cel, level) VALUES (17,a,b,f7a9e,[email protected],2,3),(29,c,d,7c4a8d,[email protected],1,4)"
   }
]

The problem is that the application crashes on the third line of my c# code above, and the message error is the next:

A first chance exception of type 'System.ArgumentException' occurred in Newtonsoft.Json.dll

What is the probem with my code? is my json string wrong? or how can i get the json object right?

The funny thing about this is that the second line of the c# code is executed fine and it prints the right string.

You are right, i set Console.WriteLine(answer[0]["db"]); and everything worked — Fernando Santiago
– Fernando Santiago, Commented Dec 10, 2015 at 0:40

Dhanuka777 · Accepted Answer · 2015-12-10 00:50:46Z

Your responsestring should be formatted properly like this,

"{\"db\":\"6-y4XlvtqzR.sqlite\",\"users\":\"INSERT INTO users (id, first_name, last_name, password, email, cel, level) VALUES (17,a,b,f7a9e,[email protected],2,3),(29,c,d,7c4a8d,[email protected],1,4)\"}"

I created following sample and monitored the Json result for the object. Hope this will help.

class Program
{

    class TestClass
    {
        public string db { get; set; }
        public string users { get; set; }

    }


    static void Main(string[] args)
    {
        TestClass ts = new TestClass();
        ts.db = "6-y4XlvtqzR.sqlite";
        ts.users =
            "INSERT INTO users (id, first_name, last_name, password, email, cel, level) VALUES (17,a,b,f7a9e,[email protected],2,3),(29,c,d,7c4a8d,[email protected],1,4)";

        string json = JsonConvert.SerializeObject(ts);
        dynamic answer = JsonConvert.DeserializeObject(json);
        Console.WriteLine(answer.ToString());
        Console.WriteLine(answer["db"]);

    }
}

Nathan Tuggy · Accepted Answer · 2015-12-10 02:04:04Z

0

It's possible to do it with a type specified, such as (assuming ObjectType is the desired return type):

var deserializedObject = JsonConvert.DeserializeObject<ObjectType>(responseString);

And why did you use dynamic?

edited Dec 10, 2015 at 2:04

Nathan Tuggy

2,23727 gold badges33 silver badges38 bronze badges

answered Dec 10, 2015 at 0:44

Yaroslav Shavlovskiy

12 bronze badges

Collectives™ on Stack Overflow

Json.NET not parsing string to json object

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related