New Feature for the AppSheetApp Library: Run API Calls in Parallel

AppSheet Tips & Tricks
1

In 2023 I published the open source AppSheetApp library for Google Apps Script which made it easy to use the AppSheet API in your projects. @bienlim has enhanced the AppSheetApp library with a powerful new feature: fetchAll(). This now lets you run multiple AppSheet API calls at the same time, significantly boosting the performance of your Apps Script integrations. You can find the updated library in the GitHub code repository to start using this new feature today.

Here’s an example from the repo:

/**
 * Executes multiple AppSheet API requests in parallel.
 * This example shows how to perform Add, Delete, Edit, and Find operations simultaneously.
 */
function parallelRequest(){
  // Replace with your actual App ID and Access Key
  // If you are using the library in your script project use 
  // `const AppSheet = new AppSheetApp('YOUR_APP_ID', 'YOUR_ACCESS_KEY')`;
  const AppSheet = AppSheetApp('YOUR_APP_ID', 'YOUR_ACCESS_KEY');

  // Placeholder data for demonstration
  const properties = { "Locale": "en-US" };

  // Sample data for adding a new record. The key field is usually omitted if it's auto-generated.
  const dataToAdd = [{"Name": "John Doe", "Age": 30}];

  // Sample data for editing an existing record. The key field is required to identify the row.
  const dataToEdit = [{"ID": "unique-id-123", "Age": 31}];

  // Sample data for deleting an existing record. The key field is required.
  const dataToDelete = [{"ID": "unique-id-456"}];

  // The FetchAll method takes multiple API calls as arguments.
  // The 'true' argument tells each method to return a parameter object instead of
  // making an immediate API call. These parameter objects are then passed to fetchAll().
  const responses = AppSheet.fetchAll(
    AppSheet.Add('People', dataToAdd, properties, true),
    AppSheet.Delete('People', dataToDelete, properties, true),
    AppSheet.Edit('People', dataToEdit, properties, true),
    AppSheet.Find('People', [], properties, true)
  );

  // The responses are returned in an array, in the same order as the requests.
  const [ respFromAdd, respFromDelete, respFromEdit, respFromFind ] = responses;

  // You can now handle each response individually
  console.log('Add Response:', respFromAdd);
  console.log('Delete Response:', respFromDelete);
  console.log('Edit Response:', respFromEdit);
  console.log('Find Response:', respFromFind);
}

As @bienlim highlights:

Key Changes

  • FetchAll Wrapper: All parallel method calls are now wrapped within the new AppSheet.FetchAll() helper function.

  • New Parameter: A fourth parameter, isAysnc, has been added to the method calls. Setting this boolean to true converts the function into a URL request compatible with UrlFetchApp.fetchAll(). By default, this parameter is false, so all previous functions will continue to work without any changes.

To use this you can library. Add this Script ID on your App Script Project: 1aXPRqSO_ulCdptqlpKm12o81pdOHUlxnr9n6Gw3AIXk0K8Xc_cNCbx4B

A big thank you to Bien for his contribution! :folded_hands:

13 Likes
AppSheetApp library run multiple API calls in parallel
2

Thank you for this acknowledgment! You’re AppSheetApp library was the turning point that made me double down in AppSheet as the main platform solution in all of my work!

Always grateful to contribute in the community!

6 Likes
3

I feel privileged to be surrounded by amazing people! @mhawksey @bienlim

1 Like