Nextcloud Tables icon

Nextcloud Tables

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

Actions31

Overview

The node enables creating a new row in a Nextcloud Table or View using an AI-friendly input format. It is designed to simplify the process of adding data by allowing users to specify column values directly, which the node then translates into the appropriate API calls to insert the row.

This operation is beneficial when you want to programmatically add structured data entries into Nextcloud Tables or Views without manually handling complex API details. For example, you might use it to log form submissions, append records from another system, or automate data collection workflows.

Properties

Name Meaning
Data Source (AI-Friendly) Configuration of the data source for the operation. Choose whether to use a table or view and specify its ID. Options:
- Source Type: "table" or "view"
- Table ID: The ID of the table (required if Source Type is "table")
- View ID: The ID of the view (required if Source Type is "view")
Row Data (AI-Friendly) Configuration of the row data to create. Specify one or more columns with their IDs and corresponding values to be inserted in the new row.

Details on Row Data property:

  • Column Data: Multiple columns can be added.
    • Column ID: Identifier of the column where the value will be inserted.
    • Value: The value to set for that column in the new row.

Output

The output JSON contains the response from the Nextcloud Tables API after creating the row. This typically includes details about the newly created row such as its unique identifier and the stored column values.

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

Dependencies

  • Requires a valid API key credential for authenticating with the Nextcloud Tables API.
  • The node depends on the Nextcloud Tables service being accessible and properly configured.
  • No additional environment variables are explicitly required beyond the API authentication.

Troubleshooting

  • Common issues:

    • Providing an invalid or missing Table ID or View ID will cause the operation to fail.
    • Incorrect Column IDs or mismatched data types may result in errors or rejected rows.
    • Network connectivity problems or invalid API credentials will prevent successful execution.

  • Error messages:

    • "Unknown resource": Indicates the resource parameter is incorrect; ensure "row" is selected.
    • API errors returned from Nextcloud Tables will be passed through; check the error message for details like permission issues or invalid data.

  • Resolution tips:

    • Verify that the Table or View IDs exist and are accessible with your credentials.
    • Confirm that all required columns have valid IDs and values.
    • Check API credentials and network access to Nextcloud.

Links and References

Discussion