Nextcloud Tables icon

Nextcloud Tables

Manage your Nextcloud Tables - tables, rows, and data
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 Column resource with the Update Column (AI-Friendly) operation, it updates the properties of an existing column in a Nextcloud Table.

This operation is useful when you want to modify metadata or constraints of a column, such as changing its title, description, type, default values, validation patterns, or selection options. It supports various column types including text, number, datetime, selection, and user/group references, each with their own specific configurable attributes.

Practical examples:

  • Updating a text column to have a multiline input with a regex pattern validation.
  • Changing a number column to allow decimals and setting minimum/maximum allowed values.
  • Modifying a selection column to add new options or change whether multiple selections are allowed.
  • Adjusting a user/group column to switch between single or multiple selections.

Properties

Name Meaning
columnType Type of the column. Valid values: text, number, datetime, selection, usergroup. Optional for update operation.
columnTitle The title/name of the column. Optional for update operation.
columnDescription Optional description of the column.
columnMandatory Boolean indicating if the column is required.
textSubtypeAI For text columns only: subtype of text input. Valid values: line (single line), long (multiline).
textDefaultAI Default text value for new rows (text columns only).
textMaxLengthAI Maximum number of characters allowed (text columns only).
textPatternAI Regex pattern string for validating text input (text columns only).
numberDefaultAI Default numeric value for new rows (number columns only).
numberMinAI Minimum allowed numeric value (number columns only).
numberMaxAI Maximum allowed numeric value (number columns only).
numberDecimalsAI Number of decimal places allowed (number columns only).
numberPrefixAI Text prefix displayed before the number, e.g., currency symbol (number columns only).
numberSuffixAI Text suffix displayed after the number, e.g., unit of measure (number columns only).
datetimeDefaultAI Default date/time value in ISO 8601 format or "today" (datetime columns only).
selectionOptionsAI JSON array string representing selection options, e.g., ["Option 1", "Option 2"] (selection columns only).
selectionDefaultAI Default selected option (must be one of the options) (selection columns only).
selectionMultipleAI Boolean indicating if multiple options can be selected (selection columns only).
usergroupTypeAI Type of user/group selection. Valid values: user, group (usergroup columns only).
usergroupDefaultAI Default user or group selected (usergroup columns only).
usergroupMultipleAI Boolean indicating if multiple users/groups can be selected (usergroup columns only).
columnIdAI ID of the column to update. Required for update operation.

Output

The node outputs an array of JSON objects, each representing the result of the update operation on a column. The exact structure depends on the API response from Nextcloud Tables but generally includes updated column metadata such as ID, title, type, and other properties reflecting the changes made.

No binary data output is indicated for this operation.

Dependencies

  • Requires connection to a Nextcloud instance with the Tables app enabled.
  • Needs an API authentication credential configured in n8n to authorize requests to Nextcloud Tables API.
  • The node internally uses handlers and helper modules to perform API calls and manage operations.

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 specified columnType (e.g., setting textMaxLengthAI for a number column) will be ignored or may cause unexpected behavior.
    • Incorrect date format in datetimeDefaultAI other than ISO 8601 or "today" may lead to validation errors.

  • Error messages:

    • Errors related to authentication failure indicate misconfigured or missing API credentials.
    • Validation errors from the API may specify which property is invalid or missing.
    • Network or connectivity errors suggest issues reaching the Nextcloud server.

  • Resolutions:

    • Ensure the columnIdAI is correctly set to the column you intend to update.
    • Validate JSON strings before inputting them into selection options.
    • Match property usage strictly to the column type.
    • Confirm API credentials and network access to the Nextcloud instance.

Links and References

Discussion