时间戳

首页 > 解决方案 > 如何将 ChoETL Json 映射到 CSV 复杂类型

c# - 如何将 ChoETL Json 映射到 CSV 复杂类型

问题描述

我有以下类结构

public class ResultData
{
    [JsonProperty(PropertyName = "Id")]
    public string Id { get; set; }

    [JsonProperty(PropertyName = "Results")]
    public IEnumerable<Result> Results{ get; set; }
}

public class Result
{
    public string Name { get; set; }

    public string Value { get; set; }
}

这是我转换为 csv 的代码

private static void ToCsv(ResultData data)
{
    StringBuilder csv = new StringBuilder();
    var json = JsonConvert.SerializeObject(data);

    var config = new ChoJSONRecordConfiguration {AllowComplexJSONPath = true};

    config.JSONRecordFieldConfigurations.Add(new ChoJSONRecordFieldConfiguration("Id"));
    config.JSONRecordFieldConfigurations.Add(new ChoJSONRecordFieldConfiguration("Results", "Name") { FieldType = typeof(string[]) });
    config.JSONRecordFieldConfigurations.Add(new ChoJSONRecordFieldConfiguration("Results", "Value") { FieldType = typeof(string[]) });

    using (var r = ChoJSONReader.LoadText(json, config))
    {
        using var w = new ChoCSVWriter(csv).WithFirstLineHeader().UseNestedKeyFormat(false);
        w.Write(r);
    }

    File.WriteAllText("2.csv", csv.ToString());
}

json

{"Id":"839c0a09-f2d0-4f29-9cce-bc022d3511b5","Results":[{"Name":"ABC","Value":"5"},{"Name":"CDE","Value":"2"}]}

我想要的是一个 CSV 文件，其中 Id 和结果名称在一列中，结果值在另一列中

标签： c#jsoncsvchoetl

解决方案

这是从 JSON 生成 CSV 输出的方法

string json = @"{
  ""Id"": ""839c0a09-f2d0-4f29-9cce-bc022d3511b5"",
  ""Results"": [
    {
      ""Name"": ""ABC"",
      ""Value"": ""5""
    },
    {
      ""Name"": ""CDE"",
      ""Value"": ""2""
    }
  ]
}";

StringBuilder csv = new StringBuilder();
using (var r = ChoJSONReader<ResultData>.LoadText(json)
    .UseJsonSerialization()
    )
{
    using (var w = new ChoCSVWriter(csv)
        .WithFirstLineHeader()
        .Configure(c => c.IgnoreDictionaryFieldPrefix = true)
        )
    {
        w.Write(r.Select(r1 => new
        {
            r1.Id,
            Results = r1.Results.ToDictionary(kvp => kvp.Name, kvp => kvp.Value)
        }));
    }
}

Console.WriteLine(csv.ToString());

输出：

Id,ABC,CDE
839c0a09-f2d0-4f29-9cce-bc022d3511b5,5,2

更新：

private static void ToCsv(ResultData data)
{
    using (var w = new ChoCSVWriter("2.csv")
        .WithFirstLineHeader()
        .Configure(c => c.IgnoreDictionaryFieldPrefix = true)
        )
        w.Write(data.ConvertToEnumerable().Select(r1 => new
        {
            r1.Id,
            Results = r1.Results.ToDictionary(kvp => kvp.Name, kvp => kvp.Value)
        }));
}

推荐阅读