Parsing Only the First Object of Array JSON

Question

I have the following text structure in JSON:

   {
   "Results":{
      "Burger King":{
         "Location":"New York",
         "Address":"Avenue Dalmatas, 20"
 },
      "Mcdonalds":{
         "Location":"Los Angeles",
         "Address":"Oscar Street, 50"
      }
   }
}

I managed to get the city and address results, but for that I need to mention the name of the restaurant in the code to grab the token string.

Dim JSON As String = **json here**

        Dim token As JToken
        token = JObject.Parse(JSON.ToString())
        Dim data = token.SelectToken("Results").SelectToken("Burger King").SelectToken("Location")

My question is, how can I list only the restaurants (Burger King, Mcdonalds, etc), for example, in a Listbox? So I can add some feature that checks the address and city with the user's choice, which I know and already understand how to do, but getting the token with only the names of the restaurants is being difficult for me. If i have a new restaurant name for example, I wouldn't want to include manually in the code. I have tried a lot of different ways, but the last one I have used it was the following:

Dim data = token.SelectToken("Results").SelectToken(0) 'i thought it would print 'Burger King'
'or this one
Dim data = token.SelectToken("Results")(0).ToString()

I've tried some 'For Each' loop code but I wasn't successful either. I've researched countless methods on how to do this and nothing works. I believe it's something simple that I'm either ignoring or completely forgetting.. Please give me a light! Thanks.

Serge · Accepted Answer · 2021-12-30 18:15:34Z

1

I can post c# code for you, it would be easier for you to translate it to VB if you need

var jsonObject=  JObject.Parse(json);

List<string> restaurantNames= ((JObject)jsonObject["Results"]).Properties()
.Select(x=>x.Name).Distinct().ToList();

result

Burger King
Mcdonalds

edited Dec 30, 2021 at 18:15

answered Dec 30, 2021 at 17:18

Serge

44.4k4 gold badges26 silver badges53 bronze badges

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

4 Comments

toxdotnet Over a year ago

Hey Serge. I gonna try soon and update you about it :) ty

Serge Over a year ago

@toxdotnet Ok, pls keep me posted.

toxdotnet Over a year ago

Works like a charm :) Thank you very much.

Serge Over a year ago

You are welcome!

Collectives™ on Stack Overflow

Parsing Only the First Object of Array JSON

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related