Parse json string to C# objects

Question

1.00/5 (1 vote)

See more:

Hi there! I am dealing with a non standard json string, here:

string a = "[[\"test, test\",\"{\\\"prop1\\\":1,\\\"prop2\\\":\\\"test\\\",\\\"prop3\\\":\\\"test\\\"}\"],[\"test2, test2\",\"{\\\"prop1\\\":2,\\\"prop2\\\":\\\"test2\\\",\\\"prop3\\\":\\\"test2\\\"}\"]]";

And trying to parse this string to an object. Tried, like, everything :( Nothing works. I am not really sure, if I understand this json structure correctly. I would really appreciate, if someone could help me with this. Here is formatted JSON:

[
	[
		"test",
		{
			"prop1": 1,
			"prop2": "test",
			"prop3": "test"
		}
	],
	[
		"test2",
		{
			"prop1": 2,
			"prop2": "test2",
			"prop3": "test2"
		}
	]
]

But I still do not understand its structure.

What I have tried:

I have created some objects for this json, as far as I can understand its structure. Here they are:

class Details
{
    public int prop1 { get; set; }
    public string prop2 { get; set; }
    public string prop3 { get; set; }
}
class Name
{
    public string FullName { get; set; }
}
class Class
{
    public Name FullName { get; set; }
    public Details Details { get; set; }
}

And trying to deserialize this way:

string a = "[[\"test, test\",\"{\\\"prop1\\\":1,\\\"prop2\\\":\\\"test\\\",\\\"prop3\\\":\\\"test\\\"}\"],[\"test2, test2\",\"{\\\"prop1\\\":2,\\\"prop2\\\":\\\"test2\\\",\\\"prop3\\\":\\\"test2\\\"}\"]]";
List< Class > obj = JsonConvert.DeserializeObject<List<Class>>(a);

Posted 23-Sep-17 0:44am

csrss

Updated 23-Sep-17 2:34am

v2

Add a Solution

Comments

Richard MacCutchan 23-Sep-17 7:32am

If you get rid of all those backslash characters and reformat the remaining text properly it will be easy to figure out the structure. Maybe if you explained what problem you have then people would be able to make suggestions.

csrss 23-Sep-17 7:35am

Here is formatted json:
[
[
"test",
{
"prop1": 1,
"prop2": "test",
"prop3": "test"
}
],
[
"test2",
{
"prop1": 2,
"prop2": "test2",
"prop3": "test2"
}
]
]

I still got no idea, what the object structure is.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

csrss · Answer 1 · 2017-09-23T02:06:00

Solution 1

Alright, found a way:

JArray array = JArray.Parse(a);
foreach(JToken jToken in array)
{
    JToken[] innerArray = jToken.ToArray();
    string fullName = innerArray[0].Value<string>();
    Details details = JObject.Parse(innerArray[1].Value<string>()).ToObject<Details>();
}

Posted 23-Sep-17 2:06am

csrss

Graeme_Grant · Answer 2 · 2017-09-23T02:34:00

Solution 2

THis article will show you an easier way: Working with JSON in C# & VB[^]

Posted 23-Sep-17 2:34am

Graeme_Grant