Convert dynamic csv to json containing List<string> C#

Question

I want to serialize a list of strings in C#? I have previously successfully used an open-source library Cinchoo ETL for similar tasks, but I am stuck in this particular scenario. I do not want to use POCO since my source data structure is dynamic. I would much rather read the data from a csv and serialize it.

My source data in csv format:

id,name,friends/0,friends/1
1,Tom,Dick,Harry

Required output JSON - {"id":1,"name":"Tom","friends":["Dick","Harry"]}

The title and the content of the question confuse me. Do you want convert CSV to JSON or JSON to CSV? — Pac0
– Pac0, Commented May 10, 2020 at 19:18
@Pac0 - I want to convert csv to json. However, since my source data structure is dynamic I will not use POCO. My eventual json format is what I have mentioned in the question. I am trying to understand if there are any opensource libraries so that I don't have to reinvent the wheel — sonofpaul
– sonofpaul, Commented May 10, 2020 at 19:33
@Jabberwocky - slightly different requirement here - I just want a list of strings in the array - no attribute names required within the array. — sonofpaul
– sonofpaul, Commented May 10, 2020 at 19:34

Cinchoo · Accepted Answer · 2020-05-10 22:42:30Z

2

Here you go, you can do with Cinchoo ETL as below

string csv = @"id,name,friends/0,friends/1
1,Tom,Dick,Harry";

StringBuilder json = new StringBuilder();
using (var w = new ChoJSONWriter(json)
    .Configure(c => c.SupportMultipleContent = true)
    .Configure(c => c.SingleElement = true)
    )
{
    using (var r = ChoCSVReader.LoadText(csv).WithFirstLineHeader()
        .Configure(c => c.AutoArrayDiscovery = true)
        .Configure(c => c.ArrayIndexSeparator = '/')
        )
        w.Write(r);
}
Console.WriteLine(json.ToString());

Output:

{
 "id": "1",
 "name": "Tom",
 "friends": [
  "Dick",
  "Harry"
 ]
}

answered May 10, 2020 at 22:42

Cinchoo

6,3562 gold badges21 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Convert dynamic csv to json containing List<string> C#

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related