Manipulation multidimensional JSON array in C#

Question

I need to manipulate the following JSON Array to compare the value for Company Id. Any suggestions how I can manipulate this.

{  "39513447": {    "field": "39513447",    "label": "CompanyId",    "type": "number",    "value": "5907"  },  "39513458": {    "field": "39513458",    "label": "UserId",    "type": "number",    "value": "5904"  },  "39380671": {    "field": "39380671",    "label": "Name",    "type": "name",    "value": "first = First\nlast = Name"  },  "39380675": {    "field": "39380675",    "label": "Company Name",    "type": "text",    "value": "CompanyName"  },  "39381333": {    "field": "39381333",    "label": "Planned Gross Salary Amount",    "type": "number",    "value": "11020"  },  "39381266": {    "field": "39381266",    "label": "Per:",    "type": "select",    "value": "Annum"  },  "39380485": {    "field": "39380485",    "label": "Planned Gross Dividend Amount",    "type": "number",    "value": "31980"  },  "39381357": {    "field": "39381357",    "label": "Per:",    "type": "select",    "value": "Annum"  }}

I have a class with these 3 properties:

public int id { get; set; }
public DateTime timestamp { get; set; }
public object data { get; set; }

Which I deserialize using:

T jsonObject = JsonConvert.DeserializeObject<T>(text);

Ideally want to deserialize into class with these 4 properties:

public string field { get; set; }
public string label { get; set; }
public string type { get; set; }
public string value { get; set; }

Would you please specify your answer and include your code. Have you define any class for the data representation? — Mainul
– Mainul, Commented Feb 18, 2016 at 16:01

Amir Popovich · Accepted Answer · 2016-02-18 17:00:15Z

1

Create a class:

public class MyClass
{
    public string field { get; set; }
    public string label { get; set; }
    public string type { get; set; }
    public string value { get; set; }
}

And simple deserialize your json into a Dictionary:

var json = GetJsonString();
var dict = JsonConvert.DeserializeObject<Dictionary<int,MyClass>>(json);

Here's how to fetch data:

var curr = dict[39513447]; 
var field = curr.field;
var label = curr.label;
// etc.

answered Feb 18, 2016 at 17:00

Amir Popovich

30.1k9 gold badges58 silver badges102 bronze badges

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

Collectives™ on Stack Overflow

Manipulation multidimensional JSON array in C#

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related