Unable to Parse this Json string in c#

Question

I tried using Newtonsoft.Json to deserialize this json string, but I'm not getting the desired output. my json string is

[
{
"id": 1,
"key": "Residential Homeowner",
"i18nText": "unknown message code DB_ENUM_UserType_residentialhomeowner",
"i18nKey": "DB_ENUM_UserType_residentialhomeowner"
},
{
"id": 8,
"key": "VAR Dealer \/ Builder",
"i18nText": "unknown message code DB_ENUM_UserType_vardealer\/builder",
"i18nKey": "DB_ENUM_UserType_vardealer\/builder"
},
{
"id": 2,
"key": "Administrator",
"i18nText": "unknown message code DB_ENUM_UserType_administrator",
"i18nKey": "DB_ENUM_UserType_administrator"
},
{
"id": 9998,
"key": "TempGuidUser",
"i18nText": "unknown message code DB_ENUM_UserType_tempguiduser",
"i18nKey": "DB_ENUM_UserType_tempguiduser"
},
{
"id": 9999,
"key": "GuidUser",
"i18nText": "unknown message code DB_ENUM_UserType_guiduser",
"i18nKey": "DB_ENUM_UserType_guiduser"
}
]

I just want the value of key when value of id=1. Generally json starts with {}(curly bracket) but here it is like [](square bracket). I've seen many examples but none worked for me.

possible duplicate of Deserializing JSON Object Array with Json.net — James
– James, Commented Nov 15, 2013 at 13:46

Sergey Kalinichenko · Accepted Answer · 2013-11-15 13:46:18Z

6

Generally json starts with {} (curly bracket), but here it is like [] (square bracket).

This is because you got an array of objects, not a single object. Arrays are serialized with square brackets around them. You should deserialize it into an array, and then grab the object at the index of interest.

answered Nov 15, 2013 at 13:46

Sergey Kalinichenko

729k85 gold badges1.2k silver badges1.6k bronze badges

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

2 Comments

Sumit Chourasia Over a year ago

i tried using this class. but it is not working :( public class userType { public string id { get; set; } public string key { get; set; } public string i18nText { get; set; } public string i18nKey { get; set; } }

Sergey Kalinichenko Over a year ago

@SumitChourasia The class looks right. How did you call Newtonsoft's deserializer? Something like JsonConvert.DeserializeObject<MyClass[]>?

Sven Grosen · Accepted Answer · 2013-11-15 13:56:19Z

5

If you are only interested in a single value from that larger JSON value, you may want to try Linq to JSON which would allow you to query over the JSON without deserializing everything.

Example:

JArray values = JArray.Parse(json);

string key;
var keyObject = values.FirstOrDefault(p => (int)p["id"] == 1);
if (keyObject != null)
{
     key = (string)keyObject["key"];
}

edited Nov 15, 2013 at 13:56

answered Nov 15, 2013 at 13:50

Sven Grosen

5,6363 gold badges33 silver badges56 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 12:12:55Z

5

This is a related post that addresses JSON parsing in C#: C# JSON Parsing.

If the brackets are a problem, simply use:

string json = inputJson.Trim().Trim('[',']');

If the id can have a minimum value of 1, then this should work:

string GetKey(string inputJson)
{
    string key = inputJson.Substring(inputJson.IndexOf("key")+5);
    key = key.Substring(key.IndexOf("\""), key.IndexOf(",")-key.IndexOf("\""));
    key = key.Trim('\"');
    return key;
}

edited May 23, 2017 at 12:12

CommunityBot

11 silver badge

answered Nov 15, 2013 at 13:47

Igor Ševo

5,5653 gold badges40 silver badges84 bronze badges

3 Comments

Sumit Chourasia Over a year ago

I just want the value of key when value of id=1.

Sumit Chourasia Over a year ago

This is too much complicated. :(

Sumit Chourasia Over a year ago

Thanks for your effort. but implementation with linq is very simple :)

Tolga Evcimen · Accepted Answer · 2013-11-15 13:50:26Z

2

[] is to define a json object array. Your output should be an array. Traverse through the array like:

for(var i=0; i<output.Length; i++)
{
    if(output[i].id == "1") // desired id
    {
        Console.WriteLine(output[i].key);// use it as you wish
    }
}

and use the found objects key.

answered Nov 15, 2013 at 13:50

Tolga Evcimen

7,39011 gold badges63 silver badges97 bronze badges

1 Comment

Tolga Evcimen Over a year ago

I just wanted to give you an idea of how you would approach the problem. @ledbutter's solution is of course the ideal one ;)

Collectives™ on Stack Overflow

Unable to Parse this Json string in c#

4 Answers 4

2 Comments

Comments

3 Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

3 Comments

1 Comment

Linked

Related