using System;

using ChoETL;

using System.Linq;

using System.Collections;

​

public class Program

{

    public static void Main()

    {

        typeof(ChoCSVReader).GetAssemblyVersion().Print();

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

        "".Print();

        using (var r = ChoJSONReader.LoadText(json)

               //.WithJSONPath($"$..entry")

              )

        {

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

                   .WithMaxScanRows(10)

                   .WithFirstLineHeader()

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

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

                  )

            {

                var r1 = r

                    .Select(rec =>

                            {

                                foreach (dynamic entry in rec.entry)

                                {

                                    foreach (dynamic item in entry.resource.testtension)

                                    {

                                        if (item.value is IList)

                                        {

​

                                        }

                                        else

                                            item.value = new string[] { item.value };

                                    }

                                }

                                return rec;

                            })

                    .FlattenBy(new string[] { "entry", "resource", "testtension" }).ToArray();

​

                w.Write(r1);

            }

        }       

    }

    static string json = @"{

  ""Name"": ""Test"",

  ""type"": ""Test"",

  ""entry"": [

    {

      ""testUrl"": ""https://"",

      ""resource"": {

        ""resourceType"": ""test"",

        ""managingtest"": {

          ""test"": ""test/1807""

        },

        ""name"": [

          {

            ""firstname"": ""john"",

            ""lastname"": ""smith"",

            ""given"": [

              ""Robet""

            ]

          }

        ],

        ""gender"": ""male"",

        ""birthDate"": ""1925-01-01"",

        ""testtension"": [

          {

            ""url"": ""www.com"",

            ""value"": [

              ""test1"",

              ""test2"",

              ""test3""

            ]

          },

          {

            ""url"": ""www.1.com"",

            ""value"": ""test20""

          },

          {

            ""url"": ""www.2.com"",

            ""value"": ""test30""

​

          },

          {

            ""url"": ""www.3.com"",

            ""value"": ""test40""

          }

        ],

        ""sata"": {

          ""YearUpdated"": ""2024""

        }

      }

    },

    {

      ""testUrl"": ""https://"",

      ""resource"": {

        ""resourceType"": ""test"",

        ""managingtest"": {

          ""test"": ""test/1808""

        },

        ""name"": [

          {

            ""firstname"": ""hello"",

            ""lastname"": ""smith"",

            ""given"": [

              ""test""

            ]

          }

        ],

        ""gender"": ""male"",

        ""birthDate"": ""1925-01-01"",

        ""testtension"": [

​

          {

            ""url"": ""www.1.com"",

            ""value"": ""test20""

          },

          {

            ""url"": ""www.2.com"",

            ""value"": ""test30""

          },

          {

            ""url"": ""www.com"",

            ""value"": [

              ""test1"",

              ""test2"",

              ""test3""

            ]

          },

          {

​

            ""url"": ""www.3.com"",

            ""value"": ""test40""

          }

        ],

        ""sata"": {

          ""YearUpdated"": ""2024""

        }

      }

    },

    {

      ""testUrl"": ""https://"",

      ""resource"": {

        ""resourceType"": ""test"",

        ""managingtest"": {

          ""test"": ""test/1809""

        },

        ""name"": [

          {

            ""firstname"": ""john"",

            ""lastname"": ""smith"",

            ""given"": [

              ""Robet""

            ]

          }

        ],

        ""gender"": ""male"",

        ""birthDate"": ""1925-01-01"",

        ""testtension"": [

          {

            ""url"": ""www.com"",

            ""value"": [

              ""test1"",

              ""test2"",

              ""test3""

            ]

          },

          {

            ""url"": ""www.1.com"",

            ""value"": ""test20""

          },

          {

            ""url"": ""www.2.com"",

            ""value"": ""test30""

          },

          {

            ""url"": ""www.3.com"",

            ""value"": ""test40""

          }

        ],

        ""sata"": {

          ""YearUpdated"": ""2024""

        }

      }

    },

    {

      ""testUrl"": ""https://"",

      ""resource"": {

        ""resourceType"": ""test"",

        ""managingtest"": {

          ""test"": ""test/1810""

        },

        ""name"": [

          {

            ""firstname"": ""hello"",

            ""lastname"": ""smith"",

            ""given"": [

              ""test""

            ]

          }

        ],

        ""gender"": ""male"",

        ""birthDate"": ""1925-01-01"",

        ""testtension"": [

​

          {

            ""url"": ""www.1.com"",

            ""value"": ""test20""

          },

          {

            ""url"": ""www.2.com"",

            ""value"": ""test30""

          },

          {

            ""url"": ""www.com"",

            ""value"": [

              ""test1"",

              ""test2"",

              ""test3""

            ]

          },

          {

​

            ""url"": ""www.3.com"",

            ""value"": ""test40""

          }

        ],

        ""sata"": {

          ""YearUpdated"": ""2024""

        }

      }

    }

  ]

}

";  

}