Parse Json contains no array in c#

Question

I'm call an API that returns the following json

{
  "services":{
     "Home":{
        "Homecall":{
           "id":"10"
        },
        "Two Day":{
           "id":"11"
        },
        "Three Day":{
           "id":"12"
        }
     }
  }
}

What would be the best possible way to parse this so it returns 'Home' as a unqiue variable, "homecall","Two day" and "three day" along with their ID in c#?

There are no arrays in this JSON string. Home is a dictionary/object with attributes named HomeCall, Two Day, Three Day. You can deserialize it to Dictionary<string,Whatever> — Panagiotis Kanavos
– Panagiotis Kanavos, Commented Jan 20, 2023 at 15:31
The api isn't returning any array in the JSON string, this is what has stumped me — PMG
– PMG, Commented Jan 20, 2023 at 15:32
Use Dictionary<string,Whatever> as Home's type. Unless you want even services to be a dictionary. What does this JSON document contain? And what do you want to do with its contents? — Panagiotis Kanavos
– Panagiotis Kanavos, Commented Jan 20, 2023 at 15:33
You are the developer of the mentioned API and can change the implementation so you actually get an array? — Ralf
– Ralf, Commented Jan 20, 2023 at 15:42
Panagiotis, once im able to get this keys they'll be passed into a sql. I'll give your dictionary method a go. — PMG
– PMG, Commented Jan 20, 2023 at 15:43

Hille · Accepted Answer · 2023-01-20 17:02:47Z

2

you can try something like this

HomeClass home = new HomeClass
{
    Home = ((JObject)JObject.Parse(json)["services"]["Home"]).Properties()
        .Select(h => new MyClass { Name = h.Name, Id = Convert.ToInt64(h.Value["id"]) })
        .ToList()
};

public class HomeClass
{
    public List<MyClass> Home { get; set; }
}
public class MyClass
{
    public long Id { get; set; }
    public string Name { get; set; }
}

output in a json format

{
  "Home": [
    {
      "Id": 10,
      "Name": "Homecall"
    },
    {
      "Id": 11,
      "Name": "Two Day"
    },
    {
      "Id": 12,
      "Name": "Three Day"
    }
  ]
}

edited Jan 20, 2023 at 17:02

Hille

2,3611 gold badge29 silver badges43 bronze badges

answered Jan 20, 2023 at 16:14

Serge

44.4k4 gold badges26 silver badges53 bronze badges

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

Collectives™ on Stack Overflow

Parse Json contains no 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