Nextcloud Tables icon

Nextcloud Tables

Verwalten Sie Ihre Nextcloud Tables - Tabellen, Zeilen und Daten
Join our community

Actions31

Overview

This node integrates with Nextcloud Tables, allowing users to manage tables, rows, columns, views, shares, and imports within their Nextcloud environment. Specifically, the "View Erstellen (KI-Friendly)" operation under the "View" resource enables creating customized table views using AI-friendly configurations. This is useful for automating the creation of filtered and sorted views on Nextcloud tables, which can help users quickly access relevant subsets of data tailored to specific needs.

Practical examples include:

  • Creating a view that filters rows based on certain column values (e.g., only show tasks with status "open").
  • Sorting a view by priority or due date.
  • Adding descriptive titles and emojis to views for better visual identification.

Properties

Name Meaning
View-Konfiguration (AI-Friendly) Basis-Konfiguration für die neue View:
- Titel: The title of the new view.
- Tabellen-ID: The ID of the table for which the view is created.
- Emoji: Optional emoji representing the view.
- Beschreibung: Optional description of the view.
Filter-Konfiguration (AI-Friendly) Filter rules for the view:
- Multiple filter rules can be added.
- Each filter rule includes:
  • Spalten-ID (Column ID to filter)
  • Operator: EQ, NEQ, GT, GTE, LT, LTE, LIKE
  • Wert (Value to filter by)
Sortierungs-Konfiguration (AI-Friendly) Sorting rules for the view:
- Multiple sorting rules can be added.
- Each sorting rule includes:
  • Spalten-ID (Column ID to sort)
  • Richtung (Direction): ASC (ascending), DESC (descending)

Output

The node outputs JSON objects representing the result of the executed operation. For the "View Erstellen (KI-Friendly)" operation, the output JSON contains the details of the newly created view as returned by the Nextcloud Tables API. This typically includes identifiers, configuration details (title, description, emoji), applied filters, and sorting rules.

No binary data output is indicated in the source code or property definitions.

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 to authorize requests to Nextcloud Tables.
  • The node depends on internal handler modules for managing tables, rows, views, columns, shares, and imports, but these are bundled internally and do not require separate installation.

Troubleshooting

  • Common issues:

    • Invalid or missing table ID when creating a view will cause errors.
    • Incorrect filter or sort operator values may lead to API rejections.
    • Network connectivity problems or invalid API credentials will prevent successful operations.

  • Error messages:

    • "Unknown resource" error if an unsupported resource is selected.
    • API errors from Nextcloud (e.g., permission denied, invalid parameters) will be propagated.

  • Resolutions:

    • Verify that the table ID exists and is accessible.
    • Ensure filter operators and sort directions use valid values as specified.
    • Confirm API credentials are correctly set up and have sufficient permissions.
    • Use the "Continue On Fail" option in n8n to handle errors gracefully during batch executions.

Links and References

Discussion