using System;

using System.Collections.Generic;

using System.IO;

using System.Linq;

using System.Text;

using Newtonsoft.Json;

using Newtonsoft.Json.Linq;

public class Program

{

    public static void Main()

    {

        string json = @"

            {

""Columns"": [

        ""Sample Status"",

        ""Report Status"",

        ""Date Reported"",

        ""Asset ID"",

        ""Unit ID"",

        ""Unit Description"",

        ""Asset Class"",

        ""Position"",

        ""Tested Lubricant"",

        ""Service Level"",

        ""Sample Bottle ID"",

        ""Manufacturer"",

        ""Comments""

    ],

    ""Results"": [

        [

            ""Completed"",

            ""Normal"",

            ""12/29/2020 1:18:40 AM"",

            ""50261163"",

            ""GMVG - 10 Unit #1"",

            ""Americus - Unit #1"",

            ""Engine - Natural Gas"",

            null,

            ""MOBIL PEGASUS SPECIAL CF"",

            ""Enhanced"",

            ""b051531837"",

            ""COOPER-BESSEMER"",

             ""-NO ACTION REQUIRED ON OIL OR ENGINE.  Results indicate that all levels are within acceptable ranges.  Examine progressive changes and monitor results for changing trends.  Sample at next scheduled interval.  Contact your ExxonMobil representative for further assistance if necessary.""

        ],

        [

            ""Completed"",

            ""Normal"",

            ""12/29/2020 1:18:40 AM"",

            ""50261169"",

            ""GVMG 10 Unit#2"",

            ""Americus - Unit #2"",

            ""Engine - Natural Gas"",

            null,

            ""MOBIL PEGASUS SPECIAL CF"",

            ""Enhanced"",

            ""b038156247"",

            ""COOPER-BESSEMER"",

            ""-NO ACTION REQUIRED ON OIL OR ENGINE.  Results indicate that all levels are within acceptable ranges.  Examine progressive changes and monitor results for changing trends.  Sample at next scheduled interval.  Contact your ExxonMobil representative for further assistance if necessary.""

        ],

        [

            ""Completed"",

            ""Normal"",

            ""12/29/2020 1:18:40 AM"",

            ""50261174"",

            ""GMVG - 10 Unit #3"",

            ""Americus - Unit #3"",

            ""Engine - Natural Gas"",

            null,

            ""MOBIL PEGASUS SPECIAL CF"",

            ""Enhanced"",

            ""b039103413"",

            ""COOPER-BESSEMER"",

            ""-NO ACTION REQUIRED ON OIL OR ENGINE.  Results indicate that all levels are within acceptable ranges.  Examine progressive changes and monitor results for changing trends.  Sample at next scheduled interval.  Contact your ExxonMobil representative for further assistance if necessary.""

        ],

        [

            ""Completed"",

            ""Normal"",

            ""12/29/2020 1:18:40 AM"",

            ""50261177"",

            ""GMVG -10  Unit #4"",

            ""Amreicus - Unit #4"",

            ""Engine - Natural Gas"",

            null,

            ""MOBIL PEGASUS SPECIAL CF"",

            ""Enhanced"",

            ""b051529162"",

            ""COOPER-BESSEMER"",

            ""-NO ACTION REQUIRED ON OIL OR ENGINE.  Results indicate that all levels are within acceptable ranges.  Examine progressive changes and monitor results for changing trends.  Sample at next scheduled interval.  Contact your ExxonMobil representative for further assistance if necessary.""

        ],

        [

            ""Completed"",

            ""Alert"",

            ""12/29/2020 9:58:03 PM"",

            ""50265209"",

            ""St. Francis Hydraulic"",

            ""St. Francis Hydraulic"",

            ""Engine - Natural Gas"",

            null,

            ""MOBIL PEGASUS SPECIAL CF"",

            ""Enhanced"",

            ""b021451319"",

            ""NOT LISTED"",

            ""-ACTION REQUIRED - UNACCEPTABLE VISCOSITY.  The viscosity of the sampled oil has either increased or decreased by more than 20 percent since its initial installment as a new oil.  The oil is unfit for continued use and must be changed immediately in order to comply with EPA RICE-NESHAP oil analysis standards.  Contact your ExxonMobil representative for further assistance if necessary.""

        ],

        [

            ""Completed"",

            ""Alert"",

            ""12/29/2020 2:39:49 AM"",

            ""50265133"",

            ""Americus Hydraulic"",

            ""Americus Hydraulic"",

            ""Engine - Natural Gas"",

            null,

            ""MOBIL PEGASUS SPECIAL CF"",

            ""Enhanced"",

            ""b038155109"",

            ""NOT LISTED"",

            ""-ACTION REQUIRED - REDUCED OIL VISCOSITY.  Determine cause of reduced oil viscosity and take corrective action.  Reduced viscosities can impair the lubricant's ability to protect the equipment.  Possible causes of reduced viscosity include:  a.  Initial fill or contact with oil that has a lower viscosity;  b.  Contamination with a fuel or solvent;  c.  Incorrectly labeled sampled.  Inspect the system for signs of fuel or coolant ingression.  Resample the oil after corrective actions have been implemented.  If the condition continues or escalates, recharge the system with new oil.  Contact your ExxonMobil representative for further assistance if necessary. -ACTION REQUIRED - UNSATISFACTORY OIL CONDITION.  Test results indicate that the condition of this oil sample is unsatisfactory.  The oil may be unfit for continued use and should be closely monitored further condition regressions.  Contact your ExxonMobil representative for further assistance if necessary.""

        ],

        [

            ""Completed"",

            ""Normal"",

            ""12/29/2020 1:18:40 AM"",

            ""50261178"",

            ""Bulk Storage"",

            ""Americus - Bulk Storage Tank"",

            ""Engine - Natural Gas"",

            null,

            ""MOBIL PEGASUS SPECIAL CF"",

            ""Enhanced"",

            ""b051506293"",

            ""NOT LISTED"",

            ""-NO ACTION REQUIRED ON OIL OR ENGINE.  Results indicate that all levels are within acceptable ranges.  Examine progressive changes and monitor results for changing trends.  Sample at next scheduled interval.  Contact your ExxonMobil representative for further assistance if necessary.""

        ]

    ]

            }";

        // using a MemoryStream here to simulate a response stream from a web request

        MemoryStream responseStream = new MemoryStream(Encoding.UTF8.GetBytes(json));

        var results = GetResultsFromResponseStream(responseStream);

        foreach (var item in results)

        {

            foreach (var kvp in item)

            {

                Console.WriteLine(kvp.Key + ": " + kvp.Value);

            }

            Console.WriteLine();

        }

    }

    static List<Dictionary<string, string>> GetResultsFromResponseStream(Stream responseStream)

    {

        using (StreamReader streamReader = new StreamReader(responseStream))

        using (JsonReader jsonReader = new JsonTextReader(streamReader))

        {

            JObject obj = JObject.Load(jsonReader);

            JArray keys = (JArray)obj["Columns"];

            List<Dictionary<string, string>> results = obj["Results"]

                .Children<JArray>()

                .Select(a => keys.Zip(a, (k, v) => new { Key = (string)k, Value = (string)v })

                                 .ToDictionary(kvp => kvp.Key, kvp => kvp.Value))

                .ToList();

            return results;

        }

    }

}