Glide Apps icon

Glide Apps

Interact with Glide Apps API
Join our community

Actions17

Overview

This node interacts with Glide Apps APIs to retrieve information about table rows. Specifically, the "Get Table Rows Info" operation fetches metadata or details about rows in a specified table within a Glide App. This is useful for scenarios where you want to analyze or manipulate data stored in Glide tables without manually accessing the app interface.

Practical examples include:

  • Automating reports by fetching row data from a Glide table.
  • Integrating Glide table data into other workflows or systems.
  • Validating or auditing data entries programmatically.

The node supports two API types: the Big Tables API via OpenAPI and the Glide NPM API package, allowing flexibility depending on user preference or environment.

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 to fetch rows info from (required when using the OpenAPI method). Example format: 2a1bad8b-cf7c-44437-b8c1-e3782df6
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 to prevent accidental data loads.
- Use Column Type Filter to show only certain column types.
- All dropdowns support expressions for advanced use.

Output

The node outputs JSON data representing the rows' information retrieved from the specified Glide table. The exact structure depends on the API used but generally includes an array of row objects with their properties and metadata.

If binary data were involved, it would be summarized here; however, this node focuses on JSON data output related to table rows.

Dependencies

  • Requires an API key credential for Glide Apps API authentication.
  • Supports two API methods:
    • Big Tables API accessed via OpenAPI specification.
    • Glide NPM API package (@glideapps/Tables).
  • The node uses helper functions to load options dynamically for apps, tables, rows, and columns.
  • Requires network access to https://api.glideapps.com.

Troubleshooting

  • Common Issues:
    • Invalid or missing API credentials will cause authentication failures.
    • Incorrect Table ID or App ID may result in empty responses or errors.
    • Large tables without row limits or confirmation enabled might lead to performance issues or timeouts.
  • Error Messages:
    • Errors returned from the API are caught and presented as error messages in the node output.
    • If no rows are found, the output will be an empty array.
  • Resolutions:
    • Verify that the API key credential is correctly configured.
    • Double-check the Table ID and App ID values.
    • Use row limits and search filters to reduce data volume.
    • Enable confirmation prompts for large data fetches to avoid accidental overload.

Links and References

Discussion