using System;

using ChoETL;

​

public class Program

{

    public static void Main()

    {

        //ChoETLSettings.KeySeparator = '!';

        using (var r = ChoJSONReader.LoadText(json)

               .WithJSONPath("Data")

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

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

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

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

​

              )

        {

            using (var w = new ChoCSVWriter(Console.Out)

                   .WithFirstLineHeader()

                   .IgnoreField("ExtraData")

                  )

            {

                w.Write(r);

            }

​

        }

    }

    static string json = @"{

  ""Data"": [

    {

      ""Ref"": ""h123"",

      ""StartDate"": ""2023-01-01"",

      ""EndDate"": ""2024-01-01"",

      ""Person"": {

        ""Name"": ""Tester"",

        ""Email"": ""test@test.com"",

        ""PhoneNumber"": null,

        ""AddressLine1"": ""1 avenue"",

        ""AddressLine2"": null,

        ""AddressLine3"": null,

        ""AddressLine4"": null,

        ""AddressLine5"": null,

        ""Zipcode"": ""100123""

      },

      ""ExtraData"": null,

      ""ExtraData1"": {

        ""X"": ""x"",

        ""Y"": ""y"",

        ""Z"": ""z""

      }

    },

    {

      ""Ref"": ""h1234"",

      ""StartDate"": ""2023-01-01"",

      ""EndDate"": ""2024-01-01"",

      ""Person"": {

        ""Name"": ""Tester1"",

        ""Email"": ""test@test.com"",

        ""PhoneNumber"": null,

        ""AddressLine1"": ""2 avenue"",

        ""AddressLine2"": null,

        ""AddressLine3"": null,

        ""AddressLine4"": null,

        ""AddressLine5"": null,

        ""Zipcode"": ""100124""

      },

      ""ExtraData"": null,

      ""ExtraData1"": {

        ""X"": ""x"",

        ""Y"": ""y"",

        ""Z"": ""z""

      }

    }

  ]

}";

}