json - 从URL读取JSON

端点是在Google SpreadSheet中创建的，位于以下位置:

url01 := "https://spreadsheets.google.com/feeds/list/168xdxefP3gGnrTGg2hwJoeRVfmbEuTB5plFTyd6I5Qo/1/public/values?alt=json"

Git仓库在这里...在我修复它的地方，我将保留更新的代码。我的直觉是我在导入文件时搞砸了结构。该代码不打印任何内容。因此，请问我有什么建议可以解决问题。

        package main

import (
    "encoding/json"
    "fmt"
    "net/http"
)

type GSSS struct {
    Feed GSSSfeed `json:"feed"`
}

type GSSSfeed struct {
    Version string   `json:"version"`
    TITLE   GSSTitle `json:"title"`
    // Entry   []GSSSEntry `json:"entry"`
}
type GSSTitle struct {
    T string `json:"t"`
}

func main() {
    url01 := "https://spreadsheets.google.com/feeds/list/168xdxefP3gGnrTGg2hwJoeRVfmbEuTB5plFTyd6I5Qo/1/public/values?alt=json"
    //url02 := "https://spreadsheets.google.com/feeds/list/168xdxefP3gGnrTGg2hwJoeRVfmbEuTB5plFTyd6I5Qo/2/public/values?alt=json"
    //url03 := "https://spreadsheets.google.com/feeds/list/168xdxefP3gGnrTGg2hwJoeRVfmbEuTB5plFTyd6I5Qo/3/public/values?alt=json"
    //url04 := "https://spreadsheets.google.com/feeds/list/168xdxefP3gGnrTGg2hwJoeRVfmbEuTB5plFTyd6I5Qo/4/public/values?alt=json"
    //url05 := "https://spreadsheets.google.com/feeds/list/168xdxefP3gGnrTGg2hwJoeRVfmbEuTB5plFTyd6I5Qo/5/public/values?alt=json"
    println("=============  starting main =============")

    // res, err := http.Get("https://www.citibikenyc.com/stations/json")
    res, err := http.Get(url01)
    if err != nil {
        panic(err.Error())
    }

    // body, err := ioutil.ReadAll(res.Body)
    // if err != nil {
    //  panic(err.Error())
    // }

    var m GSSS
    // err := json.Unmarshal(body, &m)
    //json.NewDecoder(res.Body).Decode(&m)
    // json.NewDecoder([]byte(body)).Decode(&m)

    // json.NewDecoder([]byte(res.Body)).Decode(&m)
    json.NewDecoder(res.Body).Decode(&m)

    //err := json.Unmarshal([]byte(body), &m)
    if err != nil {
        fmt.Println("Whoops...:", err)
    }

    fmt.Println("============  about to print m ============")
    fmt.Println(m.Feed.TITLE.T)
    fmt.Println("============  about to print m2 ============")
    fmt.Println(m.Feed)
    fmt.Println("============  about to print m3 ============")
    fmt.Println(m)
    fmt.Println("============  about to print m4 ============")
}

最佳答案

如前所述，您对GSSS的定义是错误的。

效果更好:

package main

import (
    "encoding/json"
    "fmt"
    "net/http"
)

type GSSS struct {
    Version string `json:"version"`
    Feed GSSSfeed `json:"feed"`
}

type GSSSfeed struct {
    TITLE   GSSTitle `json:"title"`
    // Entry   []GSSSEntry `json:"entry"`
}
type GSSTitle struct {
    T string `json:"$t"`
}

func main() {
    url01 := "https://spreadsheets.google.com/feeds/list/168xdxefP3gGnrTGg2hwJoeRVfmbEuTB5plFTyd6I5Qo/1/public/values?alt=json"
    //url02 := "https://spreadsheets.google.com/feeds/list/168xdxefP3gGnrTGg2hwJoeRVfmbEuTB5plFTyd6I5Qo/2/public/values?alt=json"
    //url03 := "https://spreadsheets.google.com/feeds/list/168xdxefP3gGnrTGg2hwJoeRVfmbEuTB5plFTyd6I5Qo/3/public/values?alt=json"
    //url04 := "https://spreadsheets.google.com/feeds/list/168xdxefP3gGnrTGg2hwJoeRVfmbEuTB5plFTyd6I5Qo/4/public/values?alt=json"
    //url05 := "https://spreadsheets.google.com/feeds/list/168xdxefP3gGnrTGg2hwJoeRVfmbEuTB5plFTyd6I5Qo/5/public/values?alt=json"
    println("=============  starting main =============")

    // res, err := http.Get("https://www.citibikenyc.com/stations/json")
    res, err := http.Get(url01)
    if err != nil {
        panic(err.Error())
    }

    // body, err := ioutil.ReadAll(res.Body)
    // if err != nil {
    //  panic(err.Error())
    // }

    var m GSSS
    // err := json.Unmarshal(body, &m)
    //json.NewDecoder(res.Body).Decode(&m)
    // json.NewDecoder([]byte(body)).Decode(&m)

    // json.NewDecoder([]byte(res.Body)).Decode(&m)
    json.NewDecoder(res.Body).Decode(&m)

    //err := json.Unmarshal([]byte(body), &m)
    if err != nil {
        fmt.Println("Whoops...:", err)
    }

    fmt.Println("============  about to print m3 ============")
    fmt.Println(m)
    fmt.Println("============  about to print m4 ============")
}

关于json - 从URL读取JSON，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/44802899/