using System;

using System.Data;

using System.Linq;

using System.Text.RegularExpressions;

using Newtonsoft.Json.Linq;

​

public class Program

{

    public static void Main()

    {

        var dt = Tabulate(GetJson());

​

        foreach (DataRow row in dt.Rows)

        {

            foreach (DataColumn col in dt.Columns)

            {

                Console.WriteLine(col.ColumnName + ": " + row[col]);

            }

            Console.WriteLine(new string('-', 30));

        }

    }

​

    public static DataTable Tabulate(string jsonContent)

    {

        var jsonLinq = JObject.Parse(jsonContent);

​

        // Find the first array using Linq

        var arrayProp = jsonLinq.Properties().First(p => p.Value is JArray);

        var srcArray = (JArray)arrayProp.Value;

        // Set up a regex consisting of the array property name and subscript (e.g. "projects[0]."),

        // which we will strip off property paths

        var regex = new Regex($@"^{arrayProp.Name}\[\d+\]\.");

​

        // Flatten each object of the original array into new objects and put them in a new array 

        var trgArray = new JArray(

            srcArray.Children<JObject>()

                    .Select(row => new JObject(

                        row.Descendants()

                           .OfType<JProperty>()

                           .Where(p => p.Value is JValue)

                           .Select(p => new JProperty(

                                regex.Replace(p.Value.Path, "").Replace(".", "_"), 

                                p.Value

                           ))

                    ))

            );

​

        // Convert the new array to a DataTable

        DataTable dt = trgArray.ToObject<DataTable>();

​

        return dt;

    }

​

    private static string GetJson()

    {

        return @"

            {

              ""STATUS"": ""OK"",

              ""projects"": [

                {

                  ""startDate"": """",

                  ""last-changed-on"": ""2019-01-03T11:46:14Z"",

                  ""logo"": """",

                  ""created-on"": ""2018-12-12T10:04:47Z"",

                  ""privacyEnabled"": false,

                  ""status"": ""active"",

                  ""boardData"": {},

                  ""replyByEmailEnabled"": true,

                  ""harvest-timers-enabled"": false,

                  ""description"": """",

                  ""category"": {

                    ""color"": """",

                    ""id"": """",

                    ""name"": """"

                  },

                  ""id"": ""322852"",

                  ""overview-start-page"": ""default"",

                  ""start-page"": ""projectoverview"",

                  ""integrations"": {

                    ""xero"": {

                      ""basecurrency"": """",

                      ""countrycode"": """",

                      ""enabled"": false,

                      ""connected"": ""NO"",

                      ""organisation"": """"

                    },

                    ""sharepoint"": {

                      ""account"": """",

                      ""foldername"": ""root"",

                      ""enabled"": false,

                      ""folder"": ""root""

                    },

                    ""microsoftConnectors"": {

                      ""enabled"": false

                    },

                    ""onedrivebusiness"": {

                      ""account"": """",

                      ""foldername"": ""root"",

                      ""enabled"": false,

                      ""folder"": ""root""

                    }

                  },

                  ""defaults"": {

                    ""privacy"": """"

                  },

                  ""notifyeveryone"": false,

                  ""filesAutoNewVersion"": false,

                  ""defaultPrivacy"": ""open"",

                  ""tasks-start-page"": ""default"",

                  ""starred"": false,

                  ""announcementHTML"": """",

                  ""isProjectAdmin"": true,

                  ""name"": ""Project 2"",

                  ""company"": {

                    ""is-owner"": ""1"",

                    ""id"": ""78494"",

                    ""name"": ""MCG Company""

                  },

                  ""endDate"": """",

                  ""announcement"": """",

                  ""show-announcement"": false,

                  ""subStatus"": ""current"",

                  ""tags"": [

                       {

                    ""type"": ""arlington"",

                  ""type2"": {""tt"":""arlington2""},

                   ""policyFile"": [

                  ""file_110620221120.jpg""

                          ],

                    ""policyExpirationDate"": """"

                }

                 ]

                },

                {

                  ""startDate"": """",

                  ""last-changed-on"": ""2018-12-11T17:52:57Z"",

                  ""logo"": """",

                  ""created-on"": ""2018-11-26T11:11:00Z"",

                  ""privacyEnabled"": false,

                  ""status"": ""active"",

                  ""boardData"": {},

                  ""replyByEmailEnabled"": true,

                  ""harvest-timers-enabled"": false,

                  ""description"": """",

                  ""category"": {

                    ""color"": """",

                    ""id"": """",

                    ""name"": """"

                  },

                  ""id"": ""321041"",

                  ""overview-start-page"": ""default"",

                  ""start-page"": ""projectoverview"",

                  ""integrations"": {

                    ""xero"": {

                      ""basecurrency"": """",

                      ""countrycode"": """",

                      ""enabled"": false,

                      ""connected"": ""NO"",

                      ""organisation"": """"

                    },

                    ""sharepoint"": {

                      ""account"": """",

                      ""foldername"": ""root"",

                      ""enabled"": false,

                      ""folder"": ""root""

                    },

                    ""microsoftConnectors"": {

                      ""enabled"": false

                    },

                    ""onedrivebusiness"": {

                      ""account"": """",

                      ""foldername"": ""root"",

                      ""enabled"": false,

                      ""folder"": ""root""

                    }

                  },

                  ""defaults"": {

                    ""privacy"": """"

                  },

                  ""notifyeveryone"": false,

                  ""filesAutoNewVersion"": false,

                  ""defaultPrivacy"": ""open"",

                  ""tasks-start-page"": ""default"",

                  ""starred"": false,

                  ""announcementHTML"": """",

                  ""isProjectAdmin"": true,

                  ""name"": ""Project One"",

                  ""company"": {

                    ""is-owner"": ""1"",

                    ""id"": ""78494"",

                    ""name"": ""MCG Company""

                  },

                  ""endDate"": """",

                  ""announcement"": """",

                  ""show-announcement"": false,

                  ""subStatus"": ""current"",

                  ""tags"": []

                }

              ]

            }";

    }

}