Using JArray.Parse(json) on an associative array

Question

I've put together the following code from this answer:

JArray jsonArray = JArray.Parse(json);
foreach(JObject jsonObject in jsonArray.Children<JObject>())
{
    foreach(JProperty jProperty in jsonObject.Properties())
    {
        int id = jProperty.id;
        string name = (string)jProperty.Name;
        textBox1.AppendText(id.ToString() + " // " + name + Environment.NewLine);
    }
}

A sample of the JSON I'm trying to parse is as following:

[{"id":"219","name":"Jimmy"},{"id":"220","name":"Bobby"},{"id":"218","name":"Arthur"}]

The answer I referenced deals with parsing key => value pairs, how can I parse an associative array?

Its just an array of key value pairs. Key: Id, Value 219 (or "219"). You could deserialize to get at the data more easily especially since you appear to be consuming all of it — Ňɏssa Pøngjǣrdenlarp
– Ňɏssa Pøngjǣrdenlarp, Commented Oct 5, 2018 at 20:00

Etienne de Martel · Accepted Answer · 2018-10-05 20:05:57Z

2

JSON doesn't have "associative arrays". It has arrays and objects.

What you have here is an array of objects. So, JArray.Parse will give you a JArray, and each item in it is itself a JObject:

var array = JArray.Parse(json);
foreach(JObject obj in array)
{
    int id = obj.Value<int>("id");
    string name = obj.Value<string>("name");
    // ...
}

answered Oct 5, 2018 at 20:05

Etienne de Martel

37.2k10 gold badges95 silver badges119 bronze badges

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

1 Comment

Chud37 Over a year ago

Thank you!! I'm still really new to C# so these kind of things I need to learn. Really appreciate your response.

Collectives™ on Stack Overflow

Using JArray.Parse(json) on an associative array

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related