HelixDB

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

Actions8

Record → Get

AI-generated

Overview

This node interacts with HelixDB to retrieve a specific record by its ID from a specified table. It is useful in scenarios where you need to fetch detailed information about a single record stored in HelixDB, such as retrieving user details, transaction records, or any other entity stored in a table by its unique identifier.

Use Case Examples

  1. Fetching a user record by user ID from the 'users' table.
  2. Retrieving a specific order record by order ID from the 'orders' table.

Properties

Name Meaning
Table Name Specifies the name of the table in HelixDB from which to retrieve the record.
Record ID The unique identifier of the record to retrieve from the specified table.

Output

JSON

  • json - The retrieved record data as a JSON object.

Dependencies

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

Troubleshooting

  • If the record ID does not exist, the node may return an error or empty result; verify the ID is correct.
  • Ensure the table name matches exactly the table deployed in HelixDB.
  • Common error: 'Unsupported operation' if resource or operation parameters are incorrect; verify parameters.
  • Connection errors may occur if HelixDB server is not reachable or credentials are invalid.

Discussion