find_apisBrowse and filter every API in the catalog.
get_api_artifactsOne API's artifacts, grouped by type.
get_openapiThe primary OpenAPI for this API.
find_similar_apisAPIs that look like this one.
apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
resolveTurn a domain, URL or GitHub org into the provider it belongs to.
find_cohortsEvery scored population of providers in the catalog.

All 92 tools →

Call it yourself

curl for this page

This API

curl "https://apis.io/api/v1/apis/google-copy-api"

All apis

curl "https://apis.io/api/v1/apis?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.

OpenAPI Specification

openapi: 3.2.0
info:
  title: Google Sheets Copy API
  description: The Google Sheets API is a RESTful interface that lets you read and modify a spreadsheet's data..
  version: 1.0.0
servers:
- url: https://sheets.googleapis.com
  description: Google Sheets API Server
security:
- oauth2Auth: []
tags:
- name: Copy
  description: Operations related to Copy
paths:
  /v4/spreadsheets/{spreadsheetId}/sheets/{sheetId}:copyTo:
    post:
      tags:
      - Copy
      summary: Google Copy To Sheet
      description: Copies a single sheet from a spreadsheet to another spreadsheet. Returns the properties of the newly created sheet.
      security:
      - oauth2Auth: []
      parameters:
      - name: Content-Type
        in: header
        schema:
          type: string
        example: application/json
      - name: Accept
        in: header
        schema:
          type: string
        example: application/json
      - name: spreadsheetId
        in: path
        schema:
          type: string
        required: true
        description: '(Required) '
        example: '{{spreadsheetId}}'
      - name: sheetId
        in: path
        schema:
          type: string
        required: true
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/SpreadsheetsSheetsPostRequest'
      responses:
        '200':
          description: OK
          headers:
            Content-Type:
              schema:
                type: string
                example: application/json
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/SpreadsheetsSheetsPostResponse'
              examples:
                SpreadsheetsSheetsPostResponseExample:
                  $ref: '#/components/examples/SpreadsheetsSheetsPostResponseExample'
      x-api-evangelist-processing:
        ChooseTags: true
      x-microcks-operation:
        delay: 100
        dispatcher: FALLBACK
        dispatcherRules: SpreadsheetsSheetsPostResponseExample
      operationId: postV4SpreadsheetsBySpreadsheetIdSheets{sheetId}:copyTo
      x-operation-id-source: derived
components:
  schemas:
    SpreadsheetsSheetsPostRequest:
      description: SpreadsheetsSheetsPostRequest schema
      type: object
      example:
        destinationSpreadsheetId: eu fugiat
    SpreadsheetsSheetsPostResponseTabColor:
      description: SpreadsheetsSheetsPostResponseTabColor schema
      type: object
      properties:
        alpha:
          type: number
        blue:
          type: number
        green:
          type: number
        red:
          type: number
    SpreadsheetsSheetsPostResponseTabColorStyle:
      description: SpreadsheetsSheetsPostResponseTabColorStyle schema
      type: object
      properties:
        rgbColor:
          $ref: '#/components/schemas/SpreadsheetsSheetsPostResponseTabColorStyleRgbColor'
        themeColor:
          type: string
    SpreadsheetsSheetsPostResponseTabColorStyleRgbColor:
      description: SpreadsheetsSheetsPostResponseTabColorStyleRgbColor schema
      type: object
      properties:
        alpha:
          type: number
        blue:
          type: number
        green:
          type: number
        red:
          type: number
    SpreadsheetsSheetsPostResponseDataSourceSheetPropertiesDataExecutionStatus:
      description: SpreadsheetsSheetsPostResponseDataSourceSheetPropertiesDataExecutionStatus schema
      type: object
      properties:
        errorCode:
          type: string
        errorMessage:
          type: string
        lastRefreshTime:
          type: string
        state:
          type: string
    SpreadsheetsSheetsPostResponseGridProperties:
      description: SpreadsheetsSheetsPostResponseGridProperties schema
      type: object
      properties:
        columnCount:
          type: integer
        columnGroupControlAfter:
          type: boolean
        frozenColumnCount:
          type: integer
        frozenRowCount:
          type: integer
        hideGridlines:
          type: boolean
        rowCount:
          type: integer
        rowGroupControlAfter:
          type: boolean
    SpreadsheetsSheetsPostResponse:
      description: SpreadsheetsSheetsPostResponse schema
      type: object
      properties:
        dataSourceSheetProperties:
          $ref: '#/components/schemas/SpreadsheetsSheetsPostResponseDataSourceSheetProperties'
        gridProperties:
          $ref: '#/components/schemas/SpreadsheetsSheetsPostResponseGridProperties'
        hidden:
          type: boolean
        index:
          type: integer
        rightToLeft:
          type: boolean
        sheetId:
          type: integer
        sheetType:
          type: string
        tabColor:
          $ref: '#/components/schemas/SpreadsheetsSheetsPostResponseTabColor'
        tabColorStyle:
          $ref: '#/components/schemas/SpreadsheetsSheetsPostResponseTabColorStyle'
        title:
          type: string
    SpreadsheetsSheetsPostResponseDataSourceSheetProperties:
      description: SpreadsheetsSheetsPostResponseDataSourceSheetProperties schema
      type: object
      properties:
        columns:
          type: array
          items:
            type: object
            properties:
              formula:
                type: string
              reference:
                type: object
                properties:
                  name:
                    type: string
        dataExecutionStatus:
          $ref: '#/components/schemas/SpreadsheetsSheetsPostResponseDataSourceSheetPropertiesDataExecutionStatus'
        dataSourceId:
          type: string
  examples:
    SpreadsheetsSheetsPostResponseExample:
      summary: Successful 200 response
      value:
        dataSourceSheetProperties:
          columns:
          - formula: id et ex reprehenderit
            reference:
              name: minim in
          - formula: culpa sint et
            reference:
              name: velit
          dataExecutionStatus:
            errorCode: DATA_EXECUTION_ERROR_CODE_UNSPECIFIED
            errorMessage: officia incididunt ipsum
            lastRefreshTime: incidid
            state: DATA_EXECUTION_STATE_UNSPECIFIED
          dataSourceId: in Ut dolore sunt
        gridProperties:
          columnCount: -39728991
          columnGroupControlAfter: false
          frozenColumnCount: -34736494
          frozenRowCount: -70465816
          hideGridlines: false
          rowCount: 14366497
          rowGroupControlAfter: true
        hidden: true
        index: 34136900
        rightToLeft: false
        sheetId: -19636375
        sheetType: OBJECT
        tabColor:
          alpha: 9104888.265400872
          blue: -38148126.52548318
          green: -49770222.52454422
          red: 11795874.261146635
        tabColorStyle:
          rgbColor:
            alpha: -27908346.978851378
            blue: 85938099.78494695
            green: -35336997.9560505
            red: -70387559.7048357
          themeColor: ACCENT2
        title: nisi reprehenderit cupidatat enim
  securitySchemes:
    oauth2Auth:
      type: http
      scheme: oauth2