Deserialise JSON text

Question

0.00/5 (No votes)

See more:

Im trying to deserialise the following JSON text, but getting nowhere and I cant figure out where Im going wrong - can anyone point me in the right direction please?

{
"data":
{
"id":125,
"domain":"Sports",
"patient_name":"Fred Smith",
"patient_gender":"male",
"patient_image":"https:\/\/mysite.png",
"temperature":-105,
"duration":130,
"weir_height":160,
"session_rank":1,
"next_session_rank":2,
"next_session_date":
{
"date":"2017-10-15 10:00:00.000000",
"timezone_type":3,
"timezone":"UTC"
}
}
}

I think its something to do with the JSON fields being a sub-level of the 'data' key and that is what I'm finding hard to figure out how to deal with as the code works with JSON data that doesn't have this container.

What I have tried:

Using response As Net.HttpWebResponse = request.GetResponse
     Using streamReader As New IO.StreamReader(response.GetResponseStream)
     
     Dim jsonResponseText = streamReader.ReadToEnd
     Dim jsonResult As PFCNext = New Web.Script.Serialization.JavaScriptSerializer().Deserialize(jsonResponseText, GetType(PFCNext))
     
    End Using 'streamreader
End Using 'response

    Class PFCNext
        Property Id As String
        Property Domain As String
        Property Patient_name As String
        Property Patient_gender As String
        Property Patient_image As String
        Property Temperature As String
        Property Duration As String
        Property Weir_height As String
        Property Session_rank As String
        Property Next_session_rank As String
        Property Next_session_date As String
        Property Date_ As String
        Property Timezone_type As String
        Property Timezone As String
    End Class

Posted 6-Oct-17 6:16am

SheepRustler

Updated 6-Oct-17 13:22pm

v3

Add a Solution

2 solutions

Solution 2

This CodeProject article will show you how, with source code, to take raw JSON data, generate the classes quickly and deserialize the data: Working with JSON in C# & VB[^]

Posted 6-Oct-17 13:22pm

Graeme_Grant

Comments

SheepRustler 9-Oct-17 6:01am

Thanks, that's very useful.

Graeme_Grant 9-Oct-17 6:14am

You are welcome. The article linked was put together after answering many questions, like yours, about working with JSON data, right here in the Q&A forums.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard Deeming · Accepted Answer · 2017-10-06T08:01:00

Unless you write a custom converter, the structure of your class needs to match the structure of your JSON:

VB.NET

Class PFCNextWrapper
    Public Property Data As PFCNext
End Class

Class PFCNext
    Public Property Id As Integer
    Public Property Domain As String
    Public Property Patient_name As String
    Public Property Patient_gender As String
    Public Property Patient_image As String
    Public Property Temperature As Integer
    Public Property Duration As Integer
    Public Property Weir_height As Integer
    Public Property Session_rank As Integer
    Public Property Next_session_rank As Integer
    Public Property Next_session_date As NextSessionDate
End Class

Class NextSessionDate
    Public Property [Date] As Date
    Public Property Timezone_type As Integer
    Public Property Timezone As String
End Class

You can then deserialize your JSON to the PFCNextWrapper type: