从URL中读取JSON数据

huangapple
go评论127阅读模式
英文:

Reading json from url

问题

这是一个用Go语言编写的代码片段，它从Google Spreadsheet中获取数据并进行解析。以下是翻译好的代码：

  1. package main
  3. import (
  4. 	"encoding/json"
  5. 	"fmt"
  6. 	"net/http"
  7. )
  9. type GSSS struct {
  10. 	Feed GSSSfeed `json:"feed"`
  11. }
  13. type GSSSfeed struct {
  14. 	Version string   `json:"version"`
  15. 	TITLE   GSSTitle `json:"title"`
  16. 	// Entry   []GSSSEntry `json:"entry"`
  17. }
  18. type GSSTitle struct {
  19. 	T string `json:"t"`
  20. }
  22. func main() {
  23. 	url01 := "https://spreadsheets.google.com/feeds/list/168xdxefP3gGnrTGg2hwJoeRVfmbEuTB5plFTyd6I5Qo/1/public/values?alt=json"
  24. 	//url02 := "https://spreadsheets.google.com/feeds/list/168xdxefP3gGnrTGg2hwJoeRVfmbEuTB5plFTyd6I5Qo/2/public/values?alt=json"
  25. 	//url03 := "https://spreadsheets.google.com/feeds/list/168xdxefP3gGnrTGg2hwJoeRVfmbEuTB5plFTyd6I5Qo/3/public/values?alt=json"
  26. 	//url04 := "https://spreadsheets.google.com/feeds/list/168xdxefP3gGnrTGg2hwJoeRVfmbEuTB5plFTyd6I5Qo/4/public/values?alt=json"
  27. 	//url05 := "https://spreadsheets.google.com/feeds/list/168xdxefP3gGnrTGg2hwJoeRVfmbEuTB5plFTyd6I5Qo/5/public/values?alt=json"
  28. 	println("=============  starting main =============")
  30. 	// res, err := http.Get("https://www.citibikenyc.com/stations/json")
  31. 	res, err := http.Get(url01)
  32. 	if err != nil {
  33. 		panic(err.Error())
  34. 	}
  36. 	var m GSSS
  37. 	json.NewDecoder(res.Body).Decode(&m)
  39. 	if err != nil {
  40. 		fmt.Println("Whoops...:", err)
  41. 	}
  43. 	fmt.Println("============  about to print m ============")
  44. 	fmt.Println(m.Feed.TITLE.T)
  45. 	fmt.Println("============  about to print m2 ============")
  46. 	fmt.Println(m.Feed)
  47. 	fmt.Println("============  about to print m3 ============")
  48. 	fmt.Println(m)
  49. 	fmt.Println("============  about to print m4 ============")
  50. }

这段代码创建了一个HTTP请求，从指定的Google Spreadsheet中获取数据，并将其解析为结构体。然后，它打印出解析后的数据。请注意，代码中的一些注释是被禁用的代码段。

英文:

The endpoint was created in Google SpreadSheet, which is here:

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

The Git repo is here... which is where I will keep the updated code as I fix it. My hunch is that I am screwing up the struct when I import the file. The code prints nothing. So, could I get some advice on what is going wrong please.

  1.         package main
  3. import (
  4. 	"encoding/json"
  5. 	"fmt"
  6. 	"net/http"
  7. )
  9. type GSSS struct {
  10. 	Feed GSSSfeed `json:"feed"`
  11. }
  13. type GSSSfeed struct {
  14. 	Version string   `json:"version"`
  15. 	TITLE   GSSTitle `json:"title"`
  16. 	// Entry   []GSSSEntry `json:"entry"`
  17. }
  18. type GSSTitle struct {
  19. 	T string `json:"t"`
  20. }
  22. func main() {
  23. 	url01 := "https://spreadsheets.google.com/feeds/list/168xdxefP3gGnrTGg2hwJoeRVfmbEuTB5plFTyd6I5Qo/1/public/values?alt=json"
  24. 	//url02 := "https://spreadsheets.google.com/feeds/list/168xdxefP3gGnrTGg2hwJoeRVfmbEuTB5plFTyd6I5Qo/2/public/values?alt=json"
  25. 	//url03 := "https://spreadsheets.google.com/feeds/list/168xdxefP3gGnrTGg2hwJoeRVfmbEuTB5plFTyd6I5Qo/3/public/values?alt=json"
  26. 	//url04 := "https://spreadsheets.google.com/feeds/list/168xdxefP3gGnrTGg2hwJoeRVfmbEuTB5plFTyd6I5Qo/4/public/values?alt=json"
  27. 	//url05 := "https://spreadsheets.google.com/feeds/list/168xdxefP3gGnrTGg2hwJoeRVfmbEuTB5plFTyd6I5Qo/5/public/values?alt=json"
  28. 	println("=============  starting main =============")
  30. 	// res, err := http.Get("https://www.citibikenyc.com/stations/json")
  31. 	res, err := http.Get(url01)
  32. 	if err != nil {
  33. 		panic(err.Error())
  34. 	}
  36. 	// body, err := ioutil.ReadAll(res.Body)
  37. 	// if err != nil {
  38. 	// 	panic(err.Error())
  39. 	// }
  41. 	var m GSSS
  42. 	// err := json.Unmarshal(body, &m)
  43. 	//json.NewDecoder(res.Body).Decode(&m)
  44. 	// json.NewDecoder([]byte(body)).Decode(&m)
  46. 	// json.NewDecoder([]byte(res.Body)).Decode(&m)
  47. 	json.NewDecoder(res.Body).Decode(&m)
  49. 	//err := json.Unmarshal([]byte(body), &m)
  50. 	if err != nil {
  51. 		fmt.Println("Whoops...:", err)
  52. 	}
  54. 	fmt.Println("============  about to print m ============")
  55. 	fmt.Println(m.Feed.TITLE.T)
  56. 	fmt.Println("============  about to print m2 ============")
  57. 	fmt.Println(m.Feed)
  58. 	fmt.Println("============  about to print m3 ============")
  59. 	fmt.Println(m)
  60. 	fmt.Println("============  about to print m4 ============")
  61. }

