BatchRequest was updated to v1.2.1.

• v1.2.1 (March 8, 2023)

  1. An option of exportDataAsBlob was added to the request object to the method of EDo(). Ref When this option is used, the response values from the batch requests are returned as Blob. By this, for example, when you export Google Spreadsheet as PDF data using the batch requests, the PDF data can be retrieved as Blob.

Sample script using exportDataAsBlob

In this sample, the Spreadsheet and Document files are exported as PDF format using the batch requests. The exported PDF data is created as a PDF file to the root folder. When I answered this thread on Stackoverflow, when this option is added to this library, I thought that it might be useful for users.

BatchRequest was updated to v1.2.0.

• v1.2.0 (September 30, 2022)

  1. A new method of getBatchPath(name, version) was added. After August 12, 2020, in order to use batch requests, the batch path is required to be used to the endpoint of the batch requests. And, the batch path is sometimes updated. So, when a constant batch path has been continued to be used, this might lead to the reason for an error. In this method, the batch path is retrieved from Discovery API. By this, the latest batch path can be always simply obtained from the name of Google API. And, the retrieved batch path can be used in Do(object) and EDo(object) methods.

You can check this at https://github.com/tanaikech/BatchRequest.

Gists

• Published: September 15, 2021

• Updated: September 17, 2021

  • From the discussions, added data by changing the wait time of LockService for Web Apps.

Kanshi Tanaike

Introduction

When the users try to write to a Spreadsheet using a form, the developers have to consider the concurrent submission from the form. For example, when multiple users submit the data with the form simultaneously, all data are possibly not to be saved to the Spreadsheet. So it is considered that it is important to know the information about the concurrent writing to Google Spreadsheet using a form. In this report, such a situation was investigated.

BatchRequest was updated to v1.1.3.

• v1.1.3 (January 13, 2021)

  1. In order to give the access token from outside, the access token got to be able to be included in the object. By this, for example, you can use the access token retrieved by the service account.

You can check this at https://github.com/tanaikech/BatchRequest.

BatchRequest was updated to v1.1.2.

• v1.1.1 (June 12, 2020)

  1. Error handling for the input object was added.

• v1.1.2 (June 12, 2020)

  1. Removed a bug that when the returned value is empty, an error occurred.

You can check this at https://github.com/tanaikech/BatchRequest.

BatchRequest was updated to v1.1.0.

• v1.1.0 (June 10, 2020)

  1. New method of EDo() was added. This method is the enhanced Do() method. When this method is used, the result values from the batch requests are parsed. And also, the number of requests more than 100 can be used. In this case, the split of the number of requests is processed for the limitation of 100.

You can check this at https://github.com/tanaikech/BatchRequest.

RunAll was updated to v1.1.2.

• v1.1.2 (May 31, 2020)

  1. When the access token and project ID are not included in the object, getOAuthToken() and getScriptId(). By this, an error is removed.

You can see the detail information here https://github.com/tanaikech/RunAll

RunAll was updated to v1.1.1.

• v1.1.1 (September 20, 2019)

  1. When the number of 0 was used as the argument, null was returned. This bug was removed.
  2. Coffeescript as the source was updated.

You can see the detail information here https://github.com/tanaikech/RunAll

RunAll was updated to v1.1.0.

• v1.1.0 (August 26, 2019)

  1. New method for achieving the parallel processing with Web Apps was added.

You can see the detail information here https://github.com/tanaikech/RunAll

Overview

This is a library for running Batch Requests using Google Apps Script (GAS).

Description

When users use Google’s APIs, one quota is used for one API call. When the batch request is used, several APIs can be called by one quota, although there are some limitations in the batch request. For example, in GAS, Drive API can be used be DriveApp. In this case, the quota is not used for using Drive API. (When Drive of Advanced Google Services is used, the quota is used.) But this is Drive API v2. If users want to use Drive API v3, it is required to directly request each endpoint of Drive API v3. The batch request is much useful for this situation. However, it is a bit difficult for users to use the batch request. Because the batch request is requested by multipart/mixed. I thought that the script may become a bit complicated, because of the request of multipart/mixed using UrlFetchApp. And although I had been looking for the libraries for the batch request, I couldn’t find them. So I created this.

Overview

This is a library for running the concurrent processing using only native Google Apps Script (GAS).

Description

Have you ever thought about the concurrent processing using only native Google Apps Script (GAS)? So far, I had run the concurrent processing using golang, javascript and python. But the script cannot be used by the trigger event, because these are not native GAS. Recently, it was found that the fetchAll method added by the Google’s update at January 19, 2018 is worked by the asynchronous processing. By this, the concurrent processing using the native GAS got to be able to be achieved. This library makes users work the concurrent processing of functions using the fetchAll method and the execution API. This can drastically reduce the process cost in the script. And also this can be used under the trigger event. So it is considered that it will be useful for both the limit executing time of 6 minutes for GAS and the limit total executing time of 1 hour/day for the trigger event.