How to get value of item in JSON array c#?

Question

So, please read this detail for more information. I get error at Method not found: 'System.String System.String.Format(System.IFormatProvider, System.String, System.Object)'. when i try get value of items of array.

The array is:

{
    [
        {
            "GROUP_MOD_ID": "G06",
            "ADMIN": 1,
            "USERS": 0
        }
     ]
}

This is snippet code

  dynamic obj_str = JsonConvert.DeserializeObject(obj);
                string value_admin = obj_str["ADMIN"];
                Console.WriteLine(value_admin);       
                if (value_admin == "1")
                    return true;
                else
                    return false;

. Thank all.

The JSON string you posted has curly-braced surrounding the array. This is not valid JSON syntax. What is the raw value of the input string (or stream) you're using? — Dai
– Dai, Commented Nov 19, 2016 at 7:19
Dear @Dai, obj is type of string [{"GROUP_MOD_ID":"G06","ADMIN":1,"USERS":0}] — Brian Crist
– Brian Crist, Commented Nov 19, 2016 at 7:23

Dai · Accepted Answer · 2016-11-19 07:25:29Z

3

I wouldn't use dynamic in this case. I generally recommend avoiding dynamic in C#. Instead I prefer the JToken-style approach (in the Newtonsoft.Json.Linq namespace, though it doesn't mean you have to use Linq):

JArray array = JArray.Parse( input );
JObject firstObject = (JObject)array.First;
String adminValue = (String)firstObject.GetValue("ADMIN");

In production you'll want to add input validation code to ensure the input JSON array and object actually has elements and values and handle those errors accordingly.

But if you're certain that the input is correct you can reduce this down to a single-line:

String adminValue = (String)( ((JObject)JArray.Parse( input )).First.GetValue("ADMIN") );

...at the cost of readbility, of course.

answered Nov 19, 2016 at 7:25

Dai

157k31 gold badges314 silver badges436 bronze badges

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

Comments

Vivek Nuna · Accepted Answer · 2016-11-19 07:43:49Z

2

First of all your JSON seems to be incorrect.

Correct JSON:

[{
"GROUP_MOD_ID": "G06",
"ADMIN": 1,
"USERS": 0
}]

And when you desialize this json, it will give you array of array.

You code will be:

    dynamic obj_str = JsonConvert.DeserializeObject(json);
    string value_admin = obj_str[0].ADMIN;
    Console.WriteLine(value_admin);
    if (value_admin == "1")
    {
    }
    else
    {
    }

You can see this by doing this way to.

public class SampleClass
{
    public string GROUP_MOD_ID { get; set; }
    public int ADMIN { get; set; }
    public int USERS { get; set; }
}

Code to deserialize:

    SampleClass[] obj_str = JsonConvert.DeserializeObject<SampleClass[]>(json);
    int value_admin = obj_str[0].ADMIN;
    Console.WriteLine(value_admin);
    if (value_admin == 1)
    {
    }
    else
    {
    }

answered Nov 19, 2016 at 7:43

Vivek Nuna

30.6k34 gold badges162 silver badges259 bronze badges

1 Comment

Brian Crist Over a year ago

Yes, I have, according to above, it's work but i have create a new class.Thank you.

Dharminder Singh · Accepted Answer · 2016-11-19 07:27:00Z

0

Your code would work only if you have json as

var obj="{'GROUP_MOD_ID':'G06','ADMIN':10,'USERS':0}";

or

    var obj="[{'GROUP_MOD_ID':'G06','ADMIN':1,'USERS':0}]";

    dynamic obj_str = JsonConvert.DeserializeObject(obj);
            string value_admin = obj_str[0]["ADMIN"];
            Console.WriteLine(value_admin);

edited Nov 19, 2016 at 7:27

answered Nov 19, 2016 at 7:20

Dharminder Singh

644 bronze badges

1 Comment

Brian Crist Over a year ago

Dear @Dharminder Singh, after , i had use this , but it gets same error Method not found: 'System.String System.String.Format(System.IFormatProvider, System.String, System.Object)'.

Vivek Nuna · Accepted Answer · 2016-11-19 09:00:48Z

0

Hi first of you make model for Deserialize Object.

Your model like this.

public class Test_Model
{
    [JsonProperty("GROUP_MOD_ID")]
    public string GROUP_MOD_ID { get; set; }
    [JsonProperty("ADMIN")]
    public int ADMIN { get; set; }
    [JsonProperty("USERS")]
    public int USERS { get; set; }
}

and after write this code:

        var obj_str = JsonConvert.DeserializeObject<Test_Model>(obj);
        int value_admin = obj_str.ADMIN;
        Console.WriteLine(value_admin);
        if (value_admin == 1)
            return true;
        else return false;

I hope so your problem sort out.

edited Nov 19, 2016 at 9:00

Vivek Nuna

30.6k34 gold badges162 silver badges259 bronze badges

answered Nov 19, 2016 at 7:53

prajapati prakash

213 bronze badges

Collectives™ on Stack Overflow

How to get value of item in JSON array c#?

4 Answers 4

Comments

1 Comment

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related