Hello, I need to extract the values of 21, black jack, and tongits including their scores from the following JSON code:
{
"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
}
]
}
Below is my VB code that currently only retrieves the values for 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