Actions31
- Tabelle Actions
- View Actions
- Spalte Actions
- Share Actions
- Import Actions
- Zeile Actions
Overview
This node integrates with Nextcloud Tables to manage rows ("Zeilen") within tables or views. Specifically, the "Alle Zeilen Abrufen" (Get All Rows) operation allows users to retrieve multiple rows from either a table or a view in Nextcloud Tables. This is useful for scenarios where you want to extract bulk data for processing, reporting, or synchronization with other systems.
Practical examples include:
- Extracting all customer records from a specific table for analysis.
- Retrieving filtered and sorted project tasks from a view to feed into a dashboard.
- Paginating through large datasets by using offset and limit options.
Properties
| Name | Meaning |
|---|---|
| Quelle | Choose whether to work with a Table ("Tabelle") or a View ("View"). |
| Tabelle | Select a specific table by choosing from a list or entering its numeric ID. Only shown if "Quelle" is set to "Tabelle". |
| View | Select a specific view by choosing from a list or entering its numeric ID. Only shown if "Quelle" is set to "View". |
| Zusätzliche Optionen | Additional options to control the query: |
| - Limit | Maximum number of rows to return (1–1000). Recommended between 50-200 for performance. |
| - Offset | Number of rows to skip for pagination (e.g., offset=50 for page 2 with limit=50). |
| - Filter aktivieren | Enable filtering of rows based on column values. |
| - Sortierung aktivieren | Enable sorting of rows by one or more columns. The first sort rule has the highest priority. |
| - Suche aktivieren | Enable full-text search across text columns. |
| Filter (if enabled) | Define one or more filter rules: |
| - Spalte | Column to apply the filter on. |
| - Operator | Comparison operator, e.g., equals, not equals, greater than, contains, starts with, ends with, is empty, etc. |
| - Wert | Value to compare against (leave empty for "is empty"/"is not empty" operators). |
| Sortierung (if enabled) | Define one or more sorting rules: |
| - Spalte | Column to sort by. |
| - Richtung | Direction of sorting: ascending (A-Z, 1-9, oldest first) or descending (Z-A, 9-1, newest first). |
| Suche (if enabled) | Configure full-text search: |
| - Suchbegriff | Search term to look for in text columns. |
| - Nur spezifische Spalten durchsuchen | Optionally restrict search to specific columns; leave empty to search all text columns. |
| - Groß-/Kleinschreibung beachten | Whether the search should be case sensitive. |
Output
The node outputs an array of JSON objects representing the retrieved rows. Each item corresponds to one row from the selected table or view, containing key-value pairs where keys are column identifiers or names and values are the respective cell contents.
If binary data were involved (not indicated here), it would be included in the binary property of each output item, but this operation focuses on JSON row data only.
Dependencies
- Requires a configured API authentication credential for Nextcloud Tables.
- The node depends on Nextcloud Tables API endpoints to fetch tables, views, columns, and rows.
- Proper permissions on the Nextcloud instance to read tables or views are necessary.
Troubleshooting
- Invalid Table/View ID: If the provided table or view ID does not exist or is inaccessible, the node will throw an error. Verify the ID and permissions.
- Filter or Sorting Misconfiguration: Incorrect column selections or unsupported operators may cause errors or unexpected results. Ensure columns exist and operators match column data types.
- API Rate Limits or Timeouts: Large limits or complex queries might hit API rate limits or time out. Use smaller limits and offsets for pagination.
- Empty Results: If filters or search terms are too restrictive, no rows may be returned. Try relaxing criteria.
- Credential Issues: Missing or invalid API credentials will prevent successful connection.
Links and References
- Nextcloud Tables Documentation
- Nextcloud API Reference
- n8n Documentation on Creating Custom Nodes