CODEWITHSUNDEEP
google-apis-explorer
Raymond Natio
Raymond Natio

Reputation: 672

Google spreadsheets.create with merged cells

Create google spreadsheets api test on: https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/create

{
  "sheets": [
    {
      "merges": [
        {
          "sheetId": 0,
          "startColumnIndex": 0,
          "startRowIndex": 0,
          "endColumnIndex": 12,
          "endRowIndex": 3
        }
      ]
    }
  ]
}

So i tried using google spreadsheets create with merged cells but it returned an error of: 

{
  "error": {
    "code": 400,
    "message": "Invalid sheets[0].merges[0]: No grid with id: 0",
    "status": "INVALID_ARGUMENT"
  }
}

Anyone know where I got it wrong? Thank you.

Upvotes: 0

Views: 301

Answers (1)

Tanaike
Tanaike

Reputation: 201673

How about this request body? It sets sheetId for properties.

{
  "sheets": 
  [
    {
      "merges": 
      [
        {
          "sheetId": 0,
          "startColumnIndex": 0,
          "startRowIndex": 0,
          "endColumnIndex": 12,
          "endRowIndex": 3
        }
      ],
      "properties": 
      {
        "sheetId": 0
      }
    }
  ]
}

Reference :

Upvotes: 1

Related Questions