Actions17
- Tables Actions
- Rows Actions
- Stashes Actions
Overview
This node allows you to interact with Glide Apps tables and rows, specifically enabling you to retrieve a single row from a Glide table. It supports two different API methods for accessing Glide data: the Big Tables API via OpenAPI specification and the Glide NPM API client. This flexibility lets users choose the integration method that best fits their environment or preferences.
Common scenarios include:
- Fetching detailed information about a specific record in a Glide table.
- Using the retrieved row data as input for further automation workflows.
- Integrating Glide data into other systems by extracting individual rows dynamically.
For example, you might use this node to get a user's profile details stored in a Glide table by specifying the app, table, and row ID, then use that data to send a personalized email.
Properties
| Name | Meaning |
|---|---|
| API Type | Choose which Glide API to use for this operation: - Big Tables API (OpenAPI) - Glide Npm Api (@glideapps/Tables) |
| Usage Tips | (Shown only when using the NPM API) Helpful tips for efficient usage: - Use Row Limit and Row Search to avoid loading too much data. - Enable Confirm Row Fetch for large tables. - Use Column Type Filter to limit columns shown. - All dropdowns support expressions. |
Additional relevant properties for the "Get Row" operation (when using the NPM API):
| Name | Meaning |
|---|---|
| App Name or ID | Select or specify the Glide app from which to fetch the row. |
| Table Name or ID | Select or specify the table within the app containing the row. |
| Row Name or ID | Select or specify the unique identifier of the row to retrieve. |
| Column Name or ID | (Optional) Select or specify a column to filter or focus on. |
| Column Type Filter | (Optional) Filter columns by type (Boolean, Date, Number, Other, Text) to narrow down column selection. |
Output
The node outputs JSON data representing the requested row from the specified Glide table. The structure typically includes all fields and values of that row as key-value pairs.
If binary data were involved (not indicated here), it would be summarized accordingly, but this node focuses on JSON row data.
Dependencies
- Requires an API authentication token credential for Glide Apps.
- Supports two API methods:
- Big Tables API accessed via OpenAPI specification.
- Glide NPM API client (
@glideapps/Tables).
- The node uses helper functions to load dynamic options such as apps, tables, rows, and columns based on the selected API type.
- Network access to
https://api.glideapps.comis required for API calls.
Troubleshooting
- Empty or missing row data: Ensure the correct App ID, Table Name/ID, and Row ID are provided. Verify that the row exists in the specified table.
- Authentication errors: Confirm that the API key or token credential is valid and has sufficient permissions.
- Large table performance issues: When using the NPM API, enable "Confirm Row Fetch" and use "Row Limit" and "Row Search" filters to prevent loading excessive data.
- Dropdown loading failures: If dynamic dropdowns for apps, tables, or rows do not populate, check network connectivity and API credentials.
- Error messages including "Error: ...": These indicate exceptions caught during option loading or execution; review the error message for clues and verify parameters and credentials.