Runtah

The APIs for three of Apps Scripts advanced services — Analytics, BigQuery, and Prediction — will undergo breaking changes on Monday, November 18. If you dont update your code to the new syntax before then, youll receive error messages such as Required parameter is missing.

Advanced services allow you to easily connect to certain public Google APIs from Apps Script. Were working to expand and improve our advanced services, and as a side effect some methods and parameters that were incorrectly listed as optional are now required.

On November 18, these services will switch to use the new method signatures shown in the tables below. To learn how new arguments should be structured, refer to the documentation for the underlying API. For example, the documentation for the BigQuery services Jobs.query()method shows the valid properties for the resource object in the "Request body" section of the page.

.deleteUploadData(
    accountId, 
    webPropertyId, 
    customDataSourceId, 
    optionalArgs)

.deleteUploadData(
    resource, 
    accountId, 
    webPropertyId, 
    customDataSourceId)

.insert(
    resource, 
    optionalArgs)

.insert(
    resource, 
    projectId)

.update(
    resource,
    optionalArgs)

.update(
    resource, 
    projectId,
    datasetId)

.insert(
    resource, 
    mediaData,
    optionalArgs)

.insert(
    resource, 
    projectId, 
    mediaData)

.query(
    projectId,
    query)

.query(
    resource,
    projectId)

.insertAll(
    projectId,
    datasetId, 
    tableId,
    optionalArgs)

.insertAll(
    resource,
    projectId, 
    datasetId, 
    tableId)

.insert(
    resource,
    optionalArgs)

.insert(
    resource, 
    projectId,
    datasetId)

.update(
    resource, 
    optionalArgs)

.update(
    resource, 
    projectId,
    datasetId,
    tableId)

.predict(
    project, 
    hostedModelName, 
    optionalArgs)

.predict(
    resource,
    project, 
    hostedModelName)

.insert(
    project, 
    optionalArgs)

.insert(
    resource,
    project)

.predict(
    project, 
    id, 
    optionalArgs)

.predict(
    resource, 
    project, 
    id)

.update(
    project, 
    id, 
    optionalArgs)

.update(
    resource, 
    project, 
    id)

If you want to prepare your code ahead of time, you can add a try/catch around your existing code that retries with the new method signature if the old one fails. For example, the following sample applies this approach to the BigQuery services Jobs.query() method:

  var result;
  try {
    result = BigQuery.Jobs.query(projectId, query, {
      timeoutMs: 10000
    });
  } catch (e) {
    // Refer to the BigQuery documentation for the structure of the 
    // resource object.
    var resource = {
      query: query,
      timeoutMs: 1000
    };
    result = BigQuery.Jobs.query(resource, projectId);
  }

We apologize for inconvenience and look forward to sharing exciting news about advanced services in the coming weeks.

Eric Koleda profile Eric is a Developer Programs Engineer based in NYC on the Google Apps Script team. Hes previously worked with the AdWords API and enterprise content management software.