Google

opencollection: 1.0.0
info:
  name: Google Sheets API
  version: 1.0.0
items:
- info:
    name: Get
    type: folder
  items:
  - info:
      name: Google Get Values
      type: http
    http:
      method: GET
      url: https://sheets.googleapis.com/v4/spreadsheets/:spreadsheetId/values/:range
      headers:
      - name: Accept
        value: application/json
      params:
      - name: majorDimension
        value: '{{majorDimension}}'
        type: query
      - name: valueRenderOption
        value: '{{valueRenderOption}}'
        type: query
      - name: dateTimeRenderOption
        value: '{{dateTimeRenderOption}}'
        type: query
      - name: access_token
        value: '{{accessToken}}'
        type: query
        description: OAuth access token.
      - name: alt
        value: '{{alt}}'
        type: query
        description: Data format for response.
      - name: callback
        value: '{{callback}}'
        type: query
        description: JSONP
      - name: fields
        value: '{{fields}}'
        type: query
        description: Selector specifying which fields to include in a partial response.
      - name: key
        value: '{{key}}'
        type: query
        description: API key. Your API key identifies your project and provides you with API access, quota, and reports. Required
          unless you provide an OAuth 2.0 token.
      - name: oauth_token
        value: '{{oauthToken}}'
        type: query
        description: OAuth 2.0 token for the current user.
      - name: prettyPrint
        value: '{{prettyPrint}}'
        type: query
        description: Returns response with indentations and line breaks.
      - name: quotaUser
        value: '{{quotaUser}}'
        type: query
        description: Available to use for quota purposes for server-side applications. Can be any arbitrary string assigned
          to a user, but should not exceed 40 characters.
      - name: upload_protocol
        value: '{{uploadProtocol}}'
        type: query
        description: Upload protocol for media (e.g. "raw", "multipart").
      - name: uploadType
        value: '{{uploadType}}'
        type: query
        description: Legacy upload protocol for media (e.g. "media", "multipart").
      - name: $.xgafv
        value: '{{.Xgafv}}'
        type: query
        description: V1 error format.
      - name: spreadsheetId
        value: '{{spreadsheetId}}'
        type: path
        description: '(Required) '
      - name: range
        value: '{{range}}'
        type: path
        description: '(Required) '
    docs: Returns a range of values from a spreadsheet. The caller must specify the spreadsheet ID and a range.
  - info:
      name: Google Get Sheet
      type: http
    http:
      method: GET
      url: https://sheets.googleapis.com/v4/spreadsheets/:spreadsheetId
      headers:
      - name: Accept
        value: application/json
      params:
      - name: spreadsheetId
        value: '{{spreadsheetId}}'
        type: path
        description: '(Required) '
    docs: 'Returns the spreadsheet at the given ID. The caller must specify the spreadsheet ID. By default, data within grids
      is not returned. You can include grid data in one of 2 ways: * Specify a [field mask](https://developers.google.com/sheets/api/guides/field-masks)
      listing your desired fields using the `fields` URL parameter in HTTP * Set the includeGridData URL parameter to true.
      If a field mask is set, the `includeGridData` parameter is ignored For large spreadsheets, as a best practice, retrieve '
- info:
    name: Update
    type: folder
  items:
  - info:
      name: Google Update Values
      type: http
    http:
      method: PUT
      url: https://sheets.googleapis.com/v4/spreadsheets/:spreadsheetId/values/:range
      headers:
      - name: Content-Type
        value: application/json
      - name: Accept
        value: application/json
      params:
      - name: spreadsheetId
        value: '{{spreadsheetId}}'
        type: path
        description: '(Required) '
      - name: range
        value: '{{range}}'
        type: path
        description: '(Required) '
      body:
        type: json
        data: '{}'
    docs: Sets values in a range of a spreadsheet. The caller must specify the spreadsheet ID, range, and a valueInputOption.
- info:
    name: Append
    type: folder
  items:
  - info:
      name: Google Append Values
      type: http
    http:
      method: POST
      url: https://sheets.googleapis.com/v4/spreadsheets/:spreadsheetId/values/:range:append
      headers:
      - name: Content-Type
        value: application/json
      - name: Accept
        value: application/json
      params:
      - name: spreadsheetId
        value: '{{spreadsheetId}}'
        type: path
        description: '(Required) '
      - name: range
        value: ''
        type: path
      body:
        type: json
        data: '{}'
    docs: Appends values to a spreadsheet. The input range is used to search for existing data and find a "table" within that
      range. Values will be appended to the next row of the table, starting with the first column of the table. See the [guide](/sheets/api/guides/values#appending_values)
      and [sample code](/sheets/api/samples/writing#append_values) for specific details of how tables are detected and data
      is appended. The caller must specify the spreadsheet ID, range, and a valueInputOption. The `valueIn
- info:
    name: Clear
    type: folder
  items:
  - info:
      name: Google Clear Values
      type: http
    http:
      method: POST
      url: https://sheets.googleapis.com/v4/spreadsheets/:spreadsheetId/values/:range:clear
      headers:
      - name: Content-Type
        value: application/json
      - name: Accept
        value: application/json
      params:
      - name: spreadsheetId
        value: '{{spreadsheetId}}'
        type: path
        description: '(Required) '
      - name: range
        value: ''
        type: path
      body:
        type: json
        data: '{}'
    docs: Clears values from a spreadsheet. The caller must specify the spreadsheet ID and range. Only values are cleared
      -- all other properties of the cell (such as formatting, data validation, etc..) are kept.
- info:
    name: Batch
    type: folder
  items:
  - info:
      name: Google Batch Clear Values
      type: http
    http:
      method: POST
      url: https://sheets.googleapis.com/v4/spreadsheets/:spreadsheetId/values:batchClear
      headers:
      - name: Content-Type
        value: application/json
      - name: Accept
        value: application/json
      params:
      - name: spreadsheetId
        value: '{{spreadsheetId}}'
        type: path
        description: '(Required) '
      body:
        type: json
        data: '{}'
    docs: Clears one or more ranges of values from a spreadsheet. The caller must specify the spreadsheet ID and one or more
      ranges. Only values are cleared -- all other properties of the cell (such as formatting and data validation) are kept.
  - info:
      name: Google Batch Clear Values by Data Filter
      type: http
    http:
      method: POST
      url: https://sheets.googleapis.com/v4/spreadsheets/:spreadsheetId/values:batchClearByDataFilter
      headers:
      - name: Content-Type
        value: application/json
      - name: Accept
        value: application/json
      params:
      - name: spreadsheetId
        value: '{{spreadsheetId}}'
        type: path
        description: '(Required) '
      body:
        type: json
        data: '{}'
    docs: Clears one or more ranges of values from a spreadsheet. The caller must specify the spreadsheet ID and one or more
      DataFilters. Ranges matching any of the specified data filters will be cleared. Only values are cleared -- all other
      properties of the cell (such as formatting, data validation, etc..) are kept.
  - info:
      name: Google Get Values Batch
      type: http
    http:
      method: GET
      url: https://sheets.googleapis.com/v4/spreadsheets/:spreadsheetId/values:batchGet
      headers:
      - name: Accept
        value: application/json
      params:
      - name: spreadsheetId
        value: '{{spreadsheetId}}'
        type: path
        description: '(Required) '
    docs: Returns one or more ranges of values from a spreadsheet. The caller must specify the spreadsheet ID and one or more
      ranges.
  - info:
      name: Google Batch Update Values
      type: http
    http:
      method: POST
      url: https://sheets.googleapis.com/v4/spreadsheets/:spreadsheetId/values:batchUpdate
      headers:
      - name: Content-Type
        value: application/json
      - name: Accept
        value: application/json
      params:
      - name: spreadsheetId
        value: '{{spreadsheetId}}'
        type: path
        description: '(Required) '
      body:
        type: json
        data: '{}'
    docs: Sets values in one or more ranges of a spreadsheet. The caller must specify the spreadsheet ID, a valueInputOption,
      and one or more ValueRanges.
  - info:
      name: Google Batch Update Sheets
      type: http
    http:
      method: POST
      url: https://sheets.googleapis.com/v4/spreadsheets/:spreadsheetId:batchUpdate
      headers:
      - name: Content-Type
        value: application/json
      - name: Accept
        value: application/json
      params:
      - name: spreadsheetId
        value: ''
        type: path
      body:
        type: json
        data: '{}'
    docs: Applies one or more updates to the spreadsheet. Each request is validated before being applied. If any request is
      not valid then the entire request will fail and nothing will be applied. Some requests have replies to give you some
      information about how they are applied. The replies will mirror the requests. For example, if you applied 4 updates
      and the 3rd one had a reply, then the response will have 2 empty replies, the actual reply, and another empty reply,
      in that order. Due to the collaborat
- info:
    name: Data
    type: folder
  items:
  - info:
      name: Google Get Values By Data Filter
      type: http
    http:
      method: POST
      url: https://sheets.googleapis.com/v4/spreadsheets/:spreadsheetId/values:batchGetByDataFilter
      headers:
      - name: Content-Type
        value: application/json
      - name: Accept
        value: application/json
      params:
      - name: spreadsheetId
        value: '{{spreadsheetId}}'
        type: path
        description: '(Required) '
      body:
        type: json
        data: '{}'
    docs: Returns one or more ranges of values that match the specified data filters. The caller must specify the spreadsheet
      ID and one or more DataFilters. Ranges that match any of the data filters in the request will be returned.
  - info:
      name: Google Update by Data Filter
      type: http
    http:
      method: POST
      url: https://sheets.googleapis.com/v4/spreadsheets/:spreadsheetId/values:batchUpdateByDataFilter
      headers:
      - name: Content-Type
        value: application/json
      - name: Accept
        value: application/json
      params:
      - name: spreadsheetId
        value: '{{spreadsheetId}}'
        type: path
        description: '(Required) '
      body:
        type: json
        data: '{}'
    docs: Sets values in one or more ranges of a spreadsheet. The caller must specify the spreadsheet ID, a valueInputOption,
      and one or more DataFilterValueRanges.
  - info:
      name: Google Get Sheet by Data Filter
      type: http
    http:
      method: POST
      url: https://sheets.googleapis.com/v4/spreadsheets/:spreadsheetId:getByDataFilter
      headers:
      - name: Content-Type
        value: application/json
      - name: Accept
        value: application/json
      params:
      - name: spreadsheetId
        value: ''
        type: path
      body:
        type: json
        data: '{}'
    docs: 'Returns the spreadsheet at the given ID. The caller must specify the spreadsheet ID. This method differs from GetSpreadsheet
      in that it allows selecting which subsets of spreadsheet data to return by specifying a dataFilters parameter. Multiple
      DataFilters can be specified. Specifying one or more data filters returns the portions of the spreadsheet that intersect
      ranges matched by any of the filters. By default, data within grids is not returned. You can include grid data one of
      2 ways: * Specif'
- info:
    name: Create
    type: folder
  items:
  - info:
      name: Google Create Sheet
      type: http
    http:
      method: POST
      url: https://sheets.googleapis.com/v4/spreadsheets
      headers:
      - name: Content-Type
        value: application/json
      - name: Accept
        value: application/json
      body:
        type: json
        data: '{}'
    docs: Creates a spreadsheet, returning the newly created spreadsheet.
- info:
    name: Copy
    type: folder
  items:
  - info:
      name: Google Copy To Sheet
      type: http
    http:
      method: POST
      url: https://sheets.googleapis.com/v4/spreadsheets/:spreadsheetId/sheets/:sheetId:copyTo
      headers:
      - name: Content-Type
        value: application/json
      - name: Accept
        value: application/json
      params:
      - name: spreadsheetId
        value: '{{spreadsheetId}}'
        type: path
        description: '(Required) '
      - name: sheetId
        value: ''
        type: path
      body:
        type: json
        data: '{}'
    docs: Copies a single sheet from a spreadsheet to another spreadsheet. Returns the properties of the newly created sheet.
- info:
    name: Developer
    type: folder
  items:
  - info:
      name: Google Get Developer Metadata
      type: http
    http:
      method: GET
      url: https://sheets.googleapis.com/v4/spreadsheets/:spreadsheetId/developerMetadata/:metadataId
      headers:
      - name: Accept
        value: application/json
      params:
      - name: spreadsheetId
        value: '{{spreadsheetId}}'
        type: path
        description: '(Required) '
      - name: metadataId
        value: '{{metadataId}}'
        type: path
        description: '(Required) '
    docs: Returns the developer metadata with the specified ID. The caller must specify the spreadsheet ID and the developer
      metadata's unique metadataId.
  - info:
      name: Google Search Developer Metadata
      type: http
    http:
      method: POST
      url: https://sheets.googleapis.com/v4/spreadsheets/:spreadsheetId/developerMetadata:search
      headers:
      - name: Content-Type
        value: application/json
      - name: Accept
        value: application/json
      params:
      - name: spreadsheetId
        value: '{{spreadsheetId}}'
        type: path
        description: '(Required) '
      body:
        type: json
        data: '{}'
    docs: Returns all developer metadata matching the specified DataFilter. If the provided DataFilter represents a DeveloperMetadataLookup
      object, this will return all DeveloperMetadata entries selected by it. If the DataFilter represents a location in a
      spreadsheet, this will return all developer metadata associated with locations intersecting that region.
bundled: true