答案1

得分: 1

如已指出，你对GSSS的定义是错误的。

以下是修正后的代码：

  1. package main
  3. import (
  4.     "encoding/json"
  5.     "fmt"
  6.     "net/http"
  7. )
  9. type GSSS struct {
  10.     Version string   `json:"version"`
  11.     Feed    GSSSfeed `json:"feed"`
  12. }
  14. type GSSSfeed struct {
  15.     TITLE GSSTitle `json:"title"`
  16.     // Entry   []GSSSEntry `json:"entry"`
  17. }
  19. type GSSTitle struct {
  20.     T string `json:"$t"`
  21. }
  23. func main() {
  24.     url01 := "https://spreadsheets.google.com/feeds/list/168xdxefP3gGnrTGg2hwJoeRVfmbEuTB5plFTyd6I5Qo/1/public/values?alt=json"
  25.     //url02 := "https://spreadsheets.google.com/feeds/list/168xdxefP3gGnrTGg2hwJoeRVfmbEuTB5plFTyd6I5Qo/2/public/values?alt=json"
  26.     //url03 := "https://spreadsheets.google.com/feeds/list/168xdxefP3gGnrTGg2hwJoeRVfmbEuTB5plFTyd6I5Qo/3/public/values?alt=json"
  27.     //url04 := "https://spreadsheets.google.com/feeds/list/168xdxefP3gGnrTGg2hwJoeRVfmbEuTB5plFTyd6I5Qo/4/public/values?alt=json"
  28.     //url05 := "https://spreadsheets.google.com/feeds/list/168xdxefP3gGnrTGg2hwJoeRVfmbEuTB5plFTyd6I5Qo/5/public/values?alt=json"
  29.     println("=============  starting main =============")
  31.     // res, err := http.Get("https://www.citibikenyc.com/stations/json")
  32.     res, err := http.Get(url01)
  33.     if err != nil {
  34.         panic(err.Error())
  35.     }
  37.     var m GSSS
  38.     json.NewDecoder(res.Body).Decode(&m)
  40.     if err != nil {
  41.         fmt.Println("Whoops...:", err)
  42.     }
  44.     fmt.Println("============  about to print m3 ============")
  45.     fmt.Println(m)
  46.     fmt.Println("============  about to print m4 ============")
  47. }

希望对你有帮助！

英文:

As already pointed out, your definition of GSSS is wrong.

This works a bit better:

  1. package main
  3. import (
  4.     "encoding/json"
  5.     "fmt"
  6.     "net/http"
  7. )
  9. type GSSS struct {
  10.     Version string `json:"version"`
  11.     Feed GSSSfeed `json:"feed"`
  12. }
  14. type GSSSfeed struct {
  15.     TITLE   GSSTitle `json:"title"`
  16.     // Entry   []GSSSEntry `json:"entry"`
  17. }
  18. type GSSTitle struct {
  19.     T string `json:"$t"`
  20. }
  22. func main() {
  23.     url01 := "https://spreadsheets.google.com/feeds/list/168xdxefP3gGnrTGg2hwJoeRVfmbEuTB5plFTyd6I5Qo/1/public/values?alt=json"
  24.     //url02 := "https://spreadsheets.google.com/feeds/list/168xdxefP3gGnrTGg2hwJoeRVfmbEuTB5plFTyd6I5Qo/2/public/values?alt=json"
  25.     //url03 := "https://spreadsheets.google.com/feeds/list/168xdxefP3gGnrTGg2hwJoeRVfmbEuTB5plFTyd6I5Qo/3/public/values?alt=json"
  26.     //url04 := "https://spreadsheets.google.com/feeds/list/168xdxefP3gGnrTGg2hwJoeRVfmbEuTB5plFTyd6I5Qo/4/public/values?alt=json"
  27.     //url05 := "https://spreadsheets.google.com/feeds/list/168xdxefP3gGnrTGg2hwJoeRVfmbEuTB5plFTyd6I5Qo/5/public/values?alt=json"
  28.     println("=============  starting main =============")
  30.     // res, err := http.Get("https://www.citibikenyc.com/stations/json")
  31.     res, err := http.Get(url01)
  32.     if err != nil {
  33.         panic(err.Error())
  34.     }
  36.     // body, err := ioutil.ReadAll(res.Body)
  37.     // if err != nil {
  38.     //  panic(err.Error())
  39.     // }
  41.     var m GSSS
  42.     // err := json.Unmarshal(body, &m)
  43.     //json.NewDecoder(res.Body).Decode(&m)
  44.     // json.NewDecoder([]byte(body)).Decode(&m)
  46.     // json.NewDecoder([]byte(res.Body)).Decode(&m)
  47.     json.NewDecoder(res.Body).Decode(&m)
  49.     //err := json.Unmarshal([]byte(body), &m)
  50.     if err != nil {
  51.         fmt.Println("Whoops...:", err)
  52.     }
  54.     fmt.Println("============  about to print m3 ============")
  55.     fmt.Println(m)
  56.     fmt.Println("============  about to print m4 ============")
  57. }

huangapple
  • 本文由 发表于 2017年6月28日 20:46:39
  • 转载请务必保留本文链接：https://go.coder-hub.com/44802899.html
  • go
  • google-sheets
  • json
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定