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.LoadText(json)

            .WithField("created", jsonPath: "$..system.created", isArray: false)

            .WithField("by", jsonPath: "$..system.by", isArray: false)

            .WithField("id", jsonPath: "$..location.id", isArray: false)

            .WithField("country", jsonPath: "$..location.country", isArray: false)

            .WithField("OrderID")

            .WithField("OrderName")

            .WithField("Size")

            .WithField("ProductName")

            .WithField("ProductId")

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

            .JsonSerializationSettings(s => s.DateParseHandling = DateParseHandling.None)

            )

        {

            using (var w = new ChoCSVWriter(csv)

                .WithDelimiter(";")

                .WithFirstLineHeader())

            {

                w.Write(r);

            }

        }

        Console.WriteLine(csv.ToString());

    }

​

}

​

​