using System;

using ChoETL;

using System.Linq;

using System.Collections;

using System.Collections.Generic;

​

public class Program

{

    public static void Main()

    {

        typeof(ChoJSONReader).GetAssemblyVersion().Print();

        "".Print();

        string json = @"{

  ""BrandId"": ""998877665544332211"",

  ""Categories"": [ ""112233445566778899"" ],

  ""Contact"": [{

        ""Value"": ""12346789"",

        ""PostCode"":

        [

        {

        ""Area"":""SA"",

        ""Value"": ""+84""

        },

        {

        ""Area"":""SA"",

        ""Value"": ""+841111""

        }

        ],

        ""Description"": { ""vi"": ""Phone"" },

        ""Type"": 1

      },

      {

        ""Value"": ""987654321"",

        ""PostCode"":

        [

        {

        ""Area"":""SA"",

        ""Value"": ""+8412""

        }

        ],

        ""Description"": { ""vi"": ""Phone"" },

        ""Type"": 1

    }]

}";

        using (var r = ChoJSONReader.LoadText(json)

               .Configure(c => c.DefaultArrayHandling = true)

               .Configure(c => c.FlattenNode = true)

               .Configure(c => c.FlattenByJsonPath = "$.Contact[*]")

               .Configure(c => c.NestedKeySeparator = '~')

               .Configure(c => c.NestedColumnSeparator = '.')

              )

        {

            var dt = r.AsDataTable();

            Console.WriteLine("Using FlattenByJsonPath is fine, but cannot get root information (BrandId) ");

            dt.DumpAsJson().Print();

        }

        using (var r = ChoJSONReader.LoadText(json)

               .Configure(c => c.DefaultArrayHandling = true)

               .Configure(c => c.FlattenNode = true)

               .Configure(c => c.FlattenByNodeName = "Contact")

               .Configure(c => c.NestedKeySeparator = '~')

               .Configure(c => c.NestedColumnSeparator = '.')

              )

        {

            var dt = r.AsDataTable();

            Console.WriteLine("Using FlattenByNodeName neither gets root information (BrandId) nor middle information");

            dt.DumpAsJson().Print();

        }

    }

}