How can I deserialize an invalid json ? Truncated list of objects
up vote
3
down vote
favorite
My json file is mostly an array that contain objects but the list is incomplete, so I can't use the last entry. I would like to deserialize the rest of the file while discarding the last invalid entry
[ "key" : "value1" , "key " : "value2", { "key
Please tell me if there is a way using Newtonsoft.Json library, or do I need some preprocessing.
Thank you!
json json.net
add a comment |
up vote
3
down vote
favorite
My json file is mostly an array that contain objects but the list is incomplete, so I can't use the last entry. I would like to deserialize the rest of the file while discarding the last invalid entry
[ "key" : "value1" , "key " : "value2", { "key
Please tell me if there is a way using Newtonsoft.Json library, or do I need some preprocessing.
Thank you!
json json.net
JSON is not HTML, there's no good reason to fatten libraries implementing workarounds for invalid data. You are probably using a computer language to process JSON; it shouldn't be difficult to implement preprocessing with string manipulation functions from such lang (C#?).
– Álvaro González
Apr 12 '16 at 14:57
add a comment |
up vote
3
down vote
favorite
up vote
3
down vote
favorite
My json file is mostly an array that contain objects but the list is incomplete, so I can't use the last entry. I would like to deserialize the rest of the file while discarding the last invalid entry
[ "key" : "value1" , "key " : "value2", { "key
Please tell me if there is a way using Newtonsoft.Json library, or do I need some preprocessing.
Thank you!
json json.net
My json file is mostly an array that contain objects but the list is incomplete, so I can't use the last entry. I would like to deserialize the rest of the file while discarding the last invalid entry
[ "key" : "value1" , "key " : "value2", { "key
Please tell me if there is a way using Newtonsoft.Json library, or do I need some preprocessing.
Thank you!
json json.net
json json.net
edited Apr 12 '16 at 14:59
Álvaro González
104k30180270
104k30180270
asked Apr 12 '16 at 14:54
user5441518
906
906
JSON is not HTML, there's no good reason to fatten libraries implementing workarounds for invalid data. You are probably using a computer language to process JSON; it shouldn't be difficult to implement preprocessing with string manipulation functions from such lang (C#?).
– Álvaro González
Apr 12 '16 at 14:57
add a comment |
JSON is not HTML, there's no good reason to fatten libraries implementing workarounds for invalid data. You are probably using a computer language to process JSON; it shouldn't be difficult to implement preprocessing with string manipulation functions from such lang (C#?).
– Álvaro González
Apr 12 '16 at 14:57
JSON is not HTML, there's no good reason to fatten libraries implementing workarounds for invalid data. You are probably using a computer language to process JSON; it shouldn't be difficult to implement preprocessing with string manipulation functions from such lang (C#?).
– Álvaro González
Apr 12 '16 at 14:57
JSON is not HTML, there's no good reason to fatten libraries implementing workarounds for invalid data. You are probably using a computer language to process JSON; it shouldn't be difficult to implement preprocessing with string manipulation functions from such lang (C#?).
– Álvaro González
Apr 12 '16 at 14:57
add a comment |
2 Answers
2
active
oldest
votes
up vote
2
down vote
accepted
You can use the JsonReader class and try to parse as far as you get. Something like the code below will parse as many properties as it gets and then throw an exception. This is of course if you want to deserialize into a concrete class.
public Partial FromJson(JsonReader reader)
while (reader.Read())
// Break on EndObject
if (reader.TokenType == JsonToken.EndObject)
break;
// Only look for properties
if (reader.TokenType != JsonToken.PropertyName)
continue;
switch ((string) reader.Value)
case "Id":
reader.Read();
Id = Convert.ToInt16(reader.Value);
break;
case "Name":
reader.Read();
Name = Convert.ToString(reader.Value);
break;
return this;
Code taken from the CGbR JSON Target.
add a comment |
up vote
3
down vote
Looks like on Json.NET 8.0.3 you can stream your string from a JsonTextReader
to a JTokenWriter
and get a partial result by catching and swallowing the JsonReaderException
that gets thrown when parsing the truncated JSON:
JToken root;
string exceptionPath = null;
using (var textReader = new StringReader(badJson))
using (var jsonReader = new JsonTextReader(textReader))
using (JTokenWriter jsonWriter = new JTokenWriter())
try
jsonWriter.WriteToken(jsonReader);
catch (JsonReaderException ex)
exceptionPath = ex.Path;
Debug.WriteLine(ex);
root = jsonWriter.Token;
Console.WriteLine(root);
if (exceptionPath != null)
Console.WriteLine("Error occurred with token: ");
var badToken = root.SelectToken(exceptionPath);
Console.WriteLine(badToken);
This results in:
[
"key": "value1"
,
"key ": "value2"
,
]
You could then finish deserializing the partial object with JToken.ToObject
. You could also delete the incomplete array entry by using badToken.Remove()
.
It would be better practice not to generate invalid JSON in the first place though. I'm also not entirely sure this is documented functionality of Json.NET, and thus it might not work with future versions of Json.NET. (E.g. conceivably Newtonsoft could change their algorithm such that JTokenWriter.Token
is only set when writing is successful.)
1
Amazing! And still works in Json.NET 11.0.2!
– Sergey Kraev
May 30 at 6:30
add a comment |
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
2
down vote
accepted
You can use the JsonReader class and try to parse as far as you get. Something like the code below will parse as many properties as it gets and then throw an exception. This is of course if you want to deserialize into a concrete class.
public Partial FromJson(JsonReader reader)
while (reader.Read())
// Break on EndObject
if (reader.TokenType == JsonToken.EndObject)
break;
// Only look for properties
if (reader.TokenType != JsonToken.PropertyName)
continue;
switch ((string) reader.Value)
case "Id":
reader.Read();
Id = Convert.ToInt16(reader.Value);
break;
case "Name":
reader.Read();
Name = Convert.ToString(reader.Value);
break;
return this;
Code taken from the CGbR JSON Target.
add a comment |
up vote
2
down vote
accepted
You can use the JsonReader class and try to parse as far as you get. Something like the code below will parse as many properties as it gets and then throw an exception. This is of course if you want to deserialize into a concrete class.
public Partial FromJson(JsonReader reader)
while (reader.Read())
// Break on EndObject
if (reader.TokenType == JsonToken.EndObject)
break;
// Only look for properties
if (reader.TokenType != JsonToken.PropertyName)
continue;
switch ((string) reader.Value)
case "Id":
reader.Read();
Id = Convert.ToInt16(reader.Value);
break;
case "Name":
reader.Read();
Name = Convert.ToString(reader.Value);
break;
return this;
Code taken from the CGbR JSON Target.
add a comment |
up vote
2
down vote
accepted
up vote
2
down vote
accepted
You can use the JsonReader class and try to parse as far as you get. Something like the code below will parse as many properties as it gets and then throw an exception. This is of course if you want to deserialize into a concrete class.
public Partial FromJson(JsonReader reader)
while (reader.Read())
// Break on EndObject
if (reader.TokenType == JsonToken.EndObject)
break;
// Only look for properties
if (reader.TokenType != JsonToken.PropertyName)
continue;
switch ((string) reader.Value)
case "Id":
reader.Read();
Id = Convert.ToInt16(reader.Value);
break;
case "Name":
reader.Read();
Name = Convert.ToString(reader.Value);
break;
return this;
Code taken from the CGbR JSON Target.
You can use the JsonReader class and try to parse as far as you get. Something like the code below will parse as many properties as it gets and then throw an exception. This is of course if you want to deserialize into a concrete class.
public Partial FromJson(JsonReader reader)
while (reader.Read())
// Break on EndObject
if (reader.TokenType == JsonToken.EndObject)
break;
// Only look for properties
if (reader.TokenType != JsonToken.PropertyName)
continue;
switch ((string) reader.Value)
case "Id":
reader.Read();
Id = Convert.ToInt16(reader.Value);
break;
case "Name":
reader.Read();
Name = Convert.ToString(reader.Value);
break;
return this;
Code taken from the CGbR JSON Target.
answered Apr 12 '16 at 15:27
Toxantron
1,625515
1,625515
add a comment |
add a comment |
up vote
3
down vote
Looks like on Json.NET 8.0.3 you can stream your string from a JsonTextReader
to a JTokenWriter
and get a partial result by catching and swallowing the JsonReaderException
that gets thrown when parsing the truncated JSON:
JToken root;
string exceptionPath = null;
using (var textReader = new StringReader(badJson))
using (var jsonReader = new JsonTextReader(textReader))
using (JTokenWriter jsonWriter = new JTokenWriter())
try
jsonWriter.WriteToken(jsonReader);
catch (JsonReaderException ex)
exceptionPath = ex.Path;
Debug.WriteLine(ex);
root = jsonWriter.Token;
Console.WriteLine(root);
if (exceptionPath != null)
Console.WriteLine("Error occurred with token: ");
var badToken = root.SelectToken(exceptionPath);
Console.WriteLine(badToken);
This results in:
[
"key": "value1"
,
"key ": "value2"
,
]
You could then finish deserializing the partial object with JToken.ToObject
. You could also delete the incomplete array entry by using badToken.Remove()
.
It would be better practice not to generate invalid JSON in the first place though. I'm also not entirely sure this is documented functionality of Json.NET, and thus it might not work with future versions of Json.NET. (E.g. conceivably Newtonsoft could change their algorithm such that JTokenWriter.Token
is only set when writing is successful.)
1
Amazing! And still works in Json.NET 11.0.2!
– Sergey Kraev
May 30 at 6:30
add a comment |
up vote
3
down vote
Looks like on Json.NET 8.0.3 you can stream your string from a JsonTextReader
to a JTokenWriter
and get a partial result by catching and swallowing the JsonReaderException
that gets thrown when parsing the truncated JSON:
JToken root;
string exceptionPath = null;
using (var textReader = new StringReader(badJson))
using (var jsonReader = new JsonTextReader(textReader))
using (JTokenWriter jsonWriter = new JTokenWriter())
try
jsonWriter.WriteToken(jsonReader);
catch (JsonReaderException ex)
exceptionPath = ex.Path;
Debug.WriteLine(ex);
root = jsonWriter.Token;
Console.WriteLine(root);
if (exceptionPath != null)
Console.WriteLine("Error occurred with token: ");
var badToken = root.SelectToken(exceptionPath);
Console.WriteLine(badToken);
This results in:
[
"key": "value1"
,
"key ": "value2"
,
]
You could then finish deserializing the partial object with JToken.ToObject
. You could also delete the incomplete array entry by using badToken.Remove()
.
It would be better practice not to generate invalid JSON in the first place though. I'm also not entirely sure this is documented functionality of Json.NET, and thus it might not work with future versions of Json.NET. (E.g. conceivably Newtonsoft could change their algorithm such that JTokenWriter.Token
is only set when writing is successful.)
1
Amazing! And still works in Json.NET 11.0.2!
– Sergey Kraev
May 30 at 6:30
add a comment |
up vote
3
down vote
up vote
3
down vote
Looks like on Json.NET 8.0.3 you can stream your string from a JsonTextReader
to a JTokenWriter
and get a partial result by catching and swallowing the JsonReaderException
that gets thrown when parsing the truncated JSON:
JToken root;
string exceptionPath = null;
using (var textReader = new StringReader(badJson))
using (var jsonReader = new JsonTextReader(textReader))
using (JTokenWriter jsonWriter = new JTokenWriter())
try
jsonWriter.WriteToken(jsonReader);
catch (JsonReaderException ex)
exceptionPath = ex.Path;
Debug.WriteLine(ex);
root = jsonWriter.Token;
Console.WriteLine(root);
if (exceptionPath != null)
Console.WriteLine("Error occurred with token: ");
var badToken = root.SelectToken(exceptionPath);
Console.WriteLine(badToken);
This results in:
[
"key": "value1"
,
"key ": "value2"
,
]
You could then finish deserializing the partial object with JToken.ToObject
. You could also delete the incomplete array entry by using badToken.Remove()
.
It would be better practice not to generate invalid JSON in the first place though. I'm also not entirely sure this is documented functionality of Json.NET, and thus it might not work with future versions of Json.NET. (E.g. conceivably Newtonsoft could change their algorithm such that JTokenWriter.Token
is only set when writing is successful.)
Looks like on Json.NET 8.0.3 you can stream your string from a JsonTextReader
to a JTokenWriter
and get a partial result by catching and swallowing the JsonReaderException
that gets thrown when parsing the truncated JSON:
JToken root;
string exceptionPath = null;
using (var textReader = new StringReader(badJson))
using (var jsonReader = new JsonTextReader(textReader))
using (JTokenWriter jsonWriter = new JTokenWriter())
try
jsonWriter.WriteToken(jsonReader);
catch (JsonReaderException ex)
exceptionPath = ex.Path;
Debug.WriteLine(ex);
root = jsonWriter.Token;
Console.WriteLine(root);
if (exceptionPath != null)
Console.WriteLine("Error occurred with token: ");
var badToken = root.SelectToken(exceptionPath);
Console.WriteLine(badToken);
This results in:
[
"key": "value1"
,
"key ": "value2"
,
]
You could then finish deserializing the partial object with JToken.ToObject
. You could also delete the incomplete array entry by using badToken.Remove()
.
It would be better practice not to generate invalid JSON in the first place though. I'm also not entirely sure this is documented functionality of Json.NET, and thus it might not work with future versions of Json.NET. (E.g. conceivably Newtonsoft could change their algorithm such that JTokenWriter.Token
is only set when writing is successful.)
answered Apr 12 '16 at 15:23
dbc
52.8k867119
52.8k867119
1
Amazing! And still works in Json.NET 11.0.2!
– Sergey Kraev
May 30 at 6:30
add a comment |
1
Amazing! And still works in Json.NET 11.0.2!
– Sergey Kraev
May 30 at 6:30
1
1
Amazing! And still works in Json.NET 11.0.2!
– Sergey Kraev
May 30 at 6:30
Amazing! And still works in Json.NET 11.0.2!
– Sergey Kraev
May 30 at 6:30
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f36576928%2fhow-can-i-deserialize-an-invalid-json-truncated-list-of-objects%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
JSON is not HTML, there's no good reason to fatten libraries implementing workarounds for invalid data. You are probably using a computer language to process JSON; it shouldn't be difficult to implement preprocessing with string manipulation functions from such lang (C#?).
– Álvaro González
Apr 12 '16 at 14:57