JSON to C# a Dynamic List<object> or DataTable

Question

Short version: How can I deserialize a JSON string into a C# list or DataTable without having a defined class to deserialize to?

More explanation: My controller expects a json string which is an array of objects but the properties of the object is unknown. I need to deserialize it into a list and loop through its contents for saving. Sample json strings:
1.

[
    {"id":"10","name":"User","add":false,"edit":true,"authorize":true,"view":true},
    {"id":"11","name":"Group","add":true,"edit":false,"authorize":false,"view":true},
    {"id":"12","name":"Permission","add":true,"edit":true,"authorize":true,"view":true}
]

2.

[
    {"id":"10","name":"User"},
    {"id":"11","name":"Group"},
    {"id":"12","name":"Permission"}
]

Possible duplicate with stackoverflow.com/questions/3142495/…. — Tetsuya Yamamoto
– Tetsuya Yamamoto, Commented Jul 15, 2016 at 2:31
If after deserialize it need loop through its contents for saving, unless you knowing the mapping of the fields like first field = saving field 1, second field =saving field 2, etc. Else I rather define a class to deserialize it. — Harris Yer
– Harris Yer, Commented Jul 15, 2016 at 2:40

Tommy · Accepted Answer · 2016-07-15 02:37:35Z

3

dynamic jsonObject = System.Web.Helpers.Json.Decode(jsonText);

edited Jul 15, 2016 at 2:37

answered Jul 15, 2016 at 2:29

Tommy

3,1441 gold badge17 silver badges13 bronze badges

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

1 Comment

Donny McCoy Over a year ago

Beautiful! This allowed me to convert my web api to partial response by combining this answer with dotarj's solution (github.com/dotarj/PartialResponse). Many thanks!

Community · Accepted Answer · 2017-05-23 12:01:33Z

0

Deserialize your Json and cast it directly to datatable.

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

Refer to this answer : https://stackoverflow.com/a/27282579/4827151

edited May 23, 2017 at 12:01

CommunityBot

11 silver badge

answered Jul 15, 2016 at 2:31

Anonymous Duck

3,0081 gold badge14 silver badges35 bronze badges

Collectives™ on Stack Overflow

JSON to C# a Dynamic List<object> or DataTable

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related