HelixDB

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

Actions8

Record → Insert

AI-generated

Overview

This node interacts with HelixDB, specifically to insert new records into a specified table within the database. It is useful for applications that need to add data entries dynamically to a time-series database, such as logging user activities, storing sensor data, or managing application state changes.

Use Case Examples

  1. Inserting a new user record into a 'users' table with user details as JSON data.
  2. Adding a new sensor reading to a 'sensorData' table with timestamped values.

Properties

Name Meaning
Table Name Specifies the name of the table in HelixDB where the new record will be inserted.
Record Data The JSON object representing the data of the record to be inserted into the specified table.

Output

JSON

  • json - The JSON response from HelixDB after inserting the record, typically containing details of the inserted record or operation status.

Dependencies

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

Troubleshooting

  • Common issues include incorrect table names or malformed JSON data causing query failures.
  • Errors like 'Unsupported operation' indicate a mismatch in resource or operation parameters.
  • Ensure the HelixDB server is accessible and the API credentials are valid to avoid connection errors.

Links

  • HelixDB Documentation - Official documentation for HelixDB including setup, query language, and API usage.

Discussion