Will this code convert complex nested JSON into CSV
- public DataTable GetDataTableFromJsonString(string json)
- {
- var jsonLinq = JObject.Parse(json);
- // Find the first array using Linq
- var srcArray = jsonLinq.Descendants().Where(d => d is JArray).First();
- var trgArray = new JArray();
- foreach (JObject row in srcArray.Children
()) - {
- var cleanRow = new JObject();
- foreach (JProperty column in row.Properties())
- {
- // Only include JValue types
- if (column.Value is JValue)
- {
- cleanRow.Add(column.Name, column.Value);
- }
- }
- trgArray.Add(cleanRow);
- }
- return JsonConvert.DeserializeObject
(trgArray.ToString()); - }
Rajanikant HawaldarPosted Jun 30, 2019, 11:30 PM
Suhas KursePosted Jun 30, 2019, 9:35 PM
Gajendra JangidPosted Jun 30, 2019, 3:02 AM