Glide icon

Glide

Interact with Glide Tables API

Overview

This node integrates with the Glide Tables API to perform operations on tables within a specified Glide App. Specifically, the "Edit Row" operation allows users to update existing rows in a Glide Table by specifying the row ID and the columns to modify.

Common scenarios where this node is beneficial include:

  • Automating updates to data stored in Glide Tables based on external triggers or workflows.
  • Synchronizing data changes from other systems into a Glide App.
  • Modifying specific records programmatically without manual intervention.

For example, you could use this node to update user information in a Glide Table when a form submission occurs elsewhere, or to correct data entries automatically based on validation rules.

Properties

Name Meaning
App ID The Glide App in which to operate. Can be selected from a list of available apps or provided as an ID string.
Table Name The Glide Table within the selected app to operate on. Selectable from a list filtered by the chosen App ID or provided as an ID string.
Columns The columns and their new values to set in the row. Supports mapping multiple columns; all fields can be added.
Row ID The unique identifier of the row to edit within the table. Required to specify which row to update.

Output

The node outputs a JSON array containing the results of the mutation request sent to the Glide API. Each item corresponds to the response for each input item processed.

The json output field typically contains confirmation of the updated rows or any relevant metadata returned by the Glide API after editing the rows.

This node does not output binary data.

Dependencies

  • Requires an API key credential for authenticating requests to the Glide API.
  • Needs network access to https://api.glideapp.io and https://functions.prod.internal.glideapps.com.
  • The node uses internal helper methods to handle authentication and HTTP requests.
  • The "App ID" and "Table Name" properties depend on dynamic loading options that query available apps and tables via the Glide API.

Troubleshooting

  • Operation not supported: This error occurs if an unsupported operation is requested. Ensure the operation parameter is correctly set to "editRow" for editing rows.
  • Resource not supported: Thrown if the resource parameter is not "table". Confirm the resource selection matches the intended target.
  • Invalid Row ID: If the specified row ID does not exist or is incorrect, the API may return an error or no changes will occur. Verify the row ID is accurate.
  • Authentication errors: If the API key or credentials are missing or invalid, requests will fail. Check that the required API authentication token is configured properly.
  • Network issues: Failures connecting to the Glide API endpoints can cause errors. Ensure network connectivity and that the API URLs are accessible.

Links and References

Discussion