Deserializing dynamically a json file were some cells are empty and getting an invalid array

Question

When I deserialize a json dynamically i get an array with fewer columns on some rows.

using (StreamReader file = File.OpenText(filePath))
{
    dynamic words = JsonConvert.DeserializeAnonymousType(file.ReadToEnd(), new ExpandoObject());
    DataTable dt = ToDataTable(words.wordlist.item);

    return dt;
}

public static DataTable ToDataTable(this IEnumerable<dynamic> items)
    {
        var data = items.ToArray();
        if (data.Count() == 0) return null;

        var dt = new DataTable();
        foreach (var key in ((IDictionary<string, object>)data[0]).Keys)
        {
            dt.Columns.Add(key);
        }
        foreach (var d in data)
        {
            dt.Rows.Add(((IDictionary<string, object>)d).Values.ToArray());
        }
        return dt;
    }

I understand why it does this but I can't find any way to fix it.

Manged to solve it using this [answer](https://stackoverflow.com/a/34287982/4857852) — Ilias Tsakiridis, Jun 14 '19 at 13:15

score 0 · Answer 1 · answered Jun 14 '19 at 11:00

0

This might work for you.

DataTable dt = (DataTable)JsonConvert.DeserializeObject(json, (typeof(DataTable)));

answered Jun 14 '19 at 11:00

Neil B

2,096
1
12
23

Got error 'Unexpected JSON token when reading DataTable. Expected StartArray, got StartObject. Path '', line 1, position 1.' – Ilias Tsakiridis Jun 14 '19 at 11:06
Can you post your json? Or perhaps a fragment of the problematic portion? – Neil B Jun 14 '19 at 11:09
Do you have control over how the json is produced? – Neil B Jun 14 '19 at 11:09
no because these are already generated json files that have differences and I want to display the data dynamically on a DataGrid. I will post some of the json. – Ilias Tsakiridis Jun 14 '19 at 11:16
stack overflow wont let me post more code but I found that the json on some rows it has the missing column and on some others it doesn't. – Ilias Tsakiridis Jun 14 '19 at 11:28

Deserializing dynamically a json file were some cells are empty and getting an invalid array

1 Answers1