AppSheet
Overview
This node integrates with the AppSheet API to perform various operations on table records within an AppSheet application. Specifically, for the Read Records operation, it allows users to query and retrieve records from a specified AppSheet table using a selector expression. This is useful when you want to filter and fetch data dynamically based on conditions, such as retrieving all people aged 21 or older.
Practical examples include:
- Fetching customer records that meet certain criteria (e.g., customers in a specific region).
- Retrieving inventory items with stock below a threshold.
- Querying event records occurring after a certain date.
The node supports multiple operations beyond reading, including creating, updating, deleting records, and invoking custom actions on records.
Properties
| Name | Meaning |
|---|---|
| Region | The AppSheet region domain to use in the API URL. Options: "Global (www.appsheet.com)", "EU (eu.appsheet.com)" |
| Table Name | Name of the AppSheet table to operate on. Must be URL-encoded if needed. |
| Selector | A valid AppSheet selector expression to filter records when reading. Example: FILTER(People, [Age]>=21) |
| Locale | Locale string used for formatting dates and numbers, e.g., "en-US". |
| Location | Geographical coordinates used for context, e.g., "47.623098, -122.330184". |
| Timezone | Timezone string used for date/time formatting, e.g., "Pacific Standard Time". |
Output
The output is a JSON array containing the records returned by the AppSheet API based on the selector query. Each element corresponds to a record matching the filter criteria.
- The
jsonoutput field contains the retrieved records as objects. - No binary data output is produced by this operation.
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 corresponding to the selected region and table.
Troubleshooting
- Invalid JSON format errors: These occur if input fields expecting JSON arrays or objects (like record data) are malformed. For the Read Records operation, ensure the selector string is a valid AppSheet expression.
- Operation not supported error: If an unsupported operation value is provided, the node will throw an error.
- Authentication issues: Ensure the API key credential is correctly configured and has sufficient permissions.
- Empty or no results: Verify the selector expression matches existing records; incorrect syntax or filters may yield no data.