Xano icon

Xano

Interact with Xano API to manage workspaces, tables, and content.

Overview

The node integrates with the Xano API to update a specific row in a table by its ID within a chosen workspace. It is useful for automating data management tasks such as modifying records in databases without manual intervention. For example, you can update user information, inventory details, or any structured data stored in Xano tables dynamically based on workflow inputs.

Properties

Name Meaning
Workspace Name or ID Select or specify the workspace where the target table resides.
Table Name or ID Select or specify the table containing the row to update.
Fields A collection of fields to update in the row. Each field includes:
- Field Name or ID The name or ID of the field/column to update in the table.
- Field Value The new value to assign to the specified field.

Output

The node outputs JSON data representing the updated row after the operation completes successfully. This output typically contains the full record with all fields reflecting the latest values, including those just updated. If the node supports binary data (not indicated here), it would represent file attachments or media related to the row.

Dependencies

  • Requires an API key credential for authenticating with the Xano API.
  • Needs proper configuration of workspace and table identifiers that exist in the connected Xano account.
  • The node depends on n8n's ability to load options dynamically for workspaces, tables, and fields via predefined methods.

Troubleshooting

  • Common Issues:
    • Incorrect workspace or table IDs may cause failures or empty results.
    • Missing or invalid API credentials will prevent successful authentication.
    • Providing field names that do not exist in the table will result in errors or ignored updates.
  • Error Messages:
    • Authentication errors indicate issues with the API key; verify and re-enter credentials.
    • Validation errors about fields usually mean the specified field does not exist or the value type is incompatible.
    • Network or timeout errors suggest connectivity problems with the Xano API endpoint.

Links and References

Discussion