解析嵌套的json文件

Question

I'm parsing a JSON file with an unusual structure which looks like this:

{
    "394885": 
    {
        "record": 
        {
            "student_name": "Daryl Jones",
            "student_number": 123884,
            "student_dob": "12/10/1982",
            "student_email": "[e-mail]",
        }    
    },
}

I've been working through some code demos, but I would like to put it all in to a struct, which I then plan to search through by the number string that's the object name I would guess?

I'm not strong on JSON or Go, and this is the code I've written so far:

package main

import (
    "encoding/json"
    "fmt"
    "io/ioutil"
    "os"
)

type id struct {
    recordid string
    record   []record
}

type record struct {
    name   string
    number uint32
    dob    string
    email  string
}

func main() {
    jsonFile, err := os.Open("/home/emyrw/development/go/src/json_processor/demo.json")
    if err != nil {
        fmt.Println(err)
    } else {
        var records id

        byteValue, _ := ioutil.ReadAll(jsonFile)
        json.Unmarshal(byteValue, &records)
        fmt.Println(records)

        fmt.Println("opened demo.json")
        defer jsonFile.Close()
    }
}

I'm not sure I've got it right, but would value any tips or advice anyone has to offer. I've been googling, but none of the samples I find quite fit my scenario.

Answer 1

You can use this struct for your id type

type id struct {
    record map[string]record
}

Edit

here is the working solution with some explanation:

since you have a multi level json, you can parse it into nested structs.

{
        "student_name": "Daryl Jones",
        "student_number": 123884,
        "student_dob": "12/10/1982",
        "student_email": "[e-mail]"
} 

to parse this part of the json you need this struct

type record struct {
    Name   string `json:"student_name"`
    Number uint32 `json:"student_number"`
    Dob    string `json:"student_dob"`
    Email  string `json:"student_email"`
}

the fields have to be exported(start with capital letter) and have a json tag that matches json properties.

{
    "record": 
    {
        "student_name": "Daryl Jones",
        "student_number": 123884,
        "student_dob": "12/10/1982",
        "student_email": "[e-mail]"
    }    
}

for this part to work, you need a nested struct like this

type id struct {
     Record record
}

the filed name is exported again but since it matches your json property, you don't need the tag.

{
"394885": 
  {
    "record": 
    {
        "student_name": "Daryl Jones",
        "student_number": 123884,
        "student_dob": "12/10/1982",
        "student_email": "[e-mail]"
    }    
  }
}

since the top level property name is the student id, you can use a map instead of a struct

 var records map[string]id 

and make sure you don't have trailing commas as that is not allowed in json specs