Google AppSheet Apps API

openapi: 3.1.0
info:
  title: Google AppSheet Apps API
  description: The Google AppSheet API enables programmatic access to AppSheet applications, allowing developers to add, update, delete, and find records in AppSheet tables, as well as invoke predefined AppSheet actions via a REST interface.
  version: 2.0.0
  contact:
    name: Google
    url: https://support.google.com/appsheet/answer/10105398
servers:
- url: https://api.appsheet.com/api/v2
security:
- ApplicationAccessKey: []
tags:
- name: Apps
paths:
  /apps/{appId}/tables/{tableName}/Action:
    post:
      operationId: invokeAction
      summary: Google AppSheet Invoke Table Action
      description: Performs an action on a table in an AppSheet app. Supports Add, Delete, Edit, Find, and custom Action operations.
      parameters:
      - name: appId
        in: path
        required: true
        description: The unique identifier of the AppSheet application.
        schema:
          type: string
      - name: tableName
        in: path
        required: true
        description: The name of the table to perform the action on.
        schema:
          type: string
      - name: applicationAccessKey
        in: query
        description: The application access key for authentication.
        schema:
          type: string
      requestBody:
        required: true
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/ActionRequest'
      responses:
        '200':
          description: Successful response
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ActionResponse'
        '400':
          description: Bad request
        '401':
          description: Unauthorized
        '404':
          description: Not found
      tags:
      - Apps
components:
  schemas:
    ActionResponse:
      type: object
      properties:
        Rows:
          type: array
          description: The rows returned from the action.
          items:
            type: object
            additionalProperties: true
    ActionRequest:
      type: object
      required:
      - Action
      - Properties
      properties:
        Action:
          type: string
          description: The action to perform. One of Add, Delete, Edit, Find, or a custom action name.
          enum:
          - Add
          - Delete
          - Edit
          - Find
        Properties:
          type: object
          description: Properties for the action including locale and timezone.
          properties:
            Locale:
              type: string
            Timezone:
              type: string
        Rows:
          type: array
          description: The rows to add, edit, delete, or the filter criteria for Find operations.
          items:
            type: object
            additionalProperties: true
  securitySchemes:
    ApplicationAccessKey:
      type: apiKey
      in: header
      name: ApplicationAccessKey