using System;

using System.Text;

using ChoETL;

using Newtonsoft.Json;

using System.Collections.Generic;

using System.Linq;

​

public class Program

{

    public static void Main()

    {

        string json = @"

{

  ""system"": {

    ""created"": ""2021-08-01T13:33:37.123Z"",

    ""by"": ""web""

  },

  ""location"": {

    ""id"": 100,

    ""country"": ""DE""

  },

  ""order"": [

    {

      ""OrderID"": 22,

      ""OrderName"": ""Soda"",

      ""OrderArticles"": [

        {

          ""Size"": 33,

          ""ProductName"": ""Coke"",

          ""ProductId"": ""999""

        },

        {

          ""Size"": 66,

          ""ProductName"": ""Fanta"",

          ""ProductId"": ""888""

        },

        {

          ""Size"": 50,

          ""ProductName"": ""Pepsi"",

          ""ProductId"": ""444""

        }

      ],

      ""ProcessedId"": 1001,

      ""Date"": ""2021-08-02""

    },

    {

      ""OrderID"": 23,

      ""OrderName"": ""Beverage"",

      ""OrderArticles"": [

        {

          ""Size"": 44,

          ""ProductName"": ""Coke"",

          ""ProductId"": ""999""

        }

      ],

      ""ProcessedId"": 1002,

      ""Date"": ""2021-08-03""

    }

  ]

}";

        StringBuilder csv = new StringBuilder();

        using (var r = ChoJSONReader<OrderRoot>.LoadText(json)

               .UseJsonSerialization()

              )

        {

            using (var w = new ChoCSVWriter(csv)

                   .WithDelimiter(";")

                   .WithFirstLineHeader())

            {

                w.Write(r.SelectMany(root =>

                                     root.Orders

                                     .SelectMany(order => order.OrderArticles

                                                 .Select(orderarticle => new

                                                         {

                                                             created = root.System.Created,

                                                             by = root.System.By,

                                                             id = root.Location.Id,

                                                             order.OrderID,

                                                             order.OrderName,

                                                             orderarticle.Size,

                                                             orderarticle.ProductName,

                                                             orderarticle.ProductId,

                                                         })

                                                )

                                    )

                       );

            }

        }

        Console.WriteLine(csv.ToString());

    }

​

    public class System

    {

        [JsonProperty("created")]

        public string Created { get; set; }

​

        [JsonProperty("by")]

        public string By { get; set; }

    }

​

    public class Location

    {

        [JsonProperty("id")]

        public int Id { get; set; }

​

        [JsonProperty("country")]

        public string Country { get; set; }

    }

​

    public class OrderArticle

    {

        [JsonProperty("Size")]

        public int Size { get; set; }

​

        [JsonProperty("ProductName")]

        public string ProductName { get; set; }

​

        [JsonProperty("ProductId")]

        public string ProductId { get; set; }

    }

​

    public class Order

    {

        [JsonProperty("OrderID")]

        public int OrderID { get; set; }

​

        [JsonProperty("OrderName")]

        public string OrderName { get; set; }

​

        [JsonProperty("OrderArticles")]

        public List<OrderArticle> OrderArticles { get; set; }

​

        [JsonProperty("ProcessedId")]

        public int ProcessedId { get; set; }

​

        [JsonProperty("Date")]

        public string Date { get; set; }

    }

​

    public class OrderRoot

    {

        [JsonProperty("system")]

        public System System { get; set; }

​

        [JsonProperty("location")]

        public Location Location { get; set; }

​

        [JsonProperty("order")]

        public List<Order> Orders { get; set; }

    }

}

​

​