Nextcloud Tables icon

Nextcloud Tables

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

Actions31

Overview

The node "Nextcloud Tables" allows managing Nextcloud Tables resources such as tables, views, columns, shares, imports, and rows. Specifically, for the resource Spalte (Column) with the operation Spalte Aktualisieren (KI-Friendly) (Update Column AI-Friendly), it updates an existing column in a Nextcloud Table with AI-friendly properties.

This operation is useful when you want to programmatically modify the metadata and configuration of a table column, including its type, title, description, validation rules, default values, and other attributes that enhance AI integration or user interaction.

Practical examples:

  • Updating a text column to have a multiline input with a regex pattern validation.
  • Changing a number column's allowed range and decimal precision.
  • Modifying selection options or default selections for dropdown-type columns.
  • Adjusting user/group selection columns to allow multiple selections or change defaults.

Properties

Name Meaning
columnIdAI The ID of the column to update (required for this operation).
columnType The type of the column. Valid values: text, number, datetime, selection, usergroup. Optional for update.
columnTitle The title/name of the column. Optional for update.
columnDescription Optional description of the column.
columnMandatory Whether this column is mandatory (required field). Boolean.
textSubtypeAI Subtype for text columns. Valid values: line (single line), long (multi-line). Ignored for other 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 options can be selected simultaneously. Boolean. Ignored for other types.
usergroupTypeAI Type of user/group selection. Valid values: user (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. Boolean. Ignored for other types.

Output

The output of the node is a JSON object representing the updated column data returned from the Nextcloud Tables API. This typically includes the updated properties of the column such as its ID, type, title, description, validation rules, default values, and other metadata reflecting the changes made.

No binary data output is indicated for this operation.

Dependencies

  • Requires connection to a Nextcloud instance with the Nextcloud Tables app installed.
  • Requires an API key or authentication token credential configured in n8n to access the Nextcloud Tables API.
  • The node depends on internal handlers for columns (ColumnHandler) to perform the update operation via API calls.

Troubleshooting

  • Common issues:

    • Providing an invalid or missing columnIdAI will cause the update to fail because the target column cannot be identified.
    • Supplying invalid JSON in selectionOptionsAI will likely cause parsing errors.
    • Using incompatible property values for the column type (e.g., setting textMaxLengthAI on a number column) will be ignored or may cause unexpected behavior.
    • Incorrect date/time format in datetimeDefaultAI may lead to API rejection.

  • Error messages:

    • Errors indicating unknown resource or operation suggest misconfiguration of the node parameters.
    • API errors related to authorization indicate missing or invalid credentials.
    • Validation errors from the API may occur if required fields are missing or constraints are violated.

  • Resolutions:

    • Ensure columnIdAI is correctly set to the ID of the column you want to update.
    • Validate JSON strings before inputting them into selection options.
    • Match property usage to the column type.
    • Use ISO 8601 format or "today" for date/time defaults.

Links and References

Discussion