Nextcloud Tables icon

Nextcloud Tables

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

Actions31

Overview

The "Create Row" operation in the Nextcloud Tables node allows users to add a new row of data into a specified table or view within their Nextcloud Tables environment. This is useful for automating data entry, integrating external data sources, or programmatically managing tabular data stored in Nextcloud.

Common scenarios include:

  • Automatically adding form submission data into a Nextcloud Table.
  • Syncing data from other applications by creating rows in Nextcloud Tables.
  • Populating views or tables with new records based on workflow triggers.

For example, you might use this node to create a new customer record in a sales table whenever a new lead is captured in a CRM system.

Properties

Name Meaning
Source Choose whether to create the row directly in a Table or in a View (filtered subset).
Table Select the target table by choosing from a list or entering its numeric ID (required if Source is Table).
View Select the target view by choosing from a list or entering its numeric ID (required if Source is View).
Row Data Define one or more columns and their values for the new row. Each column is selected by its ID, and a value is provided. Values can be expressions.

Output

The node outputs JSON data representing the newly created row as returned by the Nextcloud Tables API. This typically includes the row's unique identifier and the data fields with their values.

If the node supports binary data output (not indicated here), it would represent any file attachments or binary content associated with the row, but this operation focuses on JSON data only.

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.
  • Proper permissions are needed to create rows in the specified table or view.

Troubleshooting

  • Invalid Table or View ID: Ensure that the entered ID is numeric and corresponds to an existing table or view. Use the list mode to select from available resources to avoid typos.
  • Missing Required Fields: The "Row Data" must include at least one column with a valid column ID and value.
  • Permission Errors: Verify that the API key has sufficient rights to create rows in the target table or view.
  • API Connectivity Issues: Check network connectivity and API endpoint configuration.
  • Error Messages: If the node throws errors related to unknown resources or operations, confirm that the resource is set to "Row" and operation to "Create Row".

Links and References

Discussion