Sign in

v1

latestOpenAPI 3.0.32026-08-061874701.5 MB
columns

Add columns

Inserts one or more columns into the specified sheet.

Note: This operation can also be performed using a simple upload or a multipart upload. For more information, see Post an Attachment.

post/sheets/{sheetId}/columns

Headers

Content-Typestring

Required for POST and PUT requests. Defines the structure for the request body.

Request body

OR

Example request

{
  "id": 4567890123,
  "width": 150,
  "autoNumberFormat": {
    "fill": "",
    "prefix": "",
    "startingNumber": 1,
    "suffix": ""
  }
}

Response

Returns Result object containing the newly created columns -- either a single Column object or an array of Column objects, corresponding to what was specified in the request.

message'PARTIAL_SUCCESS' | 'SUCCESS'

Message that indicates the outcome of the request. (One of SUCCESS or PARTIAL_SUCCESS.)

resultCode0 | 3
  • '0' Success
  • '3' Partial Success of Bulk Operation

Example response

{
  "message": "SUCCESS",
  "result": [
    {
      "id": 4567890123,
      "width": 150,
      "tags": []
    }
  ]
}