read specific data from json array

Question

I've json table like this, how I can attempd to specific data?

var json_str={ "table1":[
{"name1":"data1"},
{"name2":"data2"},
{"name3":"data3"}
],
"table2":[
{"name1":"data1"},
{"name2":"data2"},
{"name3":"data3"}
]
}   
dynamic stuff = JsonConvert.DeserializeObject(json_string); 

//I'd like attempt to data like this(for example)

var abc=stuff.table1["name1"];

this is obviously wrong, but is there any method to call the contents of the json table by name?

SOLVED: I changed my json to

var json_str={ "table1":{
"name1":"data1",
"name2":"data2",
"name3":"data3"
},
"table2":{
"name1":"data1",
"name2":"data2",
"name3":"data3"
}
} 

var abc=JsonConvert.DeserializeObject<Form1.RootObject>(json_str);  

and now I have attempt (for example) by: abc.table1.name2;

Many thanks to xdtTransform and everyone for the hints.

Answer 1

Just use dot notation.

Working example:

using System;
using System.Collections.Generic;
using Newtonsoft.Json;

public class Program
{
    public static void Main()
    {
        var json_str = "{ \"table1\":[{\"name1\":\"data1\"},{\"name2\":\"data2\"},{\"name3\":\"data3\"}],\"table2\":[{\"name1\":\"data1\"},{\"name2\":\"data2\"},{\"name3\":\"data3\"}]}";
        dynamic stuff = JsonConvert.DeserializeObject(json_str);

        Console.WriteLine(stuff.table2[0].name1); // prints "data1"

    }
}

Alternative:

stuff["table2"][0]["name1"]

Why yours is not working:

var abc=stuff.table1["name1"];

You cannot access "name1" directly, because it is inside an array of objects. Take the first element with [0] and after that you can access name1.

Answer 2

Why don't deserialize your Json to a strongly typed objects as the following sample

 class Program
    {
        static void Main(string[] args)
        {
            var json_str = "{ table1:[{name:'data1'}," +
                "{name:'data2'},{name:'data3'}]," +
                "table2:[{name:'data1'},{name:'data2'},{name:'data3'}]}";

            var collection = JsonConvert.DeserializeObject<TableCollectionObject>(json_str);

            foreach (var item in collection.table1)
            {
                Console.WriteLine(item.name);
            }

            foreach (var item in collection.table2)
            {
                Console.WriteLine(item.name);
            }

            Console.ReadLine();

        }
    }

    class TableCollectionObject
    {
        public ICollection<SingleTableObject> table1 { get; set; }
        public ICollection<SingleTableObject> table2 { get; set; }
    }

    class SingleTableObject
    {
        public string name { get; set; }
    }

Note that I've changed your Json to become a valid json object that can be parsed by Newtonsoft.Json library.

Answer 3

A. JObject.Parse

JObject o = JObject.Parse(json);

var name = o["table1"][0]["name1"].Value<string>();// data1
var name2 = o["table2"][2]["name3"].Value<string>();// data3

B. Dicstionary,List,Dictionary

var d = System.Text.Json.JsonSerializer.Deserialize<Dictionary<string,List<Dictionary<string,string>>>>(json);

var nameB = d["table1"][0]["name1"]; // data1
var nameB2 = d["table2"][2]["name3"]; // data3

---

This is the test data I used.

var json = @"{ ""table1"":[
{""name1"":""data1""},
{""name2"":""data2""},
{""name3"":""data3""}
],
""table2"":[
{""name1"":""data1""},
{""name2"":""data2""},
{""name3"":""data3""}
]
}";

It is an usual data structure because the 1st item in the arrays has one property called name1 and the 2nd item has a single property called name2.

A more common schema is something like the following.

{
    "table1": [
        {
            "name1": "data1", "name2": "data2", "name3": "data3",
        },
        {
            "name1": "data1", "name2": "data2", "name3": "data3"
        }
    ]
}