PowerShift™ Oracle · GPT-Aktionen

{
  "openapi": "3.0.0",
  "info": {
    "title": "Google Sheets API",
    "description": "API for appending a row to a Google Sheet.",
    "version": "1.0.0"
  },
  "servers": [
    {
      "url": "https://sheets.googleapis.com/v4",
      "description": "Google Sheets API server"
    }
  ],
  "paths": {
    "/spreadsheets/{spreadsheetId}/values/{range}:append": {
      "post": {
        "operationId": "appendRow",
        "summary": "Append a row to a Google Sheet",
        "description": "Appends values to a spreadsheet.",
        "parameters": [
          {
            "name": "spreadsheetId",
            "in": "path",
            "required": true,
            "description": "The ID of the spreadsheet",
            "schema": {
              "type": "string"
            }
          },
          {
            "name": "range",
            "in": "path",
            "required": true,
            "description": "The A1 notation of the range to append",
            "schema": {
              "type": "string"
            }
          },
          {
            "name": "valueInputOption",
            "in": "query",
            "description": "How the input data should be interpreted",
            "schema": {
              "type": "string",
              "enum": [
                "RAW",
                "USER_ENTERED"
              ]
            }
          },
          {
            "name": "insertDataOption",
            "in": "query",
            "description": "How the data should be inserted",
            "schema": {
              "type": "string",
              "enum": [
                "OVERWRITE",
                "INSERT_ROWS"
              ]
            }
          }
        ],
        "requestBody": {
          "required": true,
          "content": {
            "application/json": {
              "schema": {
                "type": "object",
                "properties": {
                  "values": {
                    "type": "array",
                    "items": {
                      "type": "array",
                      "items": {
                        "type": "string"
                      }
                    }
                  }
                }
              }
            }
          }
        },
        "responses": {
          "200": {
            "description": "Successfully appended the row",
            "content": {
              "application/json": {
                "schema": {
                  "type": "object",
                  "properties": {
                    "spreadsheetId": {
                      "type": "string"
                    },
                    "tableRange": {
                      "type": "string"
                    },
                    "updates": {
                      "type": "object",
                      "properties": {
                        "spreadsheetId": {
                          "type": "string"
                        },
                        "updatedRange": {
                          "type": "string"
                        },
                        "updatedRows": {
                          "type": "integer"
                        },
                        "updatedColumns": {
                          "type": "integer"
                        },
                        "updatedCells": {
                          "type": "integer"
                        }
                      }
                    }
                  }
                }
              }
            }
          }
        }
      }
    }
  }
}