HelixDB

Interact with HelixDB - the time-series database for modern applications. Requires HelixDB server running with deployed HelixQL queries.

Actions8

Record → Update

AI-generated

Overview

This node interacts with HelixDB to update an existing record in a specified table. It is useful in scenarios where you need to modify data entries in a time-series database, such as updating user information, sensor data, or any other record stored in HelixDB. For example, updating a user's profile details or correcting a data point in a time-series dataset.

Use Case Examples

  1. Updating a user record in the 'users' table by specifying the record ID and new data.
  2. Modifying an existing sensor reading in a 'sensor_data' table by providing the record ID and updated values.

Properties

Name Meaning
Table Name Specifies the name of the table where the record to be updated resides.
Record ID The unique identifier of the record to update.
Record Data The new data for the record, provided as a JSON object.

Output

JSON

  • json - The updated record data returned from HelixDB after the update operation.

Dependencies

  • Requires HelixDB server running with deployed HelixQL queries.
  • Needs an API key credential for HelixDB authentication.

Troubleshooting

  • Common issues include providing an incorrect table name or record ID, which will cause the update operation to fail.
  • Errors may occur if the HelixDB server is not reachable or the API credentials are invalid.
  • If the record data JSON is malformed, the update will not succeed.

Links

Discussion