我试图插入或更新数据到谷歌电子表格。我正在使用golang模块订阅的包"google.golang.org/api/option"one_answers"google.golang.org/api/sheets/v4">
我得到的错误如下:- 1.
got HTTP response code 404 with body: <!DOCTYPE html>n<html lang=en>n <meta charset=utf-8>n <meta name=viewport content="initial-scale=1, minimum-scale=1, width=device-width">n <title>Error 404 (Not Found)!!1</title>n <style>n *{margin:0;padding:0}html,code{font:15px/22px arial,sans-serif}html{background:#fff;color:#222;padding:15px}body{margin:7% auto 0;max-width:390px;min-height:180px;padding:30px 0 15px}* > body{background:url(//www.google.com/images/errors/robot.png) 100% 5px no-repeat;padding-right:205px}p{margin:11px 0 22px;overflow:hidden}ins{color:#777;text-decoration:none}a img{border:0}@media screen and (max-width:772px){body{background:none;margin-top:0;max-width:none;padding-right:0}}#logo{background:url(//www.google.com/images/branding/googlelogo/1x/googlelogo_color_150x54dp.png) no-repeat;margin-left:-5px}@media only screen and (min-resolution:192dpi){#logo{background:url(//www.google.com/images/branding/googlelogo/2x/googlelogo_color_150x54dp.png) no-repeat 0% 0%/100% 100%;-moz-border-image:url(//www.google.com/images/branding/googlelogo/2x/googlelogo_color_150x54dp.png) 0}}@media only screen and (-webkit-min-device-pixel-ratio:2){#logo{background:url(//www.google.com/images/branding/googlelogo/2x/googlelogo_color_150x54dp.png) no-repeat;-webkit-background-size:100% 100%}}#logo{display:inline-block;height:54px;width:150px}n </style>n <a href=//www.google.com/><span id=logo aria-label=Google></span></a>n <p><b>404.</b> <ins>That’s an error.</ins>n <p>The requested URL <code>/v4/spreadsheets/11dlAKQVB2Hb88fPtg7B9sdPkjmhbNxY8L6H-F1ZY5FI/values/:append?alt=json&insertDataOption=INSERT_ROWS&prettyPrint=false&valueInputOption=USER_ENTERED</code> was not found on this server. <ins>That’s all we know.</ins>n"
当我尝试通过动态sheetname。2 .
Error while updating records error: googleapi: Error 400: Unable to parse range: 655963475, badRequest"}
尝试使用sheid
如何在golang中使用sheetname, sheetid和spreadsheetid插入或更新值到googlsheet .
下面是错误情况2的代码:-
func SaveRecords(reqId string, credentials, tokenConfig []byte, spreadsheetId, sheetname string, records [][]interface{}) error {
ctx := context.Background()
config, err := google.ConfigFromJSON(credentials, "https://www.googleapis.com/auth/spreadsheets")
if err != nil {
return err
}
token := oauth2.Token{}
json.Unmarshal(tokenConfig, &token)
client := config.Client(ctx, &token)
srv, err := sheets.NewService(ctx, option.WithHTTPClient(client))
if err != nil {
log.Print(err)
return err
}
valueInputOption := "USER_ENTERED"
insertDataOption := "INSERT_ROWS"
rb := &sheets.ValueRange{
Values: records,
}
response, err := srv.Spreadsheets.Values.Append(spreadsheetId, sheetname, rb).ValueInputOption(valueInputOption).InsertDataOption(insertDataOption).Context(ctx).Do()
if err != nil || response.HTTPStatusCode != 200 {
return err
}
return nil
}
下面是错误情况1的代码:-
func SaveRecords(reqId string, credentials, tokenConfig []byte, spreadsheetId, sheetname string,sheetid string, records [][]interface{}) error {
ctx := context.Background()
config, err := google.ConfigFromJSON(credentials, "https://www.googleapis.com/auth/spreadsheets")
if err != nil {
return err
}
token := oauth2.Token{}
json.Unmarshal(tokenConfig, &token)
client := config.Client(ctx, &token)
srv, err := sheets.NewService(ctx, option.WithHTTPClient(client))
if err != nil {
log.Print(err)
return err
}
valueInputOption := "USER_ENTERED"
insertDataOption := "INSERT_ROWS"
rb := &sheets.ValueRange{
Values: records,
}
response, err := srv.Spreadsheets.Values.Append(spreadsheetId, sheetid, rb).ValueInputOption(valueInputOption).InsertDataOption(insertDataOption).Context(ctx).Do()
if err != nil || response.HTTPStatusCode != 200 {
return err
}
return nil
}
我相信你的目标是这样的。
- 您希望使用googleapi为golang将
records
的值附加到电子表格中。- 您希望在这种情况下使用工作表ID。
- 您已经能够使用表格API获取和输入值到谷歌电子表格。
在这种情况下,下面的修改如何?
不幸的是,页ID不能直接用于srv.Spreadsheets.Values.Append()
。我认为这就是你问题的原因。因此,在本例中,首先需要将工作表ID转换为工作表名称。
修改脚本:
:
valueInputOption := "USER_ENTERED"
insertDataOption := "INSERT_ROWS"
rb := &sheets.ValueRange{
Values: records,
}
response, err := srv.Spreadsheets.Values.Append(spreadsheetId, sheetname, rb).ValueInputOption(valueInputOption).InsertDataOption(insertDataOption).Context(ctx).Do()
if err != nil || response.HTTPStatusCode != 200 {
return err
}
:
sheetid := 0 // Please set sheet ID.
spreadsheetId := "###" // Please set Spreadsheet ID
records := [][]interface{}{{"a1", "b1", "c1"}} // This is a sample value.
// 1. Convert sheet ID to sheet name.
response1, err := srv.Spreadsheets.Get(spreadsheetId).Fields("sheets(properties(sheetId,title))").Do()
if err != nil || response1.HTTPStatusCode != 200 {
return err
}
sheetName := ""
for _, v := range response1.Sheets {
prop := v.Properties
sheetID := prop.SheetId
if sheetID == int64(sheetid) {
sheetName = prop.Title
break
}
}
// 2. Append value to the sheet.
valueInputOption := "USER_ENTERED"
insertDataOption := "INSERT_ROWS"
rb := &sheets.ValueRange{
Values: records,
}
response2, err := srv.Spreadsheets.Values.Append(spreadsheetId, sheetName, rb).ValueInputOption(valueInputOption).InsertDataOption(insertDataOption).Context(ctx).Do()
if err != nil || response2.HTTPStatusCode != 200 {
return err
}
- 当这个脚本运行时,工作表ID被转换为工作表名称。并且,该值被附加到工作表中。
注意:
如果可以直接使用表名,脚本将变成如下所示:
sheetName := "Sheet1" // Please set sheet name. spreadsheetId := "###" // Please set Spreadsheet ID records := [][]interface{}{{"a1", "b1", "c1"}} // This is a sample value. valueInputOption := "USER_ENTERED" insertDataOption := "INSERT_ROWS" rb := &sheets.ValueRange{ Values: records, } response2, err := srv.Spreadsheets.Values.Append(spreadsheetId, sheetName, rb).ValueInputOption(valueInputOption).InsertDataOption(insertDataOption).Context(ctx).Do() if err != nil || response2.HTTPStatusCode != 200 { return err }
引用:
- 方法:spreadsheets.get
- 方法:spreadsheets.values.append