Nextcloud Tables icon

Nextcloud Tables

Verwalten Sie Ihre Nextcloud Tables - Tabellen, Zeilen und Daten

Overview

This node integrates with Nextcloud Tables, allowing users to manage tables, views, columns, shares, imports, and rows within their Nextcloud environment. Specifically, the "Spalte" (Column) resource with the operation "Alle Spalten Abrufen" (Get All Columns) enables retrieving all columns from a specified table.

Common scenarios for this node include:

  • Automating data extraction from Nextcloud Tables for reporting or synchronization.
  • Dynamically fetching column metadata to build custom forms or interfaces.
  • Integrating Nextcloud Tables data into workflows that require schema awareness.

For example, a user might want to fetch all columns of a particular table to understand its structure before inserting or updating rows programmatically.

Properties

Name Meaning
Tabelle Select a table either from a searchable list or by entering its numeric ID. This identifies the table whose columns will be retrieved.

The property supports two modes:

  • List: Search and select from available tables.
  • ID: Directly input the numeric table ID.

Output

The output is an array of JSON objects, each representing the result of the executed operation per input item.

For the "Alle Spalten Abrufen" operation under the "Spalte" resource, the json output contains the details of all columns in the specified table. This typically includes column metadata such as column names, types, IDs, and other relevant attributes defined by Nextcloud Tables.

No binary data output is produced by this operation.

Dependencies

  • Requires a valid API authentication token credential configured in n8n to connect to Nextcloud Tables.
  • The node depends on Nextcloud Tables API endpoints to perform operations.
  • No additional external services are required beyond the Nextcloud instance hosting the Tables app.

Troubleshooting

  • Invalid Table ID: If the table ID provided does not exist or is incorrect, the node will throw an error indicating the table could not be found. Verify the table ID or use the list mode to select a valid table.
  • Authentication Errors: Ensure the API key or authentication token is correctly set up and has sufficient permissions to access the tables.
  • Network Issues: Connectivity problems with the Nextcloud server can cause timeouts or failures. Check network settings and server availability.
  • Unknown Resource or Operation: The node throws errors if an unsupported resource or operation is selected. Confirm that "Spalte" and "Alle Spalten Abrufen" are chosen correctly.

If the node is set to continue on failure, errors will be returned in the output JSON under an error field instead of stopping execution.

Links and References

Discussion