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 to manage table columns, specifically supporting the creation of new columns in a "KI-Friendly" (AI-friendly) manner. The "Spalte Erstellen (KI-Friendly)" operation allows users to create a new column within a specified table, defining detailed attributes such as type, title, description, default values, validation patterns, and other metadata tailored for AI-friendly data handling.

Typical use cases include:

  • Automating the addition of structured columns to Nextcloud Tables based on AI-driven workflows.
  • Creating columns with specific constraints and defaults to ensure data consistency.
  • Defining columns that support various data types like text, numbers, dates, selections, or user/group references, useful in collaborative or data-intensive environments.

For example, you might use this node to add a new "Status" selection column with predefined options or a numeric column with min/max constraints to a project management table.

Properties

Name Meaning
tableIdAI The ID of the table where the new column will be created (used only for the "createAIFriendly" operation).
columnType The type of the column. Valid values: text, number, datetime, selection, usergroup.
columnTitle The title/name of the column.
columnDescription Optional description of the column.
columnMandatory Whether this column is mandatory (required field).
textSubtypeAI Subtype for text columns; valid values: line (single line), long (multi-line). Ignored for other column types.
textDefaultAI Default value for new rows in text columns. Ignored for other types.
textMaxLengthAI Maximum number of characters allowed in text columns. Ignored for other types.
textPatternAI Regex pattern for validating text input. Ignored for other types.
numberDefaultAI Default numeric value for new rows. Ignored for other types.
numberMinAI Minimum allowed numeric value. Ignored for other types.
numberMaxAI Maximum allowed numeric value. Ignored for other types.
numberDecimalsAI Number of decimal places allowed. Ignored for other types.
numberPrefixAI Text prefix displayed before the number (e.g., currency symbol). Ignored for other types.
numberSuffixAI Text suffix displayed after the number (e.g., unit). Ignored for other types.
datetimeDefaultAI Default date/time value in ISO 8601 format or "today". Ignored for other types.
selectionOptionsAI JSON array string of selection options (e.g., ["Option 1", "Option 2"]). Ignored for other types.
selectionDefaultAI Default selected option (must be one of the options). Ignored for other types.
selectionMultipleAI Whether multiple selection options can be chosen simultaneously. Ignored for other types.
usergroupTypeAI Type of user/group selection; valid values: user (individual users), group (groups). Ignored for other types.
usergroupDefaultAI Default user or group selected. Ignored for other types.
usergroupMultipleAI Whether multiple users/groups can be selected simultaneously. Ignored for other types.

Output

The node outputs JSON data representing the result of the column creation operation. This typically includes details about the newly created column such as its ID, type, title, and any metadata returned by the Nextcloud Tables API.

No binary data output is produced by 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 to authorize requests to Nextcloud Tables.
  • The node relies on internal handlers for managing columns but does not require additional external services beyond Nextcloud itself.

Troubleshooting

  • Common issues:

    • Invalid or missing tableIdAI: The operation requires a valid table ID to create a column. Ensure the table ID is correct and accessible.
    • Incorrect columnType or mismatched subtype/default values: Make sure the column type matches the provided subtype and default values.
    • Malformed JSON in selectionOptionsAI: The selection options must be a valid JSON array string.
    • Permission errors: The API credentials must have sufficient permissions to modify tables and columns.

  • Error messages:

    • "Unknown resource": Indicates the resource parameter is incorrect; ensure it is set to "column".
    • Validation errors from Nextcloud API: Usually due to invalid property values; verify all inputs conform to expected formats and constraints.
    • Network or authentication failures: Check API credentials and network connectivity.

To resolve errors, verify all input parameters carefully, especially those related to the column's type-specific settings, and confirm API credentials are valid.

Links and References

Discussion