All Downloads are FREE. Search and download functionalities are using the official Maven repository.

com.google.api.services.sheets.v4.Sheets Maven / Gradle / Ivy

The newest version!
/*
 * Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except
 * in compliance with the License. You may obtain a copy of the License at
 *
 * http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software distributed under the License
 * is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express
 * or implied. See the License for the specific language governing permissions and limitations under
 * the License.
 */
/*
 * This code was generated by https://github.com/googleapis/google-api-java-client-services/
 * Modify at your own risk.
 */

package com.google.api.services.sheets.v4;

/**
 * Service definition for Sheets (v4).
 *
 * 

* Reads and writes Google Sheets. *

* *

* For more information about this service, see the * API Documentation *

* *

* This service uses {@link SheetsRequestInitializer} to initialize global parameters via its * {@link Builder}. *

* * @since 1.3 * @author Google, Inc. */ @SuppressWarnings("javadoc") public class Sheets extends com.google.api.client.googleapis.services.json.AbstractGoogleJsonClient { // Note: Leave this static initializer at the top of the file. static { com.google.api.client.util.Preconditions.checkState( (com.google.api.client.googleapis.GoogleUtils.MAJOR_VERSION == 1 && (com.google.api.client.googleapis.GoogleUtils.MINOR_VERSION >= 32 || (com.google.api.client.googleapis.GoogleUtils.MINOR_VERSION == 31 && com.google.api.client.googleapis.GoogleUtils.BUGFIX_VERSION >= 1))) || com.google.api.client.googleapis.GoogleUtils.MAJOR_VERSION >= 2, "You are currently running with version %s of google-api-client. " + "You need at least version 1.31.1 of google-api-client to run version " + "2.0.0 of the Google Sheets API library.", com.google.api.client.googleapis.GoogleUtils.VERSION); } /** * The default encoded root URL of the service. This is determined when the library is generated * and normally should not be changed. * * @since 1.7 */ public static final String DEFAULT_ROOT_URL = "https://sheets.googleapis.com/"; /** * The default encoded mTLS root URL of the service. This is determined when the library is generated * and normally should not be changed. * * @since 1.31 */ public static final String DEFAULT_MTLS_ROOT_URL = "https://sheets.mtls.googleapis.com/"; /** * The default encoded service path of the service. This is determined when the library is * generated and normally should not be changed. * * @since 1.7 */ public static final String DEFAULT_SERVICE_PATH = ""; /** * The default encoded batch path of the service. This is determined when the library is * generated and normally should not be changed. * * @since 1.23 */ public static final String DEFAULT_BATCH_PATH = "batch"; /** * The default encoded base URL of the service. This is determined when the library is generated * and normally should not be changed. */ public static final String DEFAULT_BASE_URL = DEFAULT_ROOT_URL + DEFAULT_SERVICE_PATH; /** * Constructor. * *

* Use {@link Builder} if you need to specify any of the optional parameters. *

* * @param transport HTTP transport, which should normally be: *
    *
  • Google App Engine: * {@code com.google.api.client.extensions.appengine.http.UrlFetchTransport}
  • *
  • Android: {@code newCompatibleTransport} from * {@code com.google.api.client.extensions.android.http.AndroidHttp}
  • *
  • Java: {@link com.google.api.client.googleapis.javanet.GoogleNetHttpTransport#newTrustedTransport()} *
  • *
* @param jsonFactory JSON factory, which may be: *
    *
  • Jackson: {@code com.google.api.client.json.jackson2.JacksonFactory}
  • *
  • Google GSON: {@code com.google.api.client.json.gson.GsonFactory}
  • *
  • Android Honeycomb or higher: * {@code com.google.api.client.extensions.android.json.AndroidJsonFactory}
  • *
* @param httpRequestInitializer HTTP request initializer or {@code null} for none * @since 1.7 */ public Sheets(com.google.api.client.http.HttpTransport transport, com.google.api.client.json.JsonFactory jsonFactory, com.google.api.client.http.HttpRequestInitializer httpRequestInitializer) { this(new Builder(transport, jsonFactory, httpRequestInitializer)); } /** * @param builder builder */ Sheets(Builder builder) { super(builder); } @Override protected void initialize(com.google.api.client.googleapis.services.AbstractGoogleClientRequest httpClientRequest) throws java.io.IOException { super.initialize(httpClientRequest); } /** * An accessor for creating requests from the Spreadsheets collection. * *

The typical use is:

*
   *   {@code Sheets sheets = new Sheets(...);}
   *   {@code Sheets.Spreadsheets.List request = sheets.spreadsheets().list(parameters ...)}
   * 
* * @return the resource collection */ public Spreadsheets spreadsheets() { return new Spreadsheets(); } /** * The "spreadsheets" collection of methods. */ public class Spreadsheets { /** * 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 collaborative nature of spreadsheets, it is not guaranteed that the spreadsheet will * reflect exactly your changes after this completes, however it is guaranteed that the updates in * the request will be applied together atomically. Your changes may be altered with respect to * collaborator changes. If there are no collaborators, the spreadsheet should reflect your changes. * * Create a request for the method "spreadsheets.batchUpdate". * * This request holds the parameters needed by the sheets server. After setting any optional * parameters, call the {@link BatchUpdate#execute()} method to invoke the remote operation. * * @param spreadsheetId The spreadsheet to apply the updates to. * @param content the {@link com.google.api.services.sheets.v4.model.BatchUpdateSpreadsheetRequest} * @return the request */ public BatchUpdate batchUpdate(java.lang.String spreadsheetId, com.google.api.services.sheets.v4.model.BatchUpdateSpreadsheetRequest content) throws java.io.IOException { BatchUpdate result = new BatchUpdate(spreadsheetId, content); initialize(result); return result; } public class BatchUpdate extends SheetsRequest { private static final String REST_PATH = "v4/spreadsheets/{spreadsheetId}:batchUpdate"; /** * 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 collaborative nature of spreadsheets, it is not guaranteed that the * spreadsheet will reflect exactly your changes after this completes, however it is guaranteed * that the updates in the request will be applied together atomically. Your changes may be * altered with respect to collaborator changes. If there are no collaborators, the spreadsheet * should reflect your changes. * * Create a request for the method "spreadsheets.batchUpdate". * * This request holds the parameters needed by the the sheets server. After setting any optional * parameters, call the {@link BatchUpdate#execute()} method to invoke the remote operation.

* {@link * BatchUpdate#initialize(com.google.api.client.googleapis.services.AbstractGoogleClientRequest)} * must be called to initialize this instance immediately after invoking the constructor.

* * @param spreadsheetId The spreadsheet to apply the updates to. * @param content the {@link com.google.api.services.sheets.v4.model.BatchUpdateSpreadsheetRequest} * @since 1.13 */ protected BatchUpdate(java.lang.String spreadsheetId, com.google.api.services.sheets.v4.model.BatchUpdateSpreadsheetRequest content) { super(Sheets.this, "POST", REST_PATH, content, com.google.api.services.sheets.v4.model.BatchUpdateSpreadsheetResponse.class); this.spreadsheetId = com.google.api.client.util.Preconditions.checkNotNull(spreadsheetId, "Required parameter spreadsheetId must be specified."); } @Override public BatchUpdate set$Xgafv(java.lang.String $Xgafv) { return (BatchUpdate) super.set$Xgafv($Xgafv); } @Override public BatchUpdate setAccessToken(java.lang.String accessToken) { return (BatchUpdate) super.setAccessToken(accessToken); } @Override public BatchUpdate setAlt(java.lang.String alt) { return (BatchUpdate) super.setAlt(alt); } @Override public BatchUpdate setCallback(java.lang.String callback) { return (BatchUpdate) super.setCallback(callback); } @Override public BatchUpdate setFields(java.lang.String fields) { return (BatchUpdate) super.setFields(fields); } @Override public BatchUpdate setKey(java.lang.String key) { return (BatchUpdate) super.setKey(key); } @Override public BatchUpdate setOauthToken(java.lang.String oauthToken) { return (BatchUpdate) super.setOauthToken(oauthToken); } @Override public BatchUpdate setPrettyPrint(java.lang.Boolean prettyPrint) { return (BatchUpdate) super.setPrettyPrint(prettyPrint); } @Override public BatchUpdate setQuotaUser(java.lang.String quotaUser) { return (BatchUpdate) super.setQuotaUser(quotaUser); } @Override public BatchUpdate setUploadType(java.lang.String uploadType) { return (BatchUpdate) super.setUploadType(uploadType); } @Override public BatchUpdate setUploadProtocol(java.lang.String uploadProtocol) { return (BatchUpdate) super.setUploadProtocol(uploadProtocol); } /** The spreadsheet to apply the updates to. */ @com.google.api.client.util.Key private java.lang.String spreadsheetId; /** The spreadsheet to apply the updates to. */ public java.lang.String getSpreadsheetId() { return spreadsheetId; } /** The spreadsheet to apply the updates to. */ public BatchUpdate setSpreadsheetId(java.lang.String spreadsheetId) { this.spreadsheetId = spreadsheetId; return this; } @Override public BatchUpdate set(String parameterName, Object value) { return (BatchUpdate) super.set(parameterName, value); } } /** * Creates a spreadsheet, returning the newly created spreadsheet. * * Create a request for the method "spreadsheets.create". * * This request holds the parameters needed by the sheets server. After setting any optional * parameters, call the {@link Create#execute()} method to invoke the remote operation. * * @param content the {@link com.google.api.services.sheets.v4.model.Spreadsheet} * @return the request */ public Create create(com.google.api.services.sheets.v4.model.Spreadsheet content) throws java.io.IOException { Create result = new Create(content); initialize(result); return result; } public class Create extends SheetsRequest { private static final String REST_PATH = "v4/spreadsheets"; /** * Creates a spreadsheet, returning the newly created spreadsheet. * * Create a request for the method "spreadsheets.create". * * This request holds the parameters needed by the the sheets server. After setting any optional * parameters, call the {@link Create#execute()} method to invoke the remote operation.

{@link * Create#initialize(com.google.api.client.googleapis.services.AbstractGoogleClientRequest)} must * be called to initialize this instance immediately after invoking the constructor.

* * @param content the {@link com.google.api.services.sheets.v4.model.Spreadsheet} * @since 1.13 */ protected Create(com.google.api.services.sheets.v4.model.Spreadsheet content) { super(Sheets.this, "POST", REST_PATH, content, com.google.api.services.sheets.v4.model.Spreadsheet.class); } @Override public Create set$Xgafv(java.lang.String $Xgafv) { return (Create) super.set$Xgafv($Xgafv); } @Override public Create setAccessToken(java.lang.String accessToken) { return (Create) super.setAccessToken(accessToken); } @Override public Create setAlt(java.lang.String alt) { return (Create) super.setAlt(alt); } @Override public Create setCallback(java.lang.String callback) { return (Create) super.setCallback(callback); } @Override public Create setFields(java.lang.String fields) { return (Create) super.setFields(fields); } @Override public Create setKey(java.lang.String key) { return (Create) super.setKey(key); } @Override public Create setOauthToken(java.lang.String oauthToken) { return (Create) super.setOauthToken(oauthToken); } @Override public Create setPrettyPrint(java.lang.Boolean prettyPrint) { return (Create) super.setPrettyPrint(prettyPrint); } @Override public Create setQuotaUser(java.lang.String quotaUser) { return (Create) super.setQuotaUser(quotaUser); } @Override public Create setUploadType(java.lang.String uploadType) { return (Create) super.setUploadType(uploadType); } @Override public Create setUploadProtocol(java.lang.String uploadProtocol) { return (Create) super.setUploadProtocol(uploadProtocol); } @Override public Create set(String parameterName, Object value) { return (Create) super.set(parameterName, value); } } /** * 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 only the specific spreadsheet fields that you want. To retrieve only subsets * of spreadsheet data, use the ranges URL parameter. Ranges are specified using [A1 * notation](/sheets/api/guides/concepts#cell). You can define a single cell (for example, `A1`) or * multiple cells (for example, `A1:D5`). You can also get cells from other sheets within the same * spreadsheet (for example, `Sheet2!A1:C4`) or retrieve multiple ranges at once (for example, * `?ranges=A1:D5&ranges=Sheet2!A1:C4`). Limiting the range returns only the portions of the * spreadsheet that intersect the requested ranges. * * Create a request for the method "spreadsheets.get". * * This request holds the parameters needed by the sheets server. After setting any optional * parameters, call the {@link Get#execute()} method to invoke the remote operation. * * @param spreadsheetId The spreadsheet to request. * @return the request */ public Get get(java.lang.String spreadsheetId) throws java.io.IOException { Get result = new Get(spreadsheetId); initialize(result); return result; } public class Get extends SheetsRequest { private static final String REST_PATH = "v4/spreadsheets/{spreadsheetId}"; /** * 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 only the specific spreadsheet fields that you want. * To retrieve only subsets of spreadsheet data, use the ranges URL parameter. Ranges are * specified using [A1 notation](/sheets/api/guides/concepts#cell). You can define a single cell * (for example, `A1`) or multiple cells (for example, `A1:D5`). You can also get cells from other * sheets within the same spreadsheet (for example, `Sheet2!A1:C4`) or retrieve multiple ranges at * once (for example, `?ranges=A1:D5&ranges=Sheet2!A1:C4`). Limiting the range returns only the * portions of the spreadsheet that intersect the requested ranges. * * Create a request for the method "spreadsheets.get". * * This request holds the parameters needed by the the sheets server. After setting any optional * parameters, call the {@link Get#execute()} method to invoke the remote operation.

{@link * Get#initialize(com.google.api.client.googleapis.services.AbstractGoogleClientRequest)} must be * called to initialize this instance immediately after invoking the constructor.

* * @param spreadsheetId The spreadsheet to request. * @since 1.13 */ protected Get(java.lang.String spreadsheetId) { super(Sheets.this, "GET", REST_PATH, null, com.google.api.services.sheets.v4.model.Spreadsheet.class); this.spreadsheetId = com.google.api.client.util.Preconditions.checkNotNull(spreadsheetId, "Required parameter spreadsheetId must be specified."); } @Override public com.google.api.client.http.HttpResponse executeUsingHead() throws java.io.IOException { return super.executeUsingHead(); } @Override public com.google.api.client.http.HttpRequest buildHttpRequestUsingHead() throws java.io.IOException { return super.buildHttpRequestUsingHead(); } @Override public Get set$Xgafv(java.lang.String $Xgafv) { return (Get) super.set$Xgafv($Xgafv); } @Override public Get setAccessToken(java.lang.String accessToken) { return (Get) super.setAccessToken(accessToken); } @Override public Get setAlt(java.lang.String alt) { return (Get) super.setAlt(alt); } @Override public Get setCallback(java.lang.String callback) { return (Get) super.setCallback(callback); } @Override public Get setFields(java.lang.String fields) { return (Get) super.setFields(fields); } @Override public Get setKey(java.lang.String key) { return (Get) super.setKey(key); } @Override public Get setOauthToken(java.lang.String oauthToken) { return (Get) super.setOauthToken(oauthToken); } @Override public Get setPrettyPrint(java.lang.Boolean prettyPrint) { return (Get) super.setPrettyPrint(prettyPrint); } @Override public Get setQuotaUser(java.lang.String quotaUser) { return (Get) super.setQuotaUser(quotaUser); } @Override public Get setUploadType(java.lang.String uploadType) { return (Get) super.setUploadType(uploadType); } @Override public Get setUploadProtocol(java.lang.String uploadProtocol) { return (Get) super.setUploadProtocol(uploadProtocol); } /** The spreadsheet to request. */ @com.google.api.client.util.Key private java.lang.String spreadsheetId; /** The spreadsheet to request. */ public java.lang.String getSpreadsheetId() { return spreadsheetId; } /** The spreadsheet to request. */ public Get setSpreadsheetId(java.lang.String spreadsheetId) { this.spreadsheetId = spreadsheetId; return this; } /** * True if grid data should be returned. This parameter is ignored if a field mask was set in * the request. */ @com.google.api.client.util.Key private java.lang.Boolean includeGridData; /** True if grid data should be returned. This parameter is ignored if a field mask was set in the request. */ public java.lang.Boolean getIncludeGridData() { return includeGridData; } /** * True if grid data should be returned. This parameter is ignored if a field mask was set in * the request. */ public Get setIncludeGridData(java.lang.Boolean includeGridData) { this.includeGridData = includeGridData; return this; } /** The ranges to retrieve from the spreadsheet. */ @com.google.api.client.util.Key private java.util.List ranges; /** The ranges to retrieve from the spreadsheet. */ public java.util.List getRanges() { return ranges; } /** The ranges to retrieve from the spreadsheet. */ public Get setRanges(java.util.List ranges) { this.ranges = ranges; return this; } @Override public Get set(String parameterName, Object value) { return (Get) super.set(parameterName, value); } } /** * 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: * 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 * parameter to true. If a field mask is set, the `includeGridData` parameter is ignored For large * spreadsheets, as a best practice, retrieve only the specific spreadsheet fields that you want. * * Create a request for the method "spreadsheets.getByDataFilter". * * This request holds the parameters needed by the sheets server. After setting any optional * parameters, call the {@link GetByDataFilter#execute()} method to invoke the remote operation. * * @param spreadsheetId The spreadsheet to request. * @param content the {@link com.google.api.services.sheets.v4.model.GetSpreadsheetByDataFilterRequest} * @return the request */ public GetByDataFilter getByDataFilter(java.lang.String spreadsheetId, com.google.api.services.sheets.v4.model.GetSpreadsheetByDataFilterRequest content) throws java.io.IOException { GetByDataFilter result = new GetByDataFilter(spreadsheetId, content); initialize(result); return result; } public class GetByDataFilter extends SheetsRequest { private static final String REST_PATH = "v4/spreadsheets/{spreadsheetId}:getByDataFilter"; /** * 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: * 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 parameter to true. If a * field mask is set, the `includeGridData` parameter is ignored For large spreadsheets, as a best * practice, retrieve only the specific spreadsheet fields that you want. * * Create a request for the method "spreadsheets.getByDataFilter". * * This request holds the parameters needed by the the sheets server. After setting any optional * parameters, call the {@link GetByDataFilter#execute()} method to invoke the remote operation. *

{@link GetByDataFilter#initialize(com.google.api.client.googleapis.services.AbstractGoogleC * lientRequest)} must be called to initialize this instance immediately after invoking the * constructor.

* * @param spreadsheetId The spreadsheet to request. * @param content the {@link com.google.api.services.sheets.v4.model.GetSpreadsheetByDataFilterRequest} * @since 1.13 */ protected GetByDataFilter(java.lang.String spreadsheetId, com.google.api.services.sheets.v4.model.GetSpreadsheetByDataFilterRequest content) { super(Sheets.this, "POST", REST_PATH, content, com.google.api.services.sheets.v4.model.Spreadsheet.class); this.spreadsheetId = com.google.api.client.util.Preconditions.checkNotNull(spreadsheetId, "Required parameter spreadsheetId must be specified."); } @Override public GetByDataFilter set$Xgafv(java.lang.String $Xgafv) { return (GetByDataFilter) super.set$Xgafv($Xgafv); } @Override public GetByDataFilter setAccessToken(java.lang.String accessToken) { return (GetByDataFilter) super.setAccessToken(accessToken); } @Override public GetByDataFilter setAlt(java.lang.String alt) { return (GetByDataFilter) super.setAlt(alt); } @Override public GetByDataFilter setCallback(java.lang.String callback) { return (GetByDataFilter) super.setCallback(callback); } @Override public GetByDataFilter setFields(java.lang.String fields) { return (GetByDataFilter) super.setFields(fields); } @Override public GetByDataFilter setKey(java.lang.String key) { return (GetByDataFilter) super.setKey(key); } @Override public GetByDataFilter setOauthToken(java.lang.String oauthToken) { return (GetByDataFilter) super.setOauthToken(oauthToken); } @Override public GetByDataFilter setPrettyPrint(java.lang.Boolean prettyPrint) { return (GetByDataFilter) super.setPrettyPrint(prettyPrint); } @Override public GetByDataFilter setQuotaUser(java.lang.String quotaUser) { return (GetByDataFilter) super.setQuotaUser(quotaUser); } @Override public GetByDataFilter setUploadType(java.lang.String uploadType) { return (GetByDataFilter) super.setUploadType(uploadType); } @Override public GetByDataFilter setUploadProtocol(java.lang.String uploadProtocol) { return (GetByDataFilter) super.setUploadProtocol(uploadProtocol); } /** The spreadsheet to request. */ @com.google.api.client.util.Key private java.lang.String spreadsheetId; /** The spreadsheet to request. */ public java.lang.String getSpreadsheetId() { return spreadsheetId; } /** The spreadsheet to request. */ public GetByDataFilter setSpreadsheetId(java.lang.String spreadsheetId) { this.spreadsheetId = spreadsheetId; return this; } @Override public GetByDataFilter set(String parameterName, Object value) { return (GetByDataFilter) super.set(parameterName, value); } } /** * An accessor for creating requests from the DeveloperMetadata collection. * *

The typical use is:

*
     *   {@code Sheets sheets = new Sheets(...);}
     *   {@code Sheets.DeveloperMetadata.List request = sheets.developerMetadata().list(parameters ...)}
     * 
* * @return the resource collection */ public DeveloperMetadata developerMetadata() { return new DeveloperMetadata(); } /** * The "developerMetadata" collection of methods. */ public class DeveloperMetadata { /** * Returns the developer metadata with the specified ID. The caller must specify the spreadsheet ID * and the developer metadata's unique metadataId. * * Create a request for the method "developerMetadata.get". * * This request holds the parameters needed by the sheets server. After setting any optional * parameters, call the {@link Get#execute()} method to invoke the remote operation. * * @param spreadsheetId The ID of the spreadsheet to retrieve metadata from. * @param metadataId The ID of the developer metadata to retrieve. * @return the request */ public Get get(java.lang.String spreadsheetId, java.lang.Integer metadataId) throws java.io.IOException { Get result = new Get(spreadsheetId, metadataId); initialize(result); return result; } public class Get extends SheetsRequest { private static final String REST_PATH = "v4/spreadsheets/{spreadsheetId}/developerMetadata/{metadataId}"; /** * Returns the developer metadata with the specified ID. The caller must specify the spreadsheet * ID and the developer metadata's unique metadataId. * * Create a request for the method "developerMetadata.get". * * This request holds the parameters needed by the the sheets server. After setting any optional * parameters, call the {@link Get#execute()} method to invoke the remote operation.

{@link * Get#initialize(com.google.api.client.googleapis.services.AbstractGoogleClientRequest)} must be * called to initialize this instance immediately after invoking the constructor.

* * @param spreadsheetId The ID of the spreadsheet to retrieve metadata from. * @param metadataId The ID of the developer metadata to retrieve. * @since 1.13 */ protected Get(java.lang.String spreadsheetId, java.lang.Integer metadataId) { super(Sheets.this, "GET", REST_PATH, null, com.google.api.services.sheets.v4.model.DeveloperMetadata.class); this.spreadsheetId = com.google.api.client.util.Preconditions.checkNotNull(spreadsheetId, "Required parameter spreadsheetId must be specified."); this.metadataId = com.google.api.client.util.Preconditions.checkNotNull(metadataId, "Required parameter metadataId must be specified."); } @Override public com.google.api.client.http.HttpResponse executeUsingHead() throws java.io.IOException { return super.executeUsingHead(); } @Override public com.google.api.client.http.HttpRequest buildHttpRequestUsingHead() throws java.io.IOException { return super.buildHttpRequestUsingHead(); } @Override public Get set$Xgafv(java.lang.String $Xgafv) { return (Get) super.set$Xgafv($Xgafv); } @Override public Get setAccessToken(java.lang.String accessToken) { return (Get) super.setAccessToken(accessToken); } @Override public Get setAlt(java.lang.String alt) { return (Get) super.setAlt(alt); } @Override public Get setCallback(java.lang.String callback) { return (Get) super.setCallback(callback); } @Override public Get setFields(java.lang.String fields) { return (Get) super.setFields(fields); } @Override public Get setKey(java.lang.String key) { return (Get) super.setKey(key); } @Override public Get setOauthToken(java.lang.String oauthToken) { return (Get) super.setOauthToken(oauthToken); } @Override public Get setPrettyPrint(java.lang.Boolean prettyPrint) { return (Get) super.setPrettyPrint(prettyPrint); } @Override public Get setQuotaUser(java.lang.String quotaUser) { return (Get) super.setQuotaUser(quotaUser); } @Override public Get setUploadType(java.lang.String uploadType) { return (Get) super.setUploadType(uploadType); } @Override public Get setUploadProtocol(java.lang.String uploadProtocol) { return (Get) super.setUploadProtocol(uploadProtocol); } /** The ID of the spreadsheet to retrieve metadata from. */ @com.google.api.client.util.Key private java.lang.String spreadsheetId; /** The ID of the spreadsheet to retrieve metadata from. */ public java.lang.String getSpreadsheetId() { return spreadsheetId; } /** The ID of the spreadsheet to retrieve metadata from. */ public Get setSpreadsheetId(java.lang.String spreadsheetId) { this.spreadsheetId = spreadsheetId; return this; } /** The ID of the developer metadata to retrieve. */ @com.google.api.client.util.Key private java.lang.Integer metadataId; /** The ID of the developer metadata to retrieve. */ public java.lang.Integer getMetadataId() { return metadataId; } /** The ID of the developer metadata to retrieve. */ public Get setMetadataId(java.lang.Integer metadataId) { this.metadataId = metadataId; return this; } @Override public Get set(String parameterName, Object value) { return (Get) super.set(parameterName, value); } } /** * 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. * * Create a request for the method "developerMetadata.search". * * This request holds the parameters needed by the sheets server. After setting any optional * parameters, call the {@link Search#execute()} method to invoke the remote operation. * * @param spreadsheetId The ID of the spreadsheet to retrieve metadata from. * @param content the {@link com.google.api.services.sheets.v4.model.SearchDeveloperMetadataRequest} * @return the request */ public Search search(java.lang.String spreadsheetId, com.google.api.services.sheets.v4.model.SearchDeveloperMetadataRequest content) throws java.io.IOException { Search result = new Search(spreadsheetId, content); initialize(result); return result; } public class Search extends SheetsRequest { private static final String REST_PATH = "v4/spreadsheets/{spreadsheetId}/developerMetadata:search"; /** * 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. * * Create a request for the method "developerMetadata.search". * * This request holds the parameters needed by the the sheets server. After setting any optional * parameters, call the {@link Search#execute()} method to invoke the remote operation.

{@link * Search#initialize(com.google.api.client.googleapis.services.AbstractGoogleClientRequest)} must * be called to initialize this instance immediately after invoking the constructor.

* * @param spreadsheetId The ID of the spreadsheet to retrieve metadata from. * @param content the {@link com.google.api.services.sheets.v4.model.SearchDeveloperMetadataRequest} * @since 1.13 */ protected Search(java.lang.String spreadsheetId, com.google.api.services.sheets.v4.model.SearchDeveloperMetadataRequest content) { super(Sheets.this, "POST", REST_PATH, content, com.google.api.services.sheets.v4.model.SearchDeveloperMetadataResponse.class); this.spreadsheetId = com.google.api.client.util.Preconditions.checkNotNull(spreadsheetId, "Required parameter spreadsheetId must be specified."); } @Override public Search set$Xgafv(java.lang.String $Xgafv) { return (Search) super.set$Xgafv($Xgafv); } @Override public Search setAccessToken(java.lang.String accessToken) { return (Search) super.setAccessToken(accessToken); } @Override public Search setAlt(java.lang.String alt) { return (Search) super.setAlt(alt); } @Override public Search setCallback(java.lang.String callback) { return (Search) super.setCallback(callback); } @Override public Search setFields(java.lang.String fields) { return (Search) super.setFields(fields); } @Override public Search setKey(java.lang.String key) { return (Search) super.setKey(key); } @Override public Search setOauthToken(java.lang.String oauthToken) { return (Search) super.setOauthToken(oauthToken); } @Override public Search setPrettyPrint(java.lang.Boolean prettyPrint) { return (Search) super.setPrettyPrint(prettyPrint); } @Override public Search setQuotaUser(java.lang.String quotaUser) { return (Search) super.setQuotaUser(quotaUser); } @Override public Search setUploadType(java.lang.String uploadType) { return (Search) super.setUploadType(uploadType); } @Override public Search setUploadProtocol(java.lang.String uploadProtocol) { return (Search) super.setUploadProtocol(uploadProtocol); } /** The ID of the spreadsheet to retrieve metadata from. */ @com.google.api.client.util.Key private java.lang.String spreadsheetId; /** The ID of the spreadsheet to retrieve metadata from. */ public java.lang.String getSpreadsheetId() { return spreadsheetId; } /** The ID of the spreadsheet to retrieve metadata from. */ public Search setSpreadsheetId(java.lang.String spreadsheetId) { this.spreadsheetId = spreadsheetId; return this; } @Override public Search set(String parameterName, Object value) { return (Search) super.set(parameterName, value); } } } /** * An accessor for creating requests from the SheetsOperations collection. * *

The typical use is:

*
     *   {@code Sheets sheets = new Sheets(...);}
     *   {@code Sheets.SheetsOperations.List request = sheets.sheets().list(parameters ...)}
     * 
* * @return the resource collection */ public SheetsOperations sheets() { return new SheetsOperations(); } /** * The "sheets" collection of methods. */ public class SheetsOperations { /** * Copies a single sheet from a spreadsheet to another spreadsheet. Returns the properties of the * newly created sheet. * * Create a request for the method "sheets.copyTo". * * This request holds the parameters needed by the sheets server. After setting any optional * parameters, call the {@link CopyTo#execute()} method to invoke the remote operation. * * @param spreadsheetId The ID of the spreadsheet containing the sheet to copy. * @param sheetId The ID of the sheet to copy. * @param content the {@link com.google.api.services.sheets.v4.model.CopySheetToAnotherSpreadsheetRequest} * @return the request */ public CopyTo copyTo(java.lang.String spreadsheetId, java.lang.Integer sheetId, com.google.api.services.sheets.v4.model.CopySheetToAnotherSpreadsheetRequest content) throws java.io.IOException { CopyTo result = new CopyTo(spreadsheetId, sheetId, content); initialize(result); return result; } public class CopyTo extends SheetsRequest { private static final String REST_PATH = "v4/spreadsheets/{spreadsheetId}/sheets/{sheetId}:copyTo"; /** * Copies a single sheet from a spreadsheet to another spreadsheet. Returns the properties of the * newly created sheet. * * Create a request for the method "sheets.copyTo". * * This request holds the parameters needed by the the sheets server. After setting any optional * parameters, call the {@link CopyTo#execute()} method to invoke the remote operation.

{@link * CopyTo#initialize(com.google.api.client.googleapis.services.AbstractGoogleClientRequest)} must * be called to initialize this instance immediately after invoking the constructor.

* * @param spreadsheetId The ID of the spreadsheet containing the sheet to copy. * @param sheetId The ID of the sheet to copy. * @param content the {@link com.google.api.services.sheets.v4.model.CopySheetToAnotherSpreadsheetRequest} * @since 1.13 */ protected CopyTo(java.lang.String spreadsheetId, java.lang.Integer sheetId, com.google.api.services.sheets.v4.model.CopySheetToAnotherSpreadsheetRequest content) { super(Sheets.this, "POST", REST_PATH, content, com.google.api.services.sheets.v4.model.SheetProperties.class); this.spreadsheetId = com.google.api.client.util.Preconditions.checkNotNull(spreadsheetId, "Required parameter spreadsheetId must be specified."); this.sheetId = com.google.api.client.util.Preconditions.checkNotNull(sheetId, "Required parameter sheetId must be specified."); } @Override public CopyTo set$Xgafv(java.lang.String $Xgafv) { return (CopyTo) super.set$Xgafv($Xgafv); } @Override public CopyTo setAccessToken(java.lang.String accessToken) { return (CopyTo) super.setAccessToken(accessToken); } @Override public CopyTo setAlt(java.lang.String alt) { return (CopyTo) super.setAlt(alt); } @Override public CopyTo setCallback(java.lang.String callback) { return (CopyTo) super.setCallback(callback); } @Override public CopyTo setFields(java.lang.String fields) { return (CopyTo) super.setFields(fields); } @Override public CopyTo setKey(java.lang.String key) { return (CopyTo) super.setKey(key); } @Override public CopyTo setOauthToken(java.lang.String oauthToken) { return (CopyTo) super.setOauthToken(oauthToken); } @Override public CopyTo setPrettyPrint(java.lang.Boolean prettyPrint) { return (CopyTo) super.setPrettyPrint(prettyPrint); } @Override public CopyTo setQuotaUser(java.lang.String quotaUser) { return (CopyTo) super.setQuotaUser(quotaUser); } @Override public CopyTo setUploadType(java.lang.String uploadType) { return (CopyTo) super.setUploadType(uploadType); } @Override public CopyTo setUploadProtocol(java.lang.String uploadProtocol) { return (CopyTo) super.setUploadProtocol(uploadProtocol); } /** The ID of the spreadsheet containing the sheet to copy. */ @com.google.api.client.util.Key private java.lang.String spreadsheetId; /** The ID of the spreadsheet containing the sheet to copy. */ public java.lang.String getSpreadsheetId() { return spreadsheetId; } /** The ID of the spreadsheet containing the sheet to copy. */ public CopyTo setSpreadsheetId(java.lang.String spreadsheetId) { this.spreadsheetId = spreadsheetId; return this; } /** The ID of the sheet to copy. */ @com.google.api.client.util.Key private java.lang.Integer sheetId; /** The ID of the sheet to copy. */ public java.lang.Integer getSheetId() { return sheetId; } /** The ID of the sheet to copy. */ public CopyTo setSheetId(java.lang.Integer sheetId) { this.sheetId = sheetId; return this; } @Override public CopyTo set(String parameterName, Object value) { return (CopyTo) super.set(parameterName, value); } } } /** * An accessor for creating requests from the Values collection. * *

The typical use is:

*
     *   {@code Sheets sheets = new Sheets(...);}
     *   {@code Sheets.Values.List request = sheets.values().list(parameters ...)}
     * 
* * @return the resource collection */ public Values values() { return new Values(); } /** * The "values" collection of methods. */ public class Values { /** * 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 `valueInputOption` only controls how the input data will be added to the * sheet (column-wise or row-wise), it does not influence what cell the data starts being written * to. * * Create a request for the method "values.append". * * This request holds the parameters needed by the sheets server. After setting any optional * parameters, call the {@link Append#execute()} method to invoke the remote operation. * * @param spreadsheetId The ID of the spreadsheet to update. * @param range The [A1 notation](/sheets/api/guides/concepts#cell) of a range to search for a logical table of * data. Values are appended after the last row of the table. * @param content the {@link com.google.api.services.sheets.v4.model.ValueRange} * @return the request */ public Append append(java.lang.String spreadsheetId, java.lang.String range, com.google.api.services.sheets.v4.model.ValueRange content) throws java.io.IOException { Append result = new Append(spreadsheetId, range, content); initialize(result); return result; } public class Append extends SheetsRequest { private static final String REST_PATH = "v4/spreadsheets/{spreadsheetId}/values/{range}:append"; /** * 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 `valueInputOption` only controls how the input data will be added to the * sheet (column-wise or row-wise), it does not influence what cell the data starts being written * to. * * Create a request for the method "values.append". * * This request holds the parameters needed by the the sheets server. After setting any optional * parameters, call the {@link Append#execute()} method to invoke the remote operation.

{@link * Append#initialize(com.google.api.client.googleapis.services.AbstractGoogleClientRequest)} must * be called to initialize this instance immediately after invoking the constructor.

* * @param spreadsheetId The ID of the spreadsheet to update. * @param range The [A1 notation](/sheets/api/guides/concepts#cell) of a range to search for a logical table of * data. Values are appended after the last row of the table. * @param content the {@link com.google.api.services.sheets.v4.model.ValueRange} * @since 1.13 */ protected Append(java.lang.String spreadsheetId, java.lang.String range, com.google.api.services.sheets.v4.model.ValueRange content) { super(Sheets.this, "POST", REST_PATH, content, com.google.api.services.sheets.v4.model.AppendValuesResponse.class); this.spreadsheetId = com.google.api.client.util.Preconditions.checkNotNull(spreadsheetId, "Required parameter spreadsheetId must be specified."); this.range = com.google.api.client.util.Preconditions.checkNotNull(range, "Required parameter range must be specified."); } @Override public Append set$Xgafv(java.lang.String $Xgafv) { return (Append) super.set$Xgafv($Xgafv); } @Override public Append setAccessToken(java.lang.String accessToken) { return (Append) super.setAccessToken(accessToken); } @Override public Append setAlt(java.lang.String alt) { return (Append) super.setAlt(alt); } @Override public Append setCallback(java.lang.String callback) { return (Append) super.setCallback(callback); } @Override public Append setFields(java.lang.String fields) { return (Append) super.setFields(fields); } @Override public Append setKey(java.lang.String key) { return (Append) super.setKey(key); } @Override public Append setOauthToken(java.lang.String oauthToken) { return (Append) super.setOauthToken(oauthToken); } @Override public Append setPrettyPrint(java.lang.Boolean prettyPrint) { return (Append) super.setPrettyPrint(prettyPrint); } @Override public Append setQuotaUser(java.lang.String quotaUser) { return (Append) super.setQuotaUser(quotaUser); } @Override public Append setUploadType(java.lang.String uploadType) { return (Append) super.setUploadType(uploadType); } @Override public Append setUploadProtocol(java.lang.String uploadProtocol) { return (Append) super.setUploadProtocol(uploadProtocol); } /** The ID of the spreadsheet to update. */ @com.google.api.client.util.Key private java.lang.String spreadsheetId; /** The ID of the spreadsheet to update. */ public java.lang.String getSpreadsheetId() { return spreadsheetId; } /** The ID of the spreadsheet to update. */ public Append setSpreadsheetId(java.lang.String spreadsheetId) { this.spreadsheetId = spreadsheetId; return this; } /** * The [A1 notation](/sheets/api/guides/concepts#cell) of a range to search for a logical * table of data. Values are appended after the last row of the table. */ @com.google.api.client.util.Key private java.lang.String range; /** The [A1 notation](/sheets/api/guides/concepts#cell) of a range to search for a logical table of data. Values are appended after the last row of the table. */ public java.lang.String getRange() { return range; } /** * The [A1 notation](/sheets/api/guides/concepts#cell) of a range to search for a logical * table of data. Values are appended after the last row of the table. */ public Append setRange(java.lang.String range) { this.range = range; return this; } /** * Determines if the update response should include the values of the cells that were * appended. By default, responses do not include the updated values. */ @com.google.api.client.util.Key private java.lang.Boolean includeValuesInResponse; /** Determines if the update response should include the values of the cells that were appended. By default, responses do not include the updated values. */ public java.lang.Boolean getIncludeValuesInResponse() { return includeValuesInResponse; } /** * Determines if the update response should include the values of the cells that were * appended. By default, responses do not include the updated values. */ public Append setIncludeValuesInResponse(java.lang.Boolean includeValuesInResponse) { this.includeValuesInResponse = includeValuesInResponse; return this; } /** How the input data should be inserted. */ @com.google.api.client.util.Key private java.lang.String insertDataOption; /** How the input data should be inserted. */ public java.lang.String getInsertDataOption() { return insertDataOption; } /** How the input data should be inserted. */ public Append setInsertDataOption(java.lang.String insertDataOption) { this.insertDataOption = insertDataOption; return this; } /** * Determines how dates, times, and durations in the response should be rendered. This is * ignored if response_value_render_option is FORMATTED_VALUE. The default dateTime render * option is SERIAL_NUMBER. */ @com.google.api.client.util.Key private java.lang.String responseDateTimeRenderOption; /** Determines how dates, times, and durations in the response should be rendered. This is ignored if response_value_render_option is FORMATTED_VALUE. The default dateTime render option is SERIAL_NUMBER. */ public java.lang.String getResponseDateTimeRenderOption() { return responseDateTimeRenderOption; } /** * Determines how dates, times, and durations in the response should be rendered. This is * ignored if response_value_render_option is FORMATTED_VALUE. The default dateTime render * option is SERIAL_NUMBER. */ public Append setResponseDateTimeRenderOption(java.lang.String responseDateTimeRenderOption) { this.responseDateTimeRenderOption = responseDateTimeRenderOption; return this; } /** * Determines how values in the response should be rendered. The default render option is * FORMATTED_VALUE. */ @com.google.api.client.util.Key private java.lang.String responseValueRenderOption; /** Determines how values in the response should be rendered. The default render option is FORMATTED_VALUE. */ public java.lang.String getResponseValueRenderOption() { return responseValueRenderOption; } /** * Determines how values in the response should be rendered. The default render option is * FORMATTED_VALUE. */ public Append setResponseValueRenderOption(java.lang.String responseValueRenderOption) { this.responseValueRenderOption = responseValueRenderOption; return this; } /** How the input data should be interpreted. */ @com.google.api.client.util.Key private java.lang.String valueInputOption; /** How the input data should be interpreted. */ public java.lang.String getValueInputOption() { return valueInputOption; } /** How the input data should be interpreted. */ public Append setValueInputOption(java.lang.String valueInputOption) { this.valueInputOption = valueInputOption; return this; } @Override public Append set(String parameterName, Object value) { return (Append) super.set(parameterName, value); } } /** * 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. * * Create a request for the method "values.batchClear". * * This request holds the parameters needed by the sheets server. After setting any optional * parameters, call the {@link BatchClear#execute()} method to invoke the remote operation. * * @param spreadsheetId The ID of the spreadsheet to update. * @param content the {@link com.google.api.services.sheets.v4.model.BatchClearValuesRequest} * @return the request */ public BatchClear batchClear(java.lang.String spreadsheetId, com.google.api.services.sheets.v4.model.BatchClearValuesRequest content) throws java.io.IOException { BatchClear result = new BatchClear(spreadsheetId, content); initialize(result); return result; } public class BatchClear extends SheetsRequest { private static final String REST_PATH = "v4/spreadsheets/{spreadsheetId}/values:batchClear"; /** * 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. * * Create a request for the method "values.batchClear". * * This request holds the parameters needed by the the sheets server. After setting any optional * parameters, call the {@link BatchClear#execute()} method to invoke the remote operation.

* {@link * BatchClear#initialize(com.google.api.client.googleapis.services.AbstractGoogleClientRequest)} * must be called to initialize this instance immediately after invoking the constructor.

* * @param spreadsheetId The ID of the spreadsheet to update. * @param content the {@link com.google.api.services.sheets.v4.model.BatchClearValuesRequest} * @since 1.13 */ protected BatchClear(java.lang.String spreadsheetId, com.google.api.services.sheets.v4.model.BatchClearValuesRequest content) { super(Sheets.this, "POST", REST_PATH, content, com.google.api.services.sheets.v4.model.BatchClearValuesResponse.class); this.spreadsheetId = com.google.api.client.util.Preconditions.checkNotNull(spreadsheetId, "Required parameter spreadsheetId must be specified."); } @Override public BatchClear set$Xgafv(java.lang.String $Xgafv) { return (BatchClear) super.set$Xgafv($Xgafv); } @Override public BatchClear setAccessToken(java.lang.String accessToken) { return (BatchClear) super.setAccessToken(accessToken); } @Override public BatchClear setAlt(java.lang.String alt) { return (BatchClear) super.setAlt(alt); } @Override public BatchClear setCallback(java.lang.String callback) { return (BatchClear) super.setCallback(callback); } @Override public BatchClear setFields(java.lang.String fields) { return (BatchClear) super.setFields(fields); } @Override public BatchClear setKey(java.lang.String key) { return (BatchClear) super.setKey(key); } @Override public BatchClear setOauthToken(java.lang.String oauthToken) { return (BatchClear) super.setOauthToken(oauthToken); } @Override public BatchClear setPrettyPrint(java.lang.Boolean prettyPrint) { return (BatchClear) super.setPrettyPrint(prettyPrint); } @Override public BatchClear setQuotaUser(java.lang.String quotaUser) { return (BatchClear) super.setQuotaUser(quotaUser); } @Override public BatchClear setUploadType(java.lang.String uploadType) { return (BatchClear) super.setUploadType(uploadType); } @Override public BatchClear setUploadProtocol(java.lang.String uploadProtocol) { return (BatchClear) super.setUploadProtocol(uploadProtocol); } /** The ID of the spreadsheet to update. */ @com.google.api.client.util.Key private java.lang.String spreadsheetId; /** The ID of the spreadsheet to update. */ public java.lang.String getSpreadsheetId() { return spreadsheetId; } /** The ID of the spreadsheet to update. */ public BatchClear setSpreadsheetId(java.lang.String spreadsheetId) { this.spreadsheetId = spreadsheetId; return this; } @Override public BatchClear set(String parameterName, Object value) { return (BatchClear) super.set(parameterName, value); } } /** * 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. * * Create a request for the method "values.batchClearByDataFilter". * * This request holds the parameters needed by the sheets server. After setting any optional * parameters, call the {@link BatchClearByDataFilter#execute()} method to invoke the remote * operation. * * @param spreadsheetId The ID of the spreadsheet to update. * @param content the {@link com.google.api.services.sheets.v4.model.BatchClearValuesByDataFilterRequest} * @return the request */ public BatchClearByDataFilter batchClearByDataFilter(java.lang.String spreadsheetId, com.google.api.services.sheets.v4.model.BatchClearValuesByDataFilterRequest content) throws java.io.IOException { BatchClearByDataFilter result = new BatchClearByDataFilter(spreadsheetId, content); initialize(result); return result; } public class BatchClearByDataFilter extends SheetsRequest { private static final String REST_PATH = "v4/spreadsheets/{spreadsheetId}/values:batchClearByDataFilter"; /** * 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. * * Create a request for the method "values.batchClearByDataFilter". * * This request holds the parameters needed by the the sheets server. After setting any optional * parameters, call the {@link BatchClearByDataFilter#execute()} method to invoke the remote * operation.

{@link BatchClearByDataFilter#initialize(com.google.api.client.googleapis.servic * es.AbstractGoogleClientRequest)} must be called to initialize this instance immediately after * invoking the constructor.

* * @param spreadsheetId The ID of the spreadsheet to update. * @param content the {@link com.google.api.services.sheets.v4.model.BatchClearValuesByDataFilterRequest} * @since 1.13 */ protected BatchClearByDataFilter(java.lang.String spreadsheetId, com.google.api.services.sheets.v4.model.BatchClearValuesByDataFilterRequest content) { super(Sheets.this, "POST", REST_PATH, content, com.google.api.services.sheets.v4.model.BatchClearValuesByDataFilterResponse.class); this.spreadsheetId = com.google.api.client.util.Preconditions.checkNotNull(spreadsheetId, "Required parameter spreadsheetId must be specified."); } @Override public BatchClearByDataFilter set$Xgafv(java.lang.String $Xgafv) { return (BatchClearByDataFilter) super.set$Xgafv($Xgafv); } @Override public BatchClearByDataFilter setAccessToken(java.lang.String accessToken) { return (BatchClearByDataFilter) super.setAccessToken(accessToken); } @Override public BatchClearByDataFilter setAlt(java.lang.String alt) { return (BatchClearByDataFilter) super.setAlt(alt); } @Override public BatchClearByDataFilter setCallback(java.lang.String callback) { return (BatchClearByDataFilter) super.setCallback(callback); } @Override public BatchClearByDataFilter setFields(java.lang.String fields) { return (BatchClearByDataFilter) super.setFields(fields); } @Override public BatchClearByDataFilter setKey(java.lang.String key) { return (BatchClearByDataFilter) super.setKey(key); } @Override public BatchClearByDataFilter setOauthToken(java.lang.String oauthToken) { return (BatchClearByDataFilter) super.setOauthToken(oauthToken); } @Override public BatchClearByDataFilter setPrettyPrint(java.lang.Boolean prettyPrint) { return (BatchClearByDataFilter) super.setPrettyPrint(prettyPrint); } @Override public BatchClearByDataFilter setQuotaUser(java.lang.String quotaUser) { return (BatchClearByDataFilter) super.setQuotaUser(quotaUser); } @Override public BatchClearByDataFilter setUploadType(java.lang.String uploadType) { return (BatchClearByDataFilter) super.setUploadType(uploadType); } @Override public BatchClearByDataFilter setUploadProtocol(java.lang.String uploadProtocol) { return (BatchClearByDataFilter) super.setUploadProtocol(uploadProtocol); } /** The ID of the spreadsheet to update. */ @com.google.api.client.util.Key private java.lang.String spreadsheetId; /** The ID of the spreadsheet to update. */ public java.lang.String getSpreadsheetId() { return spreadsheetId; } /** The ID of the spreadsheet to update. */ public BatchClearByDataFilter setSpreadsheetId(java.lang.String spreadsheetId) { this.spreadsheetId = spreadsheetId; return this; } @Override public BatchClearByDataFilter set(String parameterName, Object value) { return (BatchClearByDataFilter) super.set(parameterName, value); } } /** * Returns one or more ranges of values from a spreadsheet. The caller must specify the spreadsheet * ID and one or more ranges. * * Create a request for the method "values.batchGet". * * This request holds the parameters needed by the sheets server. After setting any optional * parameters, call the {@link BatchGet#execute()} method to invoke the remote operation. * * @param spreadsheetId The ID of the spreadsheet to retrieve data from. * @return the request */ public BatchGet batchGet(java.lang.String spreadsheetId) throws java.io.IOException { BatchGet result = new BatchGet(spreadsheetId); initialize(result); return result; } public class BatchGet extends SheetsRequest { private static final String REST_PATH = "v4/spreadsheets/{spreadsheetId}/values:batchGet"; /** * Returns one or more ranges of values from a spreadsheet. The caller must specify the * spreadsheet ID and one or more ranges. * * Create a request for the method "values.batchGet". * * This request holds the parameters needed by the the sheets server. After setting any optional * parameters, call the {@link BatchGet#execute()} method to invoke the remote operation.

* {@link * BatchGet#initialize(com.google.api.client.googleapis.services.AbstractGoogleClientRequest)} * must be called to initialize this instance immediately after invoking the constructor.

* * @param spreadsheetId The ID of the spreadsheet to retrieve data from. * @since 1.13 */ protected BatchGet(java.lang.String spreadsheetId) { super(Sheets.this, "GET", REST_PATH, null, com.google.api.services.sheets.v4.model.BatchGetValuesResponse.class); this.spreadsheetId = com.google.api.client.util.Preconditions.checkNotNull(spreadsheetId, "Required parameter spreadsheetId must be specified."); } @Override public com.google.api.client.http.HttpResponse executeUsingHead() throws java.io.IOException { return super.executeUsingHead(); } @Override public com.google.api.client.http.HttpRequest buildHttpRequestUsingHead() throws java.io.IOException { return super.buildHttpRequestUsingHead(); } @Override public BatchGet set$Xgafv(java.lang.String $Xgafv) { return (BatchGet) super.set$Xgafv($Xgafv); } @Override public BatchGet setAccessToken(java.lang.String accessToken) { return (BatchGet) super.setAccessToken(accessToken); } @Override public BatchGet setAlt(java.lang.String alt) { return (BatchGet) super.setAlt(alt); } @Override public BatchGet setCallback(java.lang.String callback) { return (BatchGet) super.setCallback(callback); } @Override public BatchGet setFields(java.lang.String fields) { return (BatchGet) super.setFields(fields); } @Override public BatchGet setKey(java.lang.String key) { return (BatchGet) super.setKey(key); } @Override public BatchGet setOauthToken(java.lang.String oauthToken) { return (BatchGet) super.setOauthToken(oauthToken); } @Override public BatchGet setPrettyPrint(java.lang.Boolean prettyPrint) { return (BatchGet) super.setPrettyPrint(prettyPrint); } @Override public BatchGet setQuotaUser(java.lang.String quotaUser) { return (BatchGet) super.setQuotaUser(quotaUser); } @Override public BatchGet setUploadType(java.lang.String uploadType) { return (BatchGet) super.setUploadType(uploadType); } @Override public BatchGet setUploadProtocol(java.lang.String uploadProtocol) { return (BatchGet) super.setUploadProtocol(uploadProtocol); } /** The ID of the spreadsheet to retrieve data from. */ @com.google.api.client.util.Key private java.lang.String spreadsheetId; /** The ID of the spreadsheet to retrieve data from. */ public java.lang.String getSpreadsheetId() { return spreadsheetId; } /** The ID of the spreadsheet to retrieve data from. */ public BatchGet setSpreadsheetId(java.lang.String spreadsheetId) { this.spreadsheetId = spreadsheetId; return this; } /** * How dates, times, and durations should be represented in the output. This is ignored if * value_render_option is FORMATTED_VALUE. The default dateTime render option is * SERIAL_NUMBER. */ @com.google.api.client.util.Key private java.lang.String dateTimeRenderOption; /** How dates, times, and durations should be represented in the output. This is ignored if value_render_option is FORMATTED_VALUE. The default dateTime render option is SERIAL_NUMBER. */ public java.lang.String getDateTimeRenderOption() { return dateTimeRenderOption; } /** * How dates, times, and durations should be represented in the output. This is ignored if * value_render_option is FORMATTED_VALUE. The default dateTime render option is * SERIAL_NUMBER. */ public BatchGet setDateTimeRenderOption(java.lang.String dateTimeRenderOption) { this.dateTimeRenderOption = dateTimeRenderOption; return this; } /** * The major dimension that results should use. For example, if the spreadsheet data is: * `A1=1,B1=2,A2=3,B2=4`, then requesting `ranges=["A1:B2"],majorDimension=ROWS` returns * `[[1,2],[3,4]]`, whereas requesting `ranges=["A1:B2"],majorDimension=COLUMNS` returns * `[[1,3],[2,4]]`. */ @com.google.api.client.util.Key private java.lang.String majorDimension; /** The major dimension that results should use. For example, if the spreadsheet data is: `A1=1,B1=2,A2=3,B2=4`, then requesting `ranges=["A1:B2"],majorDimension=ROWS` returns `[[1,2],[3,4]]`, whereas requesting `ranges=["A1:B2"],majorDimension=COLUMNS` returns `[[1,3],[2,4]]`. */ public java.lang.String getMajorDimension() { return majorDimension; } /** * The major dimension that results should use. For example, if the spreadsheet data is: * `A1=1,B1=2,A2=3,B2=4`, then requesting `ranges=["A1:B2"],majorDimension=ROWS` returns * `[[1,2],[3,4]]`, whereas requesting `ranges=["A1:B2"],majorDimension=COLUMNS` returns * `[[1,3],[2,4]]`. */ public BatchGet setMajorDimension(java.lang.String majorDimension) { this.majorDimension = majorDimension; return this; } /** * The [A1 notation or R1C1 notation](/sheets/api/guides/concepts#cell) of the range to * retrieve values from. */ @com.google.api.client.util.Key private java.util.List ranges; /** The [A1 notation or R1C1 notation](/sheets/api/guides/concepts#cell) of the range to retrieve values from. */ public java.util.List getRanges() { return ranges; } /** * The [A1 notation or R1C1 notation](/sheets/api/guides/concepts#cell) of the range to * retrieve values from. */ public BatchGet setRanges(java.util.List ranges) { this.ranges = ranges; return this; } /** * How values should be represented in the output. The default render option is * ValueRenderOption.FORMATTED_VALUE. */ @com.google.api.client.util.Key private java.lang.String valueRenderOption; /** How values should be represented in the output. The default render option is ValueRenderOption.FORMATTED_VALUE. */ public java.lang.String getValueRenderOption() { return valueRenderOption; } /** * How values should be represented in the output. The default render option is * ValueRenderOption.FORMATTED_VALUE. */ public BatchGet setValueRenderOption(java.lang.String valueRenderOption) { this.valueRenderOption = valueRenderOption; return this; } @Override public BatchGet set(String parameterName, Object value) { return (BatchGet) super.set(parameterName, value); } } /** * 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. * * Create a request for the method "values.batchGetByDataFilter". * * This request holds the parameters needed by the sheets server. After setting any optional * parameters, call the {@link BatchGetByDataFilter#execute()} method to invoke the remote * operation. * * @param spreadsheetId The ID of the spreadsheet to retrieve data from. * @param content the {@link com.google.api.services.sheets.v4.model.BatchGetValuesByDataFilterRequest} * @return the request */ public BatchGetByDataFilter batchGetByDataFilter(java.lang.String spreadsheetId, com.google.api.services.sheets.v4.model.BatchGetValuesByDataFilterRequest content) throws java.io.IOException { BatchGetByDataFilter result = new BatchGetByDataFilter(spreadsheetId, content); initialize(result); return result; } public class BatchGetByDataFilter extends SheetsRequest { private static final String REST_PATH = "v4/spreadsheets/{spreadsheetId}/values:batchGetByDataFilter"; /** * 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. * * Create a request for the method "values.batchGetByDataFilter". * * This request holds the parameters needed by the the sheets server. After setting any optional * parameters, call the {@link BatchGetByDataFilter#execute()} method to invoke the remote * operation.

{@link BatchGetByDataFilter#initialize(com.google.api.client.googleapis.services * .AbstractGoogleClientRequest)} must be called to initialize this instance immediately after * invoking the constructor.

* * @param spreadsheetId The ID of the spreadsheet to retrieve data from. * @param content the {@link com.google.api.services.sheets.v4.model.BatchGetValuesByDataFilterRequest} * @since 1.13 */ protected BatchGetByDataFilter(java.lang.String spreadsheetId, com.google.api.services.sheets.v4.model.BatchGetValuesByDataFilterRequest content) { super(Sheets.this, "POST", REST_PATH, content, com.google.api.services.sheets.v4.model.BatchGetValuesByDataFilterResponse.class); this.spreadsheetId = com.google.api.client.util.Preconditions.checkNotNull(spreadsheetId, "Required parameter spreadsheetId must be specified."); } @Override public BatchGetByDataFilter set$Xgafv(java.lang.String $Xgafv) { return (BatchGetByDataFilter) super.set$Xgafv($Xgafv); } @Override public BatchGetByDataFilter setAccessToken(java.lang.String accessToken) { return (BatchGetByDataFilter) super.setAccessToken(accessToken); } @Override public BatchGetByDataFilter setAlt(java.lang.String alt) { return (BatchGetByDataFilter) super.setAlt(alt); } @Override public BatchGetByDataFilter setCallback(java.lang.String callback) { return (BatchGetByDataFilter) super.setCallback(callback); } @Override public BatchGetByDataFilter setFields(java.lang.String fields) { return (BatchGetByDataFilter) super.setFields(fields); } @Override public BatchGetByDataFilter setKey(java.lang.String key) { return (BatchGetByDataFilter) super.setKey(key); } @Override public BatchGetByDataFilter setOauthToken(java.lang.String oauthToken) { return (BatchGetByDataFilter) super.setOauthToken(oauthToken); } @Override public BatchGetByDataFilter setPrettyPrint(java.lang.Boolean prettyPrint) { return (BatchGetByDataFilter) super.setPrettyPrint(prettyPrint); } @Override public BatchGetByDataFilter setQuotaUser(java.lang.String quotaUser) { return (BatchGetByDataFilter) super.setQuotaUser(quotaUser); } @Override public BatchGetByDataFilter setUploadType(java.lang.String uploadType) { return (BatchGetByDataFilter) super.setUploadType(uploadType); } @Override public BatchGetByDataFilter setUploadProtocol(java.lang.String uploadProtocol) { return (BatchGetByDataFilter) super.setUploadProtocol(uploadProtocol); } /** The ID of the spreadsheet to retrieve data from. */ @com.google.api.client.util.Key private java.lang.String spreadsheetId; /** The ID of the spreadsheet to retrieve data from. */ public java.lang.String getSpreadsheetId() { return spreadsheetId; } /** The ID of the spreadsheet to retrieve data from. */ public BatchGetByDataFilter setSpreadsheetId(java.lang.String spreadsheetId) { this.spreadsheetId = spreadsheetId; return this; } @Override public BatchGetByDataFilter set(String parameterName, Object value) { return (BatchGetByDataFilter) super.set(parameterName, value); } } /** * Sets values in one or more ranges of a spreadsheet. The caller must specify the spreadsheet ID, a * valueInputOption, and one or more ValueRanges. * * Create a request for the method "values.batchUpdate". * * This request holds the parameters needed by the sheets server. After setting any optional * parameters, call the {@link BatchUpdate#execute()} method to invoke the remote operation. * * @param spreadsheetId The ID of the spreadsheet to update. * @param content the {@link com.google.api.services.sheets.v4.model.BatchUpdateValuesRequest} * @return the request */ public BatchUpdate batchUpdate(java.lang.String spreadsheetId, com.google.api.services.sheets.v4.model.BatchUpdateValuesRequest content) throws java.io.IOException { BatchUpdate result = new BatchUpdate(spreadsheetId, content); initialize(result); return result; } public class BatchUpdate extends SheetsRequest { private static final String REST_PATH = "v4/spreadsheets/{spreadsheetId}/values:batchUpdate"; /** * Sets values in one or more ranges of a spreadsheet. The caller must specify the spreadsheet ID, * a valueInputOption, and one or more ValueRanges. * * Create a request for the method "values.batchUpdate". * * This request holds the parameters needed by the the sheets server. After setting any optional * parameters, call the {@link BatchUpdate#execute()} method to invoke the remote operation.

* {@link * BatchUpdate#initialize(com.google.api.client.googleapis.services.AbstractGoogleClientRequest)} * must be called to initialize this instance immediately after invoking the constructor.

* * @param spreadsheetId The ID of the spreadsheet to update. * @param content the {@link com.google.api.services.sheets.v4.model.BatchUpdateValuesRequest} * @since 1.13 */ protected BatchUpdate(java.lang.String spreadsheetId, com.google.api.services.sheets.v4.model.BatchUpdateValuesRequest content) { super(Sheets.this, "POST", REST_PATH, content, com.google.api.services.sheets.v4.model.BatchUpdateValuesResponse.class); this.spreadsheetId = com.google.api.client.util.Preconditions.checkNotNull(spreadsheetId, "Required parameter spreadsheetId must be specified."); } @Override public BatchUpdate set$Xgafv(java.lang.String $Xgafv) { return (BatchUpdate) super.set$Xgafv($Xgafv); } @Override public BatchUpdate setAccessToken(java.lang.String accessToken) { return (BatchUpdate) super.setAccessToken(accessToken); } @Override public BatchUpdate setAlt(java.lang.String alt) { return (BatchUpdate) super.setAlt(alt); } @Override public BatchUpdate setCallback(java.lang.String callback) { return (BatchUpdate) super.setCallback(callback); } @Override public BatchUpdate setFields(java.lang.String fields) { return (BatchUpdate) super.setFields(fields); } @Override public BatchUpdate setKey(java.lang.String key) { return (BatchUpdate) super.setKey(key); } @Override public BatchUpdate setOauthToken(java.lang.String oauthToken) { return (BatchUpdate) super.setOauthToken(oauthToken); } @Override public BatchUpdate setPrettyPrint(java.lang.Boolean prettyPrint) { return (BatchUpdate) super.setPrettyPrint(prettyPrint); } @Override public BatchUpdate setQuotaUser(java.lang.String quotaUser) { return (BatchUpdate) super.setQuotaUser(quotaUser); } @Override public BatchUpdate setUploadType(java.lang.String uploadType) { return (BatchUpdate) super.setUploadType(uploadType); } @Override public BatchUpdate setUploadProtocol(java.lang.String uploadProtocol) { return (BatchUpdate) super.setUploadProtocol(uploadProtocol); } /** The ID of the spreadsheet to update. */ @com.google.api.client.util.Key private java.lang.String spreadsheetId; /** The ID of the spreadsheet to update. */ public java.lang.String getSpreadsheetId() { return spreadsheetId; } /** The ID of the spreadsheet to update. */ public BatchUpdate setSpreadsheetId(java.lang.String spreadsheetId) { this.spreadsheetId = spreadsheetId; return this; } @Override public BatchUpdate set(String parameterName, Object value) { return (BatchUpdate) super.set(parameterName, value); } } /** * Sets values in one or more ranges of a spreadsheet. The caller must specify the spreadsheet ID, a * valueInputOption, and one or more DataFilterValueRanges. * * Create a request for the method "values.batchUpdateByDataFilter". * * This request holds the parameters needed by the sheets server. After setting any optional * parameters, call the {@link BatchUpdateByDataFilter#execute()} method to invoke the remote * operation. * * @param spreadsheetId The ID of the spreadsheet to update. * @param content the {@link com.google.api.services.sheets.v4.model.BatchUpdateValuesByDataFilterRequest} * @return the request */ public BatchUpdateByDataFilter batchUpdateByDataFilter(java.lang.String spreadsheetId, com.google.api.services.sheets.v4.model.BatchUpdateValuesByDataFilterRequest content) throws java.io.IOException { BatchUpdateByDataFilter result = new BatchUpdateByDataFilter(spreadsheetId, content); initialize(result); return result; } public class BatchUpdateByDataFilter extends SheetsRequest { private static final String REST_PATH = "v4/spreadsheets/{spreadsheetId}/values:batchUpdateByDataFilter"; /** * Sets values in one or more ranges of a spreadsheet. The caller must specify the spreadsheet ID, * a valueInputOption, and one or more DataFilterValueRanges. * * Create a request for the method "values.batchUpdateByDataFilter". * * This request holds the parameters needed by the the sheets server. After setting any optional * parameters, call the {@link BatchUpdateByDataFilter#execute()} method to invoke the remote * operation.

{@link BatchUpdateByDataFilter#initialize(com.google.api.client.googleapis.servi * ces.AbstractGoogleClientRequest)} must be called to initialize this instance immediately after * invoking the constructor.

* * @param spreadsheetId The ID of the spreadsheet to update. * @param content the {@link com.google.api.services.sheets.v4.model.BatchUpdateValuesByDataFilterRequest} * @since 1.13 */ protected BatchUpdateByDataFilter(java.lang.String spreadsheetId, com.google.api.services.sheets.v4.model.BatchUpdateValuesByDataFilterRequest content) { super(Sheets.this, "POST", REST_PATH, content, com.google.api.services.sheets.v4.model.BatchUpdateValuesByDataFilterResponse.class); this.spreadsheetId = com.google.api.client.util.Preconditions.checkNotNull(spreadsheetId, "Required parameter spreadsheetId must be specified."); } @Override public BatchUpdateByDataFilter set$Xgafv(java.lang.String $Xgafv) { return (BatchUpdateByDataFilter) super.set$Xgafv($Xgafv); } @Override public BatchUpdateByDataFilter setAccessToken(java.lang.String accessToken) { return (BatchUpdateByDataFilter) super.setAccessToken(accessToken); } @Override public BatchUpdateByDataFilter setAlt(java.lang.String alt) { return (BatchUpdateByDataFilter) super.setAlt(alt); } @Override public BatchUpdateByDataFilter setCallback(java.lang.String callback) { return (BatchUpdateByDataFilter) super.setCallback(callback); } @Override public BatchUpdateByDataFilter setFields(java.lang.String fields) { return (BatchUpdateByDataFilter) super.setFields(fields); } @Override public BatchUpdateByDataFilter setKey(java.lang.String key) { return (BatchUpdateByDataFilter) super.setKey(key); } @Override public BatchUpdateByDataFilter setOauthToken(java.lang.String oauthToken) { return (BatchUpdateByDataFilter) super.setOauthToken(oauthToken); } @Override public BatchUpdateByDataFilter setPrettyPrint(java.lang.Boolean prettyPrint) { return (BatchUpdateByDataFilter) super.setPrettyPrint(prettyPrint); } @Override public BatchUpdateByDataFilter setQuotaUser(java.lang.String quotaUser) { return (BatchUpdateByDataFilter) super.setQuotaUser(quotaUser); } @Override public BatchUpdateByDataFilter setUploadType(java.lang.String uploadType) { return (BatchUpdateByDataFilter) super.setUploadType(uploadType); } @Override public BatchUpdateByDataFilter setUploadProtocol(java.lang.String uploadProtocol) { return (BatchUpdateByDataFilter) super.setUploadProtocol(uploadProtocol); } /** The ID of the spreadsheet to update. */ @com.google.api.client.util.Key private java.lang.String spreadsheetId; /** The ID of the spreadsheet to update. */ public java.lang.String getSpreadsheetId() { return spreadsheetId; } /** The ID of the spreadsheet to update. */ public BatchUpdateByDataFilter setSpreadsheetId(java.lang.String spreadsheetId) { this.spreadsheetId = spreadsheetId; return this; } @Override public BatchUpdateByDataFilter set(String parameterName, Object value) { return (BatchUpdateByDataFilter) super.set(parameterName, value); } } /** * 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. * * Create a request for the method "values.clear". * * This request holds the parameters needed by the sheets server. After setting any optional * parameters, call the {@link Clear#execute()} method to invoke the remote operation. * * @param spreadsheetId The ID of the spreadsheet to update. * @param range The [A1 notation or R1C1 notation](/sheets/api/guides/concepts#cell) of the values to clear. * @param content the {@link com.google.api.services.sheets.v4.model.ClearValuesRequest} * @return the request */ public Clear clear(java.lang.String spreadsheetId, java.lang.String range, com.google.api.services.sheets.v4.model.ClearValuesRequest content) throws java.io.IOException { Clear result = new Clear(spreadsheetId, range, content); initialize(result); return result; } public class Clear extends SheetsRequest { private static final String REST_PATH = "v4/spreadsheets/{spreadsheetId}/values/{range}:clear"; /** * 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. * * Create a request for the method "values.clear". * * This request holds the parameters needed by the the sheets server. After setting any optional * parameters, call the {@link Clear#execute()} method to invoke the remote operation.

{@link * Clear#initialize(com.google.api.client.googleapis.services.AbstractGoogleClientRequest)} must * be called to initialize this instance immediately after invoking the constructor.

* * @param spreadsheetId The ID of the spreadsheet to update. * @param range The [A1 notation or R1C1 notation](/sheets/api/guides/concepts#cell) of the values to clear. * @param content the {@link com.google.api.services.sheets.v4.model.ClearValuesRequest} * @since 1.13 */ protected Clear(java.lang.String spreadsheetId, java.lang.String range, com.google.api.services.sheets.v4.model.ClearValuesRequest content) { super(Sheets.this, "POST", REST_PATH, content, com.google.api.services.sheets.v4.model.ClearValuesResponse.class); this.spreadsheetId = com.google.api.client.util.Preconditions.checkNotNull(spreadsheetId, "Required parameter spreadsheetId must be specified."); this.range = com.google.api.client.util.Preconditions.checkNotNull(range, "Required parameter range must be specified."); } @Override public Clear set$Xgafv(java.lang.String $Xgafv) { return (Clear) super.set$Xgafv($Xgafv); } @Override public Clear setAccessToken(java.lang.String accessToken) { return (Clear) super.setAccessToken(accessToken); } @Override public Clear setAlt(java.lang.String alt) { return (Clear) super.setAlt(alt); } @Override public Clear setCallback(java.lang.String callback) { return (Clear) super.setCallback(callback); } @Override public Clear setFields(java.lang.String fields) { return (Clear) super.setFields(fields); } @Override public Clear setKey(java.lang.String key) { return (Clear) super.setKey(key); } @Override public Clear setOauthToken(java.lang.String oauthToken) { return (Clear) super.setOauthToken(oauthToken); } @Override public Clear setPrettyPrint(java.lang.Boolean prettyPrint) { return (Clear) super.setPrettyPrint(prettyPrint); } @Override public Clear setQuotaUser(java.lang.String quotaUser) { return (Clear) super.setQuotaUser(quotaUser); } @Override public Clear setUploadType(java.lang.String uploadType) { return (Clear) super.setUploadType(uploadType); } @Override public Clear setUploadProtocol(java.lang.String uploadProtocol) { return (Clear) super.setUploadProtocol(uploadProtocol); } /** The ID of the spreadsheet to update. */ @com.google.api.client.util.Key private java.lang.String spreadsheetId; /** The ID of the spreadsheet to update. */ public java.lang.String getSpreadsheetId() { return spreadsheetId; } /** The ID of the spreadsheet to update. */ public Clear setSpreadsheetId(java.lang.String spreadsheetId) { this.spreadsheetId = spreadsheetId; return this; } /** * The [A1 notation or R1C1 notation](/sheets/api/guides/concepts#cell) of the values to * clear. */ @com.google.api.client.util.Key private java.lang.String range; /** The [A1 notation or R1C1 notation](/sheets/api/guides/concepts#cell) of the values to clear. */ public java.lang.String getRange() { return range; } /** * The [A1 notation or R1C1 notation](/sheets/api/guides/concepts#cell) of the values to * clear. */ public Clear setRange(java.lang.String range) { this.range = range; return this; } @Override public Clear set(String parameterName, Object value) { return (Clear) super.set(parameterName, value); } } /** * Returns a range of values from a spreadsheet. The caller must specify the spreadsheet ID and a * range. * * Create a request for the method "values.get". * * This request holds the parameters needed by the sheets server. After setting any optional * parameters, call the {@link Get#execute()} method to invoke the remote operation. * * @param spreadsheetId The ID of the spreadsheet to retrieve data from. * @param range The [A1 notation or R1C1 notation](/sheets/api/guides/concepts#cell) of the range to retrieve values * from. * @return the request */ public Get get(java.lang.String spreadsheetId, java.lang.String range) throws java.io.IOException { Get result = new Get(spreadsheetId, range); initialize(result); return result; } public class Get extends SheetsRequest { private static final String REST_PATH = "v4/spreadsheets/{spreadsheetId}/values/{range}"; /** * Returns a range of values from a spreadsheet. The caller must specify the spreadsheet ID and a * range. * * Create a request for the method "values.get". * * This request holds the parameters needed by the the sheets server. After setting any optional * parameters, call the {@link Get#execute()} method to invoke the remote operation.

{@link * Get#initialize(com.google.api.client.googleapis.services.AbstractGoogleClientRequest)} must be * called to initialize this instance immediately after invoking the constructor.

* * @param spreadsheetId The ID of the spreadsheet to retrieve data from. * @param range The [A1 notation or R1C1 notation](/sheets/api/guides/concepts#cell) of the range to retrieve values * from. * @since 1.13 */ protected Get(java.lang.String spreadsheetId, java.lang.String range) { super(Sheets.this, "GET", REST_PATH, null, com.google.api.services.sheets.v4.model.ValueRange.class); this.spreadsheetId = com.google.api.client.util.Preconditions.checkNotNull(spreadsheetId, "Required parameter spreadsheetId must be specified."); this.range = com.google.api.client.util.Preconditions.checkNotNull(range, "Required parameter range must be specified."); } @Override public com.google.api.client.http.HttpResponse executeUsingHead() throws java.io.IOException { return super.executeUsingHead(); } @Override public com.google.api.client.http.HttpRequest buildHttpRequestUsingHead() throws java.io.IOException { return super.buildHttpRequestUsingHead(); } @Override public Get set$Xgafv(java.lang.String $Xgafv) { return (Get) super.set$Xgafv($Xgafv); } @Override public Get setAccessToken(java.lang.String accessToken) { return (Get) super.setAccessToken(accessToken); } @Override public Get setAlt(java.lang.String alt) { return (Get) super.setAlt(alt); } @Override public Get setCallback(java.lang.String callback) { return (Get) super.setCallback(callback); } @Override public Get setFields(java.lang.String fields) { return (Get) super.setFields(fields); } @Override public Get setKey(java.lang.String key) { return (Get) super.setKey(key); } @Override public Get setOauthToken(java.lang.String oauthToken) { return (Get) super.setOauthToken(oauthToken); } @Override public Get setPrettyPrint(java.lang.Boolean prettyPrint) { return (Get) super.setPrettyPrint(prettyPrint); } @Override public Get setQuotaUser(java.lang.String quotaUser) { return (Get) super.setQuotaUser(quotaUser); } @Override public Get setUploadType(java.lang.String uploadType) { return (Get) super.setUploadType(uploadType); } @Override public Get setUploadProtocol(java.lang.String uploadProtocol) { return (Get) super.setUploadProtocol(uploadProtocol); } /** The ID of the spreadsheet to retrieve data from. */ @com.google.api.client.util.Key private java.lang.String spreadsheetId; /** The ID of the spreadsheet to retrieve data from. */ public java.lang.String getSpreadsheetId() { return spreadsheetId; } /** The ID of the spreadsheet to retrieve data from. */ public Get setSpreadsheetId(java.lang.String spreadsheetId) { this.spreadsheetId = spreadsheetId; return this; } /** * The [A1 notation or R1C1 notation](/sheets/api/guides/concepts#cell) of the range to * retrieve values from. */ @com.google.api.client.util.Key private java.lang.String range; /** The [A1 notation or R1C1 notation](/sheets/api/guides/concepts#cell) of the range to retrieve values from. */ public java.lang.String getRange() { return range; } /** * The [A1 notation or R1C1 notation](/sheets/api/guides/concepts#cell) of the range to * retrieve values from. */ public Get setRange(java.lang.String range) { this.range = range; return this; } /** * How dates, times, and durations should be represented in the output. This is ignored if * value_render_option is FORMATTED_VALUE. The default dateTime render option is * SERIAL_NUMBER. */ @com.google.api.client.util.Key private java.lang.String dateTimeRenderOption; /** How dates, times, and durations should be represented in the output. This is ignored if value_render_option is FORMATTED_VALUE. The default dateTime render option is SERIAL_NUMBER. */ public java.lang.String getDateTimeRenderOption() { return dateTimeRenderOption; } /** * How dates, times, and durations should be represented in the output. This is ignored if * value_render_option is FORMATTED_VALUE. The default dateTime render option is * SERIAL_NUMBER. */ public Get setDateTimeRenderOption(java.lang.String dateTimeRenderOption) { this.dateTimeRenderOption = dateTimeRenderOption; return this; } /** * The major dimension that results should use. For example, if the spreadsheet data in * Sheet1 is: `A1=1,B1=2,A2=3,B2=4`, then requesting * `range=Sheet1!A1:B2?majorDimension=ROWS` returns `[[1,2],[3,4]]`, whereas requesting * `range=Sheet1!A1:B2?majorDimension=COLUMNS` returns `[[1,3],[2,4]]`. */ @com.google.api.client.util.Key private java.lang.String majorDimension; /** The major dimension that results should use. For example, if the spreadsheet data in Sheet1 is: `A1=1,B1=2,A2=3,B2=4`, then requesting `range=Sheet1!A1:B2?majorDimension=ROWS` returns `[[1,2],[3,4]]`, whereas requesting `range=Sheet1!A1:B2?majorDimension=COLUMNS` returns `[[1,3],[2,4]]`. */ public java.lang.String getMajorDimension() { return majorDimension; } /** * The major dimension that results should use. For example, if the spreadsheet data in * Sheet1 is: `A1=1,B1=2,A2=3,B2=4`, then requesting * `range=Sheet1!A1:B2?majorDimension=ROWS` returns `[[1,2],[3,4]]`, whereas requesting * `range=Sheet1!A1:B2?majorDimension=COLUMNS` returns `[[1,3],[2,4]]`. */ public Get setMajorDimension(java.lang.String majorDimension) { this.majorDimension = majorDimension; return this; } /** * How values should be represented in the output. The default render option is * FORMATTED_VALUE. */ @com.google.api.client.util.Key private java.lang.String valueRenderOption; /** How values should be represented in the output. The default render option is FORMATTED_VALUE. */ public java.lang.String getValueRenderOption() { return valueRenderOption; } /** * How values should be represented in the output. The default render option is * FORMATTED_VALUE. */ public Get setValueRenderOption(java.lang.String valueRenderOption) { this.valueRenderOption = valueRenderOption; return this; } @Override public Get set(String parameterName, Object value) { return (Get) super.set(parameterName, value); } } /** * Sets values in a range of a spreadsheet. The caller must specify the spreadsheet ID, range, and a * valueInputOption. * * Create a request for the method "values.update". * * This request holds the parameters needed by the sheets server. After setting any optional * parameters, call the {@link Update#execute()} method to invoke the remote operation. * * @param spreadsheetId The ID of the spreadsheet to update. * @param range The [A1 notation](/sheets/api/guides/concepts#cell) of the values to update. * @param content the {@link com.google.api.services.sheets.v4.model.ValueRange} * @return the request */ public Update update(java.lang.String spreadsheetId, java.lang.String range, com.google.api.services.sheets.v4.model.ValueRange content) throws java.io.IOException { Update result = new Update(spreadsheetId, range, content); initialize(result); return result; } public class Update extends SheetsRequest { private static final String REST_PATH = "v4/spreadsheets/{spreadsheetId}/values/{range}"; /** * Sets values in a range of a spreadsheet. The caller must specify the spreadsheet ID, range, and * a valueInputOption. * * Create a request for the method "values.update". * * This request holds the parameters needed by the the sheets server. After setting any optional * parameters, call the {@link Update#execute()} method to invoke the remote operation.

{@link * Update#initialize(com.google.api.client.googleapis.services.AbstractGoogleClientRequest)} must * be called to initialize this instance immediately after invoking the constructor.

* * @param spreadsheetId The ID of the spreadsheet to update. * @param range The [A1 notation](/sheets/api/guides/concepts#cell) of the values to update. * @param content the {@link com.google.api.services.sheets.v4.model.ValueRange} * @since 1.13 */ protected Update(java.lang.String spreadsheetId, java.lang.String range, com.google.api.services.sheets.v4.model.ValueRange content) { super(Sheets.this, "PUT", REST_PATH, content, com.google.api.services.sheets.v4.model.UpdateValuesResponse.class); this.spreadsheetId = com.google.api.client.util.Preconditions.checkNotNull(spreadsheetId, "Required parameter spreadsheetId must be specified."); this.range = com.google.api.client.util.Preconditions.checkNotNull(range, "Required parameter range must be specified."); } @Override public Update set$Xgafv(java.lang.String $Xgafv) { return (Update) super.set$Xgafv($Xgafv); } @Override public Update setAccessToken(java.lang.String accessToken) { return (Update) super.setAccessToken(accessToken); } @Override public Update setAlt(java.lang.String alt) { return (Update) super.setAlt(alt); } @Override public Update setCallback(java.lang.String callback) { return (Update) super.setCallback(callback); } @Override public Update setFields(java.lang.String fields) { return (Update) super.setFields(fields); } @Override public Update setKey(java.lang.String key) { return (Update) super.setKey(key); } @Override public Update setOauthToken(java.lang.String oauthToken) { return (Update) super.setOauthToken(oauthToken); } @Override public Update setPrettyPrint(java.lang.Boolean prettyPrint) { return (Update) super.setPrettyPrint(prettyPrint); } @Override public Update setQuotaUser(java.lang.String quotaUser) { return (Update) super.setQuotaUser(quotaUser); } @Override public Update setUploadType(java.lang.String uploadType) { return (Update) super.setUploadType(uploadType); } @Override public Update setUploadProtocol(java.lang.String uploadProtocol) { return (Update) super.setUploadProtocol(uploadProtocol); } /** The ID of the spreadsheet to update. */ @com.google.api.client.util.Key private java.lang.String spreadsheetId; /** The ID of the spreadsheet to update. */ public java.lang.String getSpreadsheetId() { return spreadsheetId; } /** The ID of the spreadsheet to update. */ public Update setSpreadsheetId(java.lang.String spreadsheetId) { this.spreadsheetId = spreadsheetId; return this; } /** The [A1 notation](/sheets/api/guides/concepts#cell) of the values to update. */ @com.google.api.client.util.Key private java.lang.String range; /** The [A1 notation](/sheets/api/guides/concepts#cell) of the values to update. */ public java.lang.String getRange() { return range; } /** The [A1 notation](/sheets/api/guides/concepts#cell) of the values to update. */ public Update setRange(java.lang.String range) { this.range = range; return this; } /** * Determines if the update response should include the values of the cells that were * updated. By default, responses do not include the updated values. If the range to write * was larger than the range actually written, the response includes all values in the * requested range (excluding trailing empty rows and columns). */ @com.google.api.client.util.Key private java.lang.Boolean includeValuesInResponse; /** Determines if the update response should include the values of the cells that were updated. By default, responses do not include the updated values. If the range to write was larger than the range actually written, the response includes all values in the requested range (excluding trailing empty rows and columns). */ public java.lang.Boolean getIncludeValuesInResponse() { return includeValuesInResponse; } /** * Determines if the update response should include the values of the cells that were * updated. By default, responses do not include the updated values. If the range to write * was larger than the range actually written, the response includes all values in the * requested range (excluding trailing empty rows and columns). */ public Update setIncludeValuesInResponse(java.lang.Boolean includeValuesInResponse) { this.includeValuesInResponse = includeValuesInResponse; return this; } /** * Determines how dates, times, and durations in the response should be rendered. This is * ignored if response_value_render_option is FORMATTED_VALUE. The default dateTime render * option is SERIAL_NUMBER. */ @com.google.api.client.util.Key private java.lang.String responseDateTimeRenderOption; /** Determines how dates, times, and durations in the response should be rendered. This is ignored if response_value_render_option is FORMATTED_VALUE. The default dateTime render option is SERIAL_NUMBER. */ public java.lang.String getResponseDateTimeRenderOption() { return responseDateTimeRenderOption; } /** * Determines how dates, times, and durations in the response should be rendered. This is * ignored if response_value_render_option is FORMATTED_VALUE. The default dateTime render * option is SERIAL_NUMBER. */ public Update setResponseDateTimeRenderOption(java.lang.String responseDateTimeRenderOption) { this.responseDateTimeRenderOption = responseDateTimeRenderOption; return this; } /** * Determines how values in the response should be rendered. The default render option is * FORMATTED_VALUE. */ @com.google.api.client.util.Key private java.lang.String responseValueRenderOption; /** Determines how values in the response should be rendered. The default render option is FORMATTED_VALUE. */ public java.lang.String getResponseValueRenderOption() { return responseValueRenderOption; } /** * Determines how values in the response should be rendered. The default render option is * FORMATTED_VALUE. */ public Update setResponseValueRenderOption(java.lang.String responseValueRenderOption) { this.responseValueRenderOption = responseValueRenderOption; return this; } /** How the input data should be interpreted. */ @com.google.api.client.util.Key private java.lang.String valueInputOption; /** How the input data should be interpreted. */ public java.lang.String getValueInputOption() { return valueInputOption; } /** How the input data should be interpreted. */ public Update setValueInputOption(java.lang.String valueInputOption) { this.valueInputOption = valueInputOption; return this; } @Override public Update set(String parameterName, Object value) { return (Update) super.set(parameterName, value); } } } } /** * Builder for {@link Sheets}. * *

* Implementation is not thread-safe. *

* * @since 1.3.0 */ public static final class Builder extends com.google.api.client.googleapis.services.json.AbstractGoogleJsonClient.Builder { private static String chooseEndpoint(com.google.api.client.http.HttpTransport transport) { // If the GOOGLE_API_USE_MTLS_ENDPOINT environment variable value is "always", use mTLS endpoint. // If the env variable is "auto", use mTLS endpoint if and only if the transport is mTLS. // Use the regular endpoint for all other cases. String useMtlsEndpoint = System.getenv("GOOGLE_API_USE_MTLS_ENDPOINT"); useMtlsEndpoint = useMtlsEndpoint == null ? "auto" : useMtlsEndpoint; if ("always".equals(useMtlsEndpoint) || ("auto".equals(useMtlsEndpoint) && transport != null && transport.isMtls())) { return DEFAULT_MTLS_ROOT_URL; } return DEFAULT_ROOT_URL; } /** * Returns an instance of a new builder. * * @param transport HTTP transport, which should normally be: *
    *
  • Google App Engine: * {@code com.google.api.client.extensions.appengine.http.UrlFetchTransport}
  • *
  • Android: {@code newCompatibleTransport} from * {@code com.google.api.client.extensions.android.http.AndroidHttp}
  • *
  • Java: {@link com.google.api.client.googleapis.javanet.GoogleNetHttpTransport#newTrustedTransport()} *
  • *
* @param jsonFactory JSON factory, which may be: *
    *
  • Jackson: {@code com.google.api.client.json.jackson2.JacksonFactory}
  • *
  • Google GSON: {@code com.google.api.client.json.gson.GsonFactory}
  • *
  • Android Honeycomb or higher: * {@code com.google.api.client.extensions.android.json.AndroidJsonFactory}
  • *
* @param httpRequestInitializer HTTP request initializer or {@code null} for none * @since 1.7 */ public Builder(com.google.api.client.http.HttpTransport transport, com.google.api.client.json.JsonFactory jsonFactory, com.google.api.client.http.HttpRequestInitializer httpRequestInitializer) { super( transport, jsonFactory, Builder.chooseEndpoint(transport), DEFAULT_SERVICE_PATH, httpRequestInitializer, false); setBatchPath(DEFAULT_BATCH_PATH); } /** Builds a new instance of {@link Sheets}. */ @Override public Sheets build() { return new Sheets(this); } @Override public Builder setRootUrl(String rootUrl) { return (Builder) super.setRootUrl(rootUrl); } @Override public Builder setServicePath(String servicePath) { return (Builder) super.setServicePath(servicePath); } @Override public Builder setBatchPath(String batchPath) { return (Builder) super.setBatchPath(batchPath); } @Override public Builder setHttpRequestInitializer(com.google.api.client.http.HttpRequestInitializer httpRequestInitializer) { return (Builder) super.setHttpRequestInitializer(httpRequestInitializer); } @Override public Builder setApplicationName(String applicationName) { return (Builder) super.setApplicationName(applicationName); } @Override public Builder setSuppressPatternChecks(boolean suppressPatternChecks) { return (Builder) super.setSuppressPatternChecks(suppressPatternChecks); } @Override public Builder setSuppressRequiredParameterChecks(boolean suppressRequiredParameterChecks) { return (Builder) super.setSuppressRequiredParameterChecks(suppressRequiredParameterChecks); } @Override public Builder setSuppressAllChecks(boolean suppressAllChecks) { return (Builder) super.setSuppressAllChecks(suppressAllChecks); } /** * Set the {@link SheetsRequestInitializer}. * * @since 1.12 */ public Builder setSheetsRequestInitializer( SheetsRequestInitializer sheetsRequestInitializer) { return (Builder) super.setGoogleClientRequestInitializer(sheetsRequestInitializer); } @Override public Builder setGoogleClientRequestInitializer( com.google.api.client.googleapis.services.GoogleClientRequestInitializer googleClientRequestInitializer) { return (Builder) super.setGoogleClientRequestInitializer(googleClientRequestInitializer); } @Override public Builder setUniverseDomain(String universeDomain) { return (Builder) super.setUniverseDomain(universeDomain); } } }




© 2015 - 2024 Weber Informatics LLC | Privacy Policy