Glide Apps icon

Glide Apps

Interact with Glide Apps API
Join our community

Actions17

Overview

This node allows you to retrieve a specific row from a Glide table by its unique row ID. It supports two API types: the Big Tables API (OpenAPI) and the Glide NPM API. This operation is useful when you need to fetch detailed data for a single record in a Glide app's table, such as retrieving user information, order details, or any other entity stored in a table.

Practical examples include:

  • Fetching a user's profile data by their row ID.
  • Retrieving a specific order or transaction record for processing.
  • Accessing configuration or settings stored in a particular row.

Properties

Name Meaning
API Type Choose which Glide API to use for this operation:
- Big Tables API (OpenAPI)
- Glide Npm Api (@glideapps/Tables)
Table ID The unique identifier of the table from which to get the row (e.g., 2a1bad8b-cf7c-44437-b8c1-e3782df6). Required when using the OpenAPI option.
Row ID The unique identifier of the row to retrieve (e.g., zcJWnyI8Tbam21V34K8MNA). Required when using the OpenAPI option.
Usage Tips (Shown only if 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 to prevent accidental data loads.
- Use Column Type Filter to show only certain column types.
- All dropdowns support expressions for advanced use.

Output

The output contains the JSON representation of the requested row's data from the specified Glide table. This includes all columns and their values for that row.

If binary data were supported (not indicated here), it would represent file attachments or media associated with the row, but this operation focuses on JSON data retrieval.

Dependencies

  • Requires an API key credential for authenticating with the Glide Apps API.
  • Supports two API methods:
    • Big Tables API via OpenAPI specification.
    • Glide NPM API (@glideapps/Tables package).
  • The node uses the Glide Apps base URL https://api.glideapps.com.
  • For the NPM API, additional configuration such as selecting App ID, Table Name, and Row ID is required.

Troubleshooting

  • Invalid Table ID or Row ID: Ensure the IDs are correct and exist in the Glide app. Incorrect IDs will result in errors or empty responses.
  • Authentication Errors: Verify that the API key credential is valid and has sufficient permissions.
  • Large Table Handling: When using the NPM API, fetching rows without limits or confirmation may cause performance issues. Use the provided usage tips to limit data fetched.
  • Empty or Unexpected Output: Check that the row exists and that the correct API type is selected matching your setup.
  • Network Issues: Ensure network connectivity to api.glideapps.com and no firewall blocks.

Links and References

Discussion