Nextcloud Tables icon

Nextcloud Tables

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

Actions31

Overview

The "Nextcloud Tables" node allows users to manage tables within Nextcloud, including operations on tables, rows, columns, views, shares, and CSV imports. Specifically, the Get Table operation retrieves information about a particular table by its ID or from a selectable list of tables.

This node is beneficial in scenarios where you want to automate workflows involving Nextcloud Tables data, such as fetching table metadata for reporting, integrating table data with other systems, or managing table contents programmatically.

Practical example:

  • Automatically retrieve a specific table's details when triggered by an event, then use that data downstream in your workflow to update another system or generate reports.

Properties

Name Meaning
Table Select a table either from a searchable list of available tables or enter its numeric ID manually.

The property supports two modes:

  • List: Search and select from existing tables.
  • ID: Enter the table ID directly (must be a number).

Output

The output JSON contains the data returned by the Nextcloud Tables API for the requested table. This typically includes the table's metadata such as its ID, name, description, columns, and other relevant attributes depending on the API response.

No binary data output is involved in this operation.

Example output structure (simplified):

{
  "id": 123,
  "name": "Example Table",
  "description": "A sample table",
  "columns": [
    {
      "id": 1,
      "name": "Column A",
      "type": "text"
    },
    {
      "id": 2,
      "name": "Column B",
      "type": "number"
    }
  ],
  ...
}

Dependencies

  • Requires an API key credential for authenticating with the Nextcloud Tables API.
  • The node depends on Nextcloud Tables being accessible via the configured API endpoint.
  • No additional external services are required beyond the Nextcloud instance.

Troubleshooting

  • Common issues:

    • Invalid table ID format: The node validates that the table ID is numeric; entering non-numeric values will cause validation errors.
    • Table not found: If the specified table ID does not exist or the user lacks permission, the API call will fail.
    • Authentication errors: Ensure the API key credential is valid and has sufficient permissions.

  • Error messages:

    • "Please enter a valid table ID (number)": Occurs if the table ID input does not match the expected numeric pattern.
    • Errors related to unknown resource or operation indicate misconfiguration of the node parameters.
    • API errors from Nextcloud (e.g., 404 Not Found, 401 Unauthorized) will be surfaced; check credentials and table existence.

  • Resolution tips:

    • Verify the table ID or select from the list to avoid typos.
    • Confirm API credentials and permissions.
    • Use the node’s "Continue On Fail" option to handle errors gracefully in workflows.

Links and References

Discussion