how to parsing json array data

yashas c

8y961

parsing json array data which dynamically getting from outside and populating into sql server database

string json = @"[{""dish_name"":""Akoori"",""dish_id"":""BID0007"",""dish_quantity"":""2"",""dish_price"":""99.0"",""dish_total_price"":""198.0"",""dish_vegan_type"":""Veg"",""dish_image"":""BreakfastAKOORI.jpg""}]";

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

ruchi chouhan8y ago
your string json is wrong.
0
Dharmraj Thakur8y ago
I think your json string is in wrong format...

It should like this...
static void Main(string[] args)
{
    string json = "[{\"dish_name\": \"Akoori\",\"dish_id\": \"BID0007\",\"dish_quantity\": \"2\",\"dish_price\": \"99.0\",\"dish_total_price\": \"198.0\",\"dish_vegan_type\": \"Veg\",\"dish_image\": \"BreakfastAKOORI.jpg\"}]";
    JToken jsnSerilized = JToken.Parse(json);
    foreach (var item in jsnSerilized)
    {
        Console.WriteLine(item["dish_name"]);
        Console.WriteLine(item["dish_id"]);
        Console.WriteLine(item["dish_quantity"]);
        Console.WriteLine(item["dish_price"]);
    }
    Console.ReadKey();
}
0
Sagar Pandurang Kap8y ago
Hi,
refer below links :-

https://www.srijan.net/blog/how-parse-json-data-rest-api-using-simple-json-library
https://dzone.com/articles/how-to-parse-json-data-from-a-rest-api-using-simpl

Hope it helps....
+1