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 and interact with Nextcloud Tables, a collaborative table/spreadsheet service within Nextcloud. Specifically, the "Get All Columns" operation under the "Column" resource retrieves all columns from a specified table.

This operation is useful when you want to programmatically access the structure of a table, for example, to understand what data fields exist before processing or importing data. Practical scenarios include:

  • Extracting column metadata to dynamically build forms or reports.
  • Synchronizing table schemas between Nextcloud and other systems.
  • Validating data inputs against existing table columns.

Properties

Name Meaning
Table Select a table from the list or enter its ID (number). This identifies the table whose columns will be retrieved.

Output

The output JSON contains an array of column objects representing all columns in the specified table. Each column object typically includes metadata such as column ID, name, type, and other relevant attributes describing the column's properties.

No binary data output is involved in this operation.

Example output snippet (conceptual):

[
  {
    "id": 1,
    "name": "First Name",
    "type": "text",
    ...
  },
  {
    "id": 2,
    "name": "Email",
    "type": "email",
    ...
  }
]

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 Nextcloud itself.

Troubleshooting

  • Common issues:

    • Invalid or missing table ID: Ensure the table ID is correct and that the user has access permissions.
    • Authentication failures: Verify that the API key credential is valid and has sufficient rights.
    • Network connectivity problems: Confirm that the Nextcloud instance is reachable from n8n.

  • Error messages:

    • "Unknown resource": Indicates an invalid resource parameter; ensure "column" is selected.
    • API errors related to authorization or not found: Check credentials and table existence.
    • Validation error for table ID input: Make sure the table ID is numeric as required.

Links and References

Discussion