WeeDB String Update

Update a WeeDB string

Overview

The WeeDB String Update node allows you to update a string record in a WeeDB database by specifying an ID and new data. Optionally, if the record does not exist, it can create a new one. This node is useful for workflows that need to modify or upsert (update or insert) simple string values in a WeeDB instance, such as updating user settings, storing temporary tokens, or managing configuration values.

Example scenarios:

  • Updating a user's profile description by their unique ID.
  • Storing or modifying application state or configuration strings.
  • Creating a new record if it doesn't already exist, ensuring idempotent updates.

Properties

Display Name Type Description
ID String ID to Fetch. The unique identifier of the record to update or create.
Data String String Data to Update. The new string value to store in the record.
Cerate Boolean Create record if not exist. If enabled, creates a new record with the specified ID and data if it does not already exist.

Output

The node outputs a JSON object containing the updated or created item. The structure is:

{
  "item": {
    // The full record as returned by WeeDB after update or creation.
    // Fields depend on WeeDB's schema but will at least include the updated data.
  }
}
  • The output is always a JSON array with a single object containing the item field.
  • No binary data is produced.

Dependencies

  • WeeDB Connection: Requires valid credentials for a WeeDB database (weeDBConnection), specifically the databaseId.
  • n8n Configuration: Ensure the WeeDB credential is set up in n8n under the name weeDBConnection.

Troubleshooting

Common issues:

  • Missing Credentials:
    Error: Failed to initialize WeeDB
    Resolution: Make sure the WeeDB credentials are correctly configured in n8n and the databaseId is valid.

  • Invalid ID or Data:
    If the ID or Data fields are empty or invalid, the operation may fail or not behave as expected. Always provide valid, non-empty values.

  • Record Not Found (when 'Cerate' is false):
    If you attempt to update a non-existent record without enabling "Cerate", the operation may fail. Enable "Cerate" to allow automatic creation.

Links and References

Discussion