AppSheet icon

AppSheet

Interact with the AppSheet API to add, read, update, delete records, or invoke a custom action on table records.
Join our community

Actions5

Overview

This node integrates with the AppSheet API to perform various operations on table records within an AppSheet application. Specifically, it supports creating, reading, updating, deleting records, and invoking custom actions on those records. The "Invoke Action" operation allows users to trigger predefined AppSheet actions programmatically, which can be useful for automating workflows such as incrementing counters, sending notifications, or applying business logic encapsulated in AppSheet actions.

Practical examples include:

  • Automatically invoking a custom action to update related data after a record is created.
  • Triggering an approval workflow action on selected rows.
  • Running batch updates or calculations defined as AppSheet actions on specific records.

Properties

Name Meaning
Region The AppSheet region domain to use in the API URL. Options: "Global (www.appsheet.com)" or "EU (eu.appsheet.com)".
Table Name The name of the AppSheet table on which the action will be invoked. This should be URL-encoded if necessary.
Action Name The name of the AppSheet action to invoke, e.g., "IncrementCountAction".
Action Properties Optional JSON object specifying additional properties for the action. For example: {"UserSettings": {"Option 1": "value1", "Option 2": "value2"}}.
Rows (for Invoke) Optional JSON array of key objects identifying the rows on which to invoke the action. Example: [ { "Product Group": "Group Key" } ].
Locale Locale string used for formatting dates and numbers, e.g., "en-US".
Location Geographical coordinates as a string, e.g., "47.623098, -122.330184".
Timezone Timezone string used for date/time formatting, e.g., "Pacific Standard Time".

Output

The node outputs a JSON array containing the response(s) from the AppSheet API after invoking the specified action. Each element corresponds to the result of the action invocation on one or more records. The exact structure depends on the AppSheet API response but generally includes details about the success or failure of the action and any data returned by it.

No binary data output is produced by this node.

Dependencies

  • Requires an API key credential for authenticating with the AppSheet API.
  • Needs the App ID of the target AppSheet application.
  • The node makes HTTP POST requests to the AppSheet API endpoint constructed using the selected region, App ID, and table name.
  • Proper configuration of locale, location, and timezone parameters may affect how dates and numbers are formatted in the request.

Troubleshooting

  • Invalid JSON format errors: The node expects certain inputs (Action Properties, Rows for Invoke) to be valid JSON strings. If these are malformed, the node throws errors indicating invalid JSON format. To resolve, ensure all JSON inputs are correctly formatted arrays or objects.
  • Unsupported operation error: If an operation other than the supported ones is selected, the node will throw an error stating the operation is not supported.
  • API authentication issues: Ensure that the API key credential is correctly configured and has sufficient permissions to perform the requested action.
  • Incorrect table or action names: Verify that the table name and action name exactly match those defined in the AppSheet app, including case sensitivity and URL encoding where necessary.
  • Empty or missing required fields: Required properties like Table Name and Action Name must be provided; otherwise, the node will fail.

Links and References

Discussion