Glide Apps icon

Glide Apps

Interact with Glide Apps API
Join our community

Actions17

Overview

This node integrates with Glide Apps APIs to retrieve multiple rows ("Get Many" operation) from a specified table within a Glide app. It supports two API types: the Big Tables API via OpenAPI and the Glide NPM API client. The node is useful for scenarios where you want to fetch bulk data from Glide tables, such as syncing Glide app data with other systems, performing batch processing, or generating reports.

Practical examples include:

  • Extracting all user records from a Glide app table to update a CRM.
  • Fetching product inventory data for analytics.
  • Loading filtered subsets of rows based on search criteria or column types.

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 Guidance shown only when using the Glide Npm Api:
- 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.

Additional properties relevant to the "Get Many" operation (implied from usage tips and load options methods):

  • App Name or ID: Select or specify the Glide app to query.
  • Table Name or ID: Select or specify the table within the app to fetch rows from.
  • Row Search: Text filter applied across all columns to narrow down rows.
  • Row Limit: Maximum number of rows to fetch (default 20, max 200).
  • Confirm Row Fetch: Boolean flag to enable confirmation before fetching rows from large tables.
  • Column Type Filter: Filter columns by type (Boolean, Date, Number, Other, Text) to limit visible columns in dropdowns.

Output

The node outputs JSON data representing the rows fetched from the specified Glide table. Each item in the output corresponds to a row object containing its fields and values as retrieved from the Glide API.

If binary data were involved, it would be summarized here, but this node focuses on JSON row data only.

Dependencies

  • Requires an API key credential for authenticating with the Glide Apps API.
  • Supports two API clients:
    • Big Tables API accessed via OpenAPI specification.
    • Glide NPM API client (@glideapps/Tables package).
  • Node configuration requires setting up credentials with a valid Glide API token.
  • Network access to https://api.glideapps.com is necessary.

Troubleshooting

  • Large Data Loads: Fetching many rows without limits or filters can cause performance issues or timeouts. Use "Row Limit", "Row Search", and "Confirm Row Fetch" to control data volume.
  • Authentication Errors: Ensure the API key credential is correctly configured and has sufficient permissions.
  • Empty Results: Verify that the App ID and Table Name are correct and that the table contains data matching any search/filter criteria.
  • Dropdown Loading Issues: If dropdowns for apps, tables, or rows do not populate, check network connectivity and API token validity.
  • Column Type Filter Not Working: Make sure the selected column types exist in the target table.

Links and References

Discussion