Google Sheets API v4附加数据变得错误，请求400错误 [英] Google Sheets API v4 Appending data getting bad request 400 error

问题描述

我正在尝试在表格行中追加行，我试图在2列的单行中放置2个字符串.

I am trying to append Sheets row, I am trying to put 2 Strings in single row in 2 columns.

这是代码:

String range = "Write!A2:E200";
String spreadsheetId = SPREADSHEET_ID;
List<List<Object>> values = Arrays.asList(Arrays.asList());

ValueRange body = new ValueRange().setValues(values);
AppendValuesResponse result = service.spreadsheets()
    .values()
    .append(spreadsheetId, range, body)
    .setValueInputOption("USER_ENTERED")
    .execute();

当我尝试添加时:

values.add(new ArrayList<Object>(ListOfMyTwoStrings));

我收到空错误.

更新:

我添加了:

List<Object> lists = new ArrayList<>();
lists.add(ListOne);
lists.add(ListTwo);

List<List<Object>> values = new ArrayList<>();
values.add(lists);

其中ListOne和ListTwo是List<String>并带有要添加到工作表中的数据，但是当我尝试执行时，我得到了:

Where ListOne and ListTwo are List<String> with the data which I want to append in the sheet, but when I try to execute I am getting:

400 Bad Request
{
  "code":400,
  "errors":[
    {
      "domain":"global",
      "message":"Invalid values[1][0]: list_value {\n}\n",
      "reason":"badRequest"
    }
  ],
  "message":"Invalid values[1][0]: list_value {\n}\n",
  "status":"INVALID_ARGUMENT"
}

有人可以帮我解决这个问题吗? 谢谢，祝你有美好的一天！

Can someone please help me to fix it? Thank you and have a nice day!

推荐答案

找到了解决方案，它对我有用:

Found solution, this is working for me:

List<Object> lists = new ArrayList<>();

lists.add("String 1");
lists.add("String 2");

List<List<Object>> values = new ArrayList<>();
values.add(lists);

这会将字符串1"附加到A1，并将字符串2"附加到A2.

This will append "String 1" to A1 and "String 2" to A2.

感谢abielita的小费.

Thanks abielita for tip.

这篇关于Google Sheets API v4附加数据变得错误，请求400错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！