Extract array elements from JSON array with Newtonsoft JSON

Question

I have a JSON data like bellow

[{"Staffs":[5,10,12,14]},{"Staffs":[11,13,15,17]}]

and I want to extract value from it and expect bellow data

[5,10,12,14,11,13,15,17]

How can I do this with newtonsoft JSON .

You first need to translate this json to an array of objects with Staffs property. Then use linq to merge those property values in to a single array. — Chetan
– Chetan, Commented Dec 8, 2019 at 13:42
Hi @ChetanRanpariya Thanks for reply,can you please give me some code example with newtonsoft json? — kuntal
– kuntal, Commented Dec 8, 2019 at 13:46

Sweeper · Accepted Answer · 2019-12-08 13:50:31Z

5

You can first parse the JSON to a JArray:

using Newtonsoft.Json.Linq;

var array = JArray.Parse(yourJSONString);

Then, use SelectMany to flatten it and convert it to a List<int>:

var result = array.SelectMany(x => x["Staffs"]).Values<int>().ToList();

answered Dec 8, 2019 at 13:50

Sweeper

292k23 gold badges260 silver badges438 bronze badges

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

2 Comments

kuntal Over a year ago

Hi @Sweeper thanks for your reply I have another json [{"Manager":6},{"Manager":8}] and I want only value as an array ,like [6,8] and apply your code but not working.can you please help ?

Sweeper Over a year ago

@kuntal If the inner values are not arrays, you'd have to use Select instead.

Mohammad · Accepted Answer · 2019-12-08 14:01:43Z

first of all create a model

class StaffsModel
{
    [JsonProperty("Staffs")]
    public int[] Staffs { get; set; }
}

if we consider to created a json value by object like this

var staffsList = new List<StaffsModel>();
staffsList.Add(new StaffsModel { Staffs = new[] { 5, 10, 12, 14 } });
staffsList.Add(new StaffsModel { Staffs = new[] { 11, 13, 15, 17 } });

we can serialize to array with this method

string json = JsonConvert.SerializeObject(staffsList);

with this output [{"Staffs":[5,10,12,14]},{"Staffs":[11,13,15,17]}]

and finally added to list of numbers

var data = JsonConvert.DeserializeObject<StaffsModel[]>(json);
if (data?.Length > 0)
{
    var listOfNumbers = new List<int>();
    foreach (var staff in data)
    {
        foreach (var number in staff.Staffs)
        {
             listOfNumbers.Add(number);
        }
    }
}

Collectives™ on Stack Overflow

Extract array elements from JSON array with Newtonsoft JSON

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related