Glide Apps icon

Glide Apps

Interact with Glide Apps API
Join our community

Actions17

Overview

This node interacts with Glide Apps APIs to retrieve rows from a specified table. It supports two API types: the Big Tables API (OpenAPI) and the Glide NPM API. The "Get Table Rows" operation fetches multiple rows from a given table, optionally limiting the number of rows returned and supporting pagination through continuation tokens.

Common scenarios include:

  • Extracting data from Glide tables for further processing or integration.
  • Paginating through large datasets in Glide tables.
  • Using different API methods depending on user preference or API availability.

Practical example:

  • Fetching up to 100 rows from a customer database table in Glide to sync with another system.
  • Iterating through all rows in a Glide table by using continuation tokens to handle large datasets.

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 fetch rows (e.g., 2a1bad8b-cf7c-44437-b8c1-e3782df6). Required when using the Big Tables API (OpenAPI).
Limit Maximum number of rows to return in a single response. The node will return no more than this number, but possibly fewer. If there are more rows available, a continuation token is included for fetching subsequent rows.
Continuation A continuation token from a previous response to fetch the next set of rows. If omitted, the first set of rows is returned.
Usage Tips (Visible only when using the Glide NPM API) Helpful tips such as using row limits and search filters to avoid loading too much data, enabling confirmation for large tables, filtering columns by type, and expression support.

Output

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

If the node supports binary data output (not explicitly shown here), it would typically represent attachments or files associated with rows, but this operation focuses on JSON row data.

Dependencies

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

Troubleshooting

  • Empty or incomplete row results:
    Ensure the correct Table ID is provided and that the API key has sufficient permissions. Use the continuation token to paginate through all rows if the dataset is large.

  • Invalid continuation token errors:
    Verify that the continuation token used is from the most recent response and has not expired.

  • Authentication failures:
    Confirm that the API key credential is valid and correctly configured in n8n.

  • Large data loads causing timeouts or performance issues:
    Use the Limit property to restrict the number of rows fetched per request. When using the NPM API, enable confirmation prompts and apply filters to reduce data volume.

Links and References

Discussion