Getting value from jsoncode using VB.net

Question

hello I have this json code and I would like to get the value which is 21, black jack, tongits along with its score.

{
  "id": 1,
  "status": "PARTIAL",
  "scores": [
    {
      "scoreCard": {
        "21": 0,
        "black jack": 0,
        "tongits": 0
      },
      "question": "Favorite game",
      "questionnaireId": 1
    },
    {
      "scoreCard": {
        "red": 0,
        "green": 0,
       "blue": 0,
        "black": 0
      },
      "question": "Favorite color",
      "questionnaireId": 2
    }
  ]
}

this is my vb code which I only get the value Favorite game and Favorite color

Dim webC As New System.Net.WebClient
     Dim json As String =webC.DownloadString("http://localhost:8080/report/survey/1/result")

    Dim o As JObject = JObject.Parse(json)

    Dim results As List(Of JToken) = o.Children().ToList

    For Each item As JProperty In results
        item.CreateReader()
        Select Case item.Name

            Case "scores"

                Dim question As String

                For Each subitem As JObject In item.Values
                    question = subitem("question")
                    Listview2.Items.Add(question)

                Next
        End Select
    Next

you could deserialize it in 1-2 lines of code

Ňɏssa Pøngjǣrdenlarp
– Ňɏssa Pøngjǣrdenlarp

2017-02-12 14:03:17 +00:00
Commented Feb 12, 2017 at 14:03 — Ňɏssa Pøngjǣrdenlarp
– Ňɏssa Pøngjǣrdenlarp, Commented Feb 12, 2017 at 14:03
what exacly do you mean?

Nerick Santiago
– Nerick Santiago

2017-02-12 14:20:41 +00:00
Commented Feb 12, 2017 at 14:20 — Nerick Santiago
– Nerick Santiago, Commented Feb 12, 2017 at 14:20

Community · Accepted Answer · 2017-05-23 11:45:26Z

0

Its easier to parse the data to get just one or two things:

Dim jstr = ...from where ever...

Dim jData = JObject.Parse(jstr)

Console.WriteLine(jData("scores")(0)("scoreCard")("21"))
Console.WriteLine(jData("scores")(0)("scoreCard")("black jack"))
Console.WriteLine(jData("scores")(0)("scoreCard")("tongits"))

Console.WriteLine(jData("scores")(0)("question"))
Console.WriteLine(jData("scores")(1)("question"))

scores is an array as indicated by the [ ... ] enclosure, so that needs to be indexed, otherwise just use the indentation and intellisence to fish out whatever you want. Results:

0
0
0
Favorite game
Favorite color

However, since you are after 4 things at least: the 2 questions and 3 scores, it would be even easier to deserialize the data to a class object and just get what you want from the properties.

edited May 23, 2017 at 11:45

CommunityBot

11 silver badge

answered Feb 12, 2017 at 15:50

Ňɏssa Pøngjǣrdenlarp

39k12 gold badges65 silver badges193 bronze badges

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

Collectives™ on Stack Overflow

Getting value from jsoncode using VB.net

hello I have this json code and I would like to get the value which is 21, black jack, tongits along with its score.

this is my vb code which I only get the value Favorite game and Favorite color

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

hello I have this json code and I would like to get the value which is 21, black jack, tongits along with its score.

this is my vb code which I only get the value Favorite game and Favorite color

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related