Read and save unknown key value pair in JSON

Question

I am making an API call. On successful completion I know the structure of JSON response. I can read that and save it on DB using JSON.NET, but if the API calls generates error, a JSON of unknown structure is generated. I have to parse and save it in DB. How can I do that.
In genral structure of error response is this:

{"origin-of_error":"error_message"}

There are some cases though where additional key value is also present.

Has the unknown json-object always the structure origin : error like { foo : bar } or could it be { foo : bar, zuu : xaa } as well? — surfmuggle
– surfmuggle, Commented Jan 12, 2014 at 7:50
@threeFourOneSixOneThree Yes it is always like {foo:bar} but sometimes additionally it gives {foo: bar, koo:kaa} structure — Maxsteel
– Maxsteel, Commented Jan 12, 2014 at 7:51

Brian Rogers · Accepted Answer · 2014-01-12 09:12:48Z

Since you don't know the exact contents of the JSON, but you at least know it is a flat object with key-value pairs, then I would recommend deserializing into a Dictionary<string, string>. You can then easily iterate over the key-value pairs to extract the data you need to store in the DB.

string json = @" { ""origin-of_error"" : ""error_message"", ""foo"" : ""bar"" }"; var dict = JsonConvert.DeserializeObject<Dictionary<string, string>>(json); foreach (KeyValuePair<string, string> kvp in dict) { Console.WriteLine(kvp.Key + ": " + kvp.Value); }

Dibu · Accepted Answer · 2014-01-24 18:31:07Z

try this

IDictionary<string, JToken> jsondata = JObject.Parse(json); foreach (KeyValuePair<string, JToken> innerData in jsondata) { Console.WriteLine("{0}=> {1}",innerData.Key, innerData.Value.ToString()); }

Collectives™ on Stack Overflow

Read and save unknown key value pair in JSON

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related