Will this code convert complex nested JSON into CSV
- public DataTable GetDataTableFromJsonString(string json)
- {
- var jsonLinq = JObject.Parse(json);
-
- var srcArray = jsonLinq.Descendants().Where(d => d is JArray).First();
- var trgArray = new JArray();
- foreach (JObject row in srcArray.Children<JObject>())
- {
- var cleanRow = new JObject();
- foreach (JProperty column in row.Properties())
- {
-
- if (column.Value is JValue)
- {
- cleanRow.Add(column.Name, column.Value);
- }
- }
- trgArray.Add(cleanRow);
- }
- return JsonConvert.DeserializeObject<DataTable>(trgArray.ToString());
- }