Construct dynamic DataTable from json using C#

This is the code i used to create the table you are looking for. I created a ToList() method within Results to get the data you need to add to the table as rows.

    string jdata = File.ReadAllText(@"C:\Temp\json.txt");

    Response response = JsonConvert.DeserializeObject<Response>(jdata);
    response.Results.ForEach(x => x.ToList().ForEach(owner => dataTable.Rows.Add(owner.ToArray())));

    dataTable
        .Rows
        .Cast<DataRow>().ToList()
        .ForEach(x =>
        {
            dataTable.Columns.Cast<DataColumn>().ToList()
                .ForEach(y => Console.Write($"{x[y].ToString()}\t")); Console.WriteLine();
        });

And these are the classes i used. Class attributes should start with Capital letter and to conform to the standards, I used JsonProperty.

    public class Response
    {
        public int Count { get; set; }
        public string Message { get; set; }
        public string SearchCriteria { get; set; }
        public List<Result> Results { get; set; }
    }

    public class Result
    {
        public List<List<string>> ToList()
        {
            List<List<string>> response = new List<List<string>>();
            Owners.ForEach(x => response.Add(new List<string>() { MakeId, ModelId, x.Name, string.Join(",", x.Addresses.Select(address => address.City)) }));
            return response;
        }

        [JsonProperty("Make_ID")]
        public string MakeId { get; set; }
        [JsonProperty("Model_ID")]
        public string ModelId { get; set; }
        [JsonProperty("Make_Name")]
        public string MakeName { get; set; }
        [JsonProperty("Model_Name")]
        public string ModelName { get; set; }
        [JsonProperty("owners")]
        public List<Owner> Owners { get; set; }

    }

    public class Owner
    {
        [JsonProperty("name")]
        public string Name { get; set; }
        [JsonProperty("address")]
        public List<Address> Addresses { get; set; }
    }

    public class Address
    {
        [JsonProperty("city")]
        public string City { get; set; }
        [JsonProperty("pincode")]
        public string PinCode { get; set; }
    }

Output

474     1861    Balaji  kcp
474     1861    Rajesh  chennai
475     1862    Vijay   madurai
475     1862    Andrej  Berlin

Advantages

1. Short and concise.. Based on classes you are defining so always will have the data in the correct place.
2. You dont need the Paths any more... works without the XML.
3. Easy to update the data returned from the Result.ToList()

I don't know you still looking for better solution. Here is a solution using Cinchoo ETL, an open source library.

You may need to revisit your configuration parameters to suit the needs.

But the sample below shows the way to get the job done

using (var r = new ChoJSONReader("*** YOUR JSON FILE ***")
    .WithJSONPath("$..Results[*]")
    )
{
    var r1 = r.FlattenBy("owners", "address");
    var dt = r1.AsDataTable(selectedFields: new string[] { "Make_ID", "Model_ID", "name", "city" });
    Console.WriteLine(dt.DumpAsJson());
}

Output:

Hope it helps.

From my understanding it looks like you need a solution where the Columns are dynamic and depended on the configuration Xml.

You could do the following (comments inline)

var regex = new Regex(Regex.Escape("*"));
var jo = JObject.Parse(response);

var count = jo.SelectTokens("Results[*].Make_ID").Count();
// Parse the Json to form collections of KeyValuePairs
var dataCollection = Enumerable.Range(0,count)
                               .Select(x=>config.Property
                               .Select(prop=>new KeyValuePair<string,List<string>> 
                               (
                                prop.Name,
                                jo.SelectTokens(regex.Replace(prop.Path, x.ToString(), 1)).Select(c=>c.Value<string>()).ToList())));

// Flatten the collection and Create DataRows
foreach(var data in dataCollection)
{
    for(var i=0;i<data.Select(x=>x.Value).Max(x=>x.Count);i++)
    {
        var innerList = new List<object>();
        foreach(var prop in config.Property)
        {
            var currentData = data.Where(x=>x.Key == prop.Name).SelectMany(x=>x.Value).ToList();

            innerList.Add(i>=currentData.Count ? currentData.Last():currentData[i]);
        }

        dataTable.Rows.Add(innerList.ToArray());
    }
}

Working Demo

Output