Nextcloud Tables icon

Nextcloud Tables

Manage your Nextcloud Tables - tables, rows, and data

Overview

The node provides integration with Nextcloud Tables, allowing users to manage tables, views, columns, shares, imports, and rows within their Nextcloud environment. Specifically, the "Delete Column" operation under the "Column" resource enables users to delete a specified column from a table in Nextcloud Tables.

This operation is useful when you want to clean up or restructure your table by removing unnecessary or obsolete columns. For example, if a project phase ends and certain data fields are no longer relevant, you can use this node to remove those columns programmatically as part of an automated workflow.

Properties

Name Meaning
Column Select a column to delete either by choosing from a searchable list of existing columns or by entering the column's numeric ID directly.
  • The "Column" property supports two modes:
    • List: Search and select from available columns.
    • ID: Enter the numeric ID of the column manually (must be a number).

Output

The node outputs JSON data representing the result of the delete operation. Typically, this will include confirmation details such as success status or metadata about the deleted column. The exact structure depends on the API response from Nextcloud Tables but generally confirms that the column was successfully deleted.

No binary data output is involved in this operation.

Dependencies

  • Requires an active connection to a Nextcloud instance with the Tables app enabled.
  • Needs an API authentication token or API key credential configured in n8n for accessing Nextcloud Tables.
  • The node relies on Nextcloud Tables REST API endpoints to perform operations on columns.

Troubleshooting

  • Common issues:

    • Invalid column ID format: The column ID must be a numeric string; otherwise, validation will fail.
    • Column not found: If the specified column does not exist or has already been deleted, the API may return an error.
    • Authentication errors: Ensure the API credentials are valid and have sufficient permissions to modify tables.
    • Network or connectivity problems with the Nextcloud server.
  • Error messages:

    • "Please enter a valid Column ID (number)": Occurs if the entered column ID is not numeric.
    • Errors related to unknown resource or operation indicate misconfiguration of the node parameters.
    • API errors returned from Nextcloud will be passed through; check the message for details like permission denied or resource not found.
  • Resolution tips:

    • Double-check the column ID or select it from the list to avoid typos.
    • Verify API credentials and permissions.
    • Confirm the Nextcloud Tables app is installed and accessible.
    • Use the node’s "Continue On Fail" option to handle errors gracefully in workflows.

Links and References

Discussion