using System;

using System.Collections;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Diagnostics;

using System.IO;

using System.Threading;

using System.Collections.ObjectModel;

using System.Reflection;

using System.Runtime.Serialization;

using System.Data;

using System.ComponentModel;

using System.Globalization;

using System.Collections.Specialized;

using System.Runtime.InteropServices;

using System.Text.RegularExpressions;

using System.Net;

​

using Newtonsoft.Json;

using Newtonsoft.Json.Linq;

using Newtonsoft.Json.Converters;

using Newtonsoft.Json.Serialization;

​

    // https://stackoverflow.com/questions/43246865/having-issues-parsing-a-json-response-with-separate-columns-and-rows

​

​

    public class RowColumnListConverter<T> : JsonConverter

    {

        const string columnsKey = "columns";

        const string rowsKey = "rows";

​

        public override bool CanConvert(Type objectType)

        {

            if (!typeof(ICollection<T>).IsAssignableFrom(objectType))

                return false;

            // This converter is only implemented for read/write collections.  So no arrays.

            if (objectType.IsArray)

                return false;

            return true;

        }

​

        public override object ReadJson(JsonReader reader, Type objectType, object existingValue, JsonSerializer serializer)

        {

            if (reader.TokenType == JsonToken.Null)

                return null;

            var list = existingValue as ICollection<T> ?? (ICollection<T>)serializer.ContractResolver.ResolveContract(objectType).DefaultCreator();

            var root = JObject.Load(reader);

            var rows = root.GetValue(rowsKey, StringComparison.OrdinalIgnoreCase).NullCast<JArray>();

            if (rows == null)

                return list;

            var columns = root.GetValue(columnsKey, StringComparison.OrdinalIgnoreCase).NullCast<JArray>();

            if (columns == null)

                throw new JsonSerializationException(columnsKey + " not found.");

            var columnNames = columns.Cast<JObject>().SelectMany(o => o.Properties()).Select(p => p.Name).ToArray();

​

            foreach (var row in rows)

            {

                if (row == null || row.Type == JTokenType.Null)

                    list.Add(default(T));

                else if (row.Type == JTokenType.Array)

                {

                    var o = new JObject(columnNames.Zip(row, (c, r) => new JProperty(c, r)));

                    list.Add(o.ToObject<T>(serializer));

                }

                else

                    throw new JsonSerializationException(string.Format("Row was not an array: {0}", row));

            }

​

            return list;

        }

​

        public override bool CanWrite { get { return false; } }

​

        public override void WriteJson(JsonWriter writer, object value, JsonSerializer serializer)

        {

            throw new NotImplementedException();

        }

    }

​

    public static class JsonExtensions

    {

        public static TJTOken NullCast<TJTOken>(this JToken token) where TJTOken : JToken

        {

            if (token == null || token.Type == JTokenType.Null)

                return null;

            var typedToken = token as TJTOken;

            if (typedToken == null)

                throw new JsonSerializationException(string.Format("Token {0} was not of type {1}", token.ToString(Formatting.None), typeof(TJTOken)));

            return typedToken;

        }

    }

​

    public class Record

    {

        public int id { get; set; }

        public string name { get; set; }

        public string description { get; set; }

        public DateTime? last_updated { get; set; }

    }

​

    class TestClass

    {

        public static void Test()

        {

            var json = GetJson();

​

            Console.WriteLine("Input JSON: ");

            Console.WriteLine(json);

​

            var list = JsonConvert.DeserializeObject<List<Record>>(json, new JsonSerializerSettings

                                                                   {

                                                                       Converters = { new RowColumnListConverter<Record>() },

                                                                   });

​

            var json2 = JsonConvert.SerializeObject(list, Formatting.Indented);

​

            Console.WriteLine("Re-serialized list: ");

            Console.WriteLine(json2);

        }

​

        static string GetJson()

        {

            var json = @"{

    ""columns"": [

        { ""id"": { ""type"": ""Numeric"", ""nullable"": false } },

        { ""name"": { ""type"": ""Text"", ""nullable"": false } },

        { ""description"": { ""type"": ""Text"", ""nullable"": true } },

        { ""last_updated"": { ""type"": ""DateTime"", ""nullable"": false } }

    ],

    ""rows"": [

        [1, ""foo"", ""Lorem ipsum"", ""2016-10-26T00:09:14Z""],

        [4, ""bar"", null, ""2013-07-01T13:04:24Z""]

    ]

}";

            return json;

        }

    }

​

    public class Program

    {

        public static void Main()

        {

            Console.WriteLine("Environment version: " + Environment.Version);

            Console.WriteLine("Json.NET version: " + typeof(JsonSerializer).Assembly.FullName);

            Console.WriteLine("");

            TestClass.Test();

        }

    }

​