Nextcloud Tables icon

Nextcloud Tables

Verwalten Sie Ihre Nextcloud Tables - Tabellen, Zeilen und Daten

Overview

The "Nextcloud Tables" node allows users to manage data within Nextcloud Tables, including operations on tables, views, columns, shares, imports, and rows. Specifically, the "Zeile Abrufen" (Get Row) operation under the "Zeile" (Row) resource retrieves a single row from a specified table by its ID.

This node is beneficial when you want to programmatically access specific rows in your Nextcloud Tables for further processing, integration, or automation workflows. For example, you might use it to fetch user data stored in a table by row ID to update another system or trigger notifications based on that data.

Properties

Name Meaning
Zeilen-ID The ID of the row to retrieve. This is a required string input where you specify the row's unique identifier.
Tabelle The table containing the row. You can select the table either from a searchable list of available tables or enter the table ID directly (must be numeric). This is a required property.

Output

The output JSON contains the data of the requested row from the specified table. The structure corresponds to the fields defined in the Nextcloud Table for that row, typically as key-value pairs representing column names and their values.

If the node supports binary data output (not explicitly shown here), it would represent any file attachments or binary content associated with the row, but this operation primarily returns JSON data representing the row's content.

Example output snippet:

{
  "id": "123",
  "column1": "value1",
  "column2": "value2",
  ...
}

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 hosting the tables.

Troubleshooting

  • Common Issues:

    • Invalid or missing row ID: Ensure the "Zeilen-ID" is correctly provided and exists in the specified table.
    • Incorrect table ID: Verify the table ID is numeric and corresponds to an existing table.
    • Authentication errors: Confirm that the API key credential is valid and has sufficient permissions.
    • Network or connectivity issues with the Nextcloud server.
  • Error Messages:

    • "Unbekannte Ressource" (Unknown Resource): Occurs if the resource parameter is incorrect; ensure "Zeile" is selected.
    • API errors related to row not found or permission denied will be returned from the Nextcloud API and surfaced by the node.
  • Resolution:

    • Double-check all input parameters.
    • Validate credentials and network access.
    • Use the node's "Continue On Fail" option to handle errors gracefully in workflows.

Links and References

Discussion