Glide Apps icon

Glide Apps

Interact with Glide Apps API
Join our community

Actions17

Overview

This node operation "Import Table From Url" under the "Tables" resource allows users to import a table into Glide Apps by fetching it from a specified URL. It supports two API types: the Big Tables API (OpenAPI) and the Glide Npm API. The node is useful for automating the ingestion of external tabular data into Glide Apps, enabling workflows that integrate external data sources seamlessly.

Common scenarios include:

  • Importing CSV or JSON tables hosted on a web server into Glide Apps.
  • Automating data synchronization from external systems by periodically importing updated tables.
  • Linking imported tables to one or more Glide apps automatically.

Practical example:

  • A user has a public URL hosting a CSV file with product inventory data. Using this node, they can import that table directly into their Glide app and link it to multiple apps for real-time inventory updates.

Properties

Name Meaning
API Type Choose which Glide API to use for this operation:
- Big Tables API (OpenAPI)
- Glide Npm Api (@glideapps/Tables)
Apps To Link An array of app IDs to link the new table to. This can be provided either as a query parameter or in the request body depending on the API type.
On Schema Error Action to take when the imported data does not match the existing table schema:
- abort: Abort the operation and return an error.
- dropColumns: Ignore columns causing errors.
- updateSchema: Update schema to accommodate new/mismatched columns and then import.
From Url The URL of the table to fetch from. Required if no name is passed in the request body. It is an error to pass a name both in the query parameter and the request body.
Usage Tips (Only shown when using the npm API) Helpful tips for 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 show certain column types.
- All dropdowns support expressions.

Output

The node outputs JSON data representing the imported table's details after successful import. This typically includes metadata about the table and confirmation of the import operation.

If binary data output is supported (not explicitly indicated here), it would represent the raw table data fetched from the URL.

Dependencies

  • Requires an API key credential for Glide Apps API authentication.
  • Supports two API methods:
    • Big Tables API via OpenAPI specification.
    • Glide Npm API (@glideapps/Tables package).
  • The node expects network access to the URL specified in the "From Url" property to fetch the table data.

Troubleshooting

  • Error: Passing name in both URL and request body
    Ensure you do not specify the table name both as a query parameter and in the request body simultaneously.

  • Schema mismatch errors
    If the imported data schema differs from the existing table schema, choose the appropriate "On Schema Error" action to handle it. Selecting abort will stop the import on mismatch; updateSchema will attempt to fix schema differences automatically.

  • Invalid or inaccessible URL
    Verify that the URL provided in "From Url" is correct, publicly accessible, and returns valid table data.

  • API authentication failures
    Check that the API key credential is correctly configured and has sufficient permissions.

Links and References

Discussion