Nextcloud Tables icon

Nextcloud Tables

Manage your Nextcloud Tables - tables, rows, and data
Join our community

Actions31

Overview

The "Update View (AI-Friendly)" operation in the Nextcloud Tables node allows users to modify an existing table view's configuration within Nextcloud Tables. This includes updating the view's title, emoji, description, as well as applying new filter and sorting rules. It is useful for dynamically adjusting how data is presented or filtered in a collaborative table environment.

Typical use cases include:

  • Renaming a view to better reflect its purpose.
  • Changing the emoji icon associated with a view for easier identification.
  • Updating the description to provide more context.
  • Applying or modifying filters to display only relevant rows based on column values.
  • Adjusting sorting rules to reorder rows according to specific columns and directions.

For example, a user might update a project status view to only show tasks marked as "In Progress" and sort them by due date ascending.

Properties

Name Meaning
Update Configuration (AI-Friendly) Contains the main update parameters for the view.
- View ID The unique identifier of the view to update.
- New Title The new title for the view. Leave empty to keep the current title unchanged.
- New Emoji The new emoji icon for the view. Leave empty to keep the current emoji unchanged.
- New Description The new description text for the view. Leave empty to keep the current description unchanged.
Filter Configuration (AI-Friendly) Defines filtering rules to apply to the view.
- Filters A list of filter rules, each specifying:
  - Column ID The ID of the column to filter on.
  - Operator The filter operator. Valid options: EQ (equals), NEQ (not equals), GT (greater than), GTE (greater or equal), LT (less than), LTE (less or equal), LIKE (contains).
  - Value The value to compare against in the filter.
Sorting Configuration (AI-Friendly) Defines sorting rules to apply to the view.
- Sorting A list of sorting rules, each specifying:
  - Column ID The ID of the column to sort by.
  - Direction Sort direction. Valid options: ASC (ascending, e.g., A-Z or 1-9), DESC (descending, e.g., Z-A or 9-1).

Output

The node outputs JSON data representing the updated view object returned from the Nextcloud Tables API. This typically includes the view's ID, updated title, emoji, description, applied filters, and sorting configurations reflecting the changes made.

No binary data output is involved in this operation.

Dependencies

  • Requires a valid API authentication token credential configured in n8n to connect to the Nextcloud Tables API.
  • The node depends on the Nextcloud Tables service being accessible and the user having appropriate permissions to update views.
  • No additional external dependencies are required beyond the API connection.

Troubleshooting

  • Common Issues:

    • Invalid or missing View ID: Ensure the View ID provided exists and is correct.
    • Insufficient permissions: The API token must have rights to update views.
    • Incorrect filter or sorting rule formats: Verify that column IDs exist and operators/directions are valid.
    • Network or connectivity issues with the Nextcloud instance.

  • Error Messages:

    • "Unknown resource": Indicates the resource parameter was not set to "view".
    • API errors related to authorization or invalid input will be passed through; check the error message for details.

  • Resolutions:

    • Double-check all input parameters for correctness.
    • Confirm API credentials and permissions.
    • Test connectivity to the Nextcloud Tables API endpoint.
    • Use the node's "Continue On Fail" option to handle errors gracefully during batch operations.

Links and References

Discussion