Biron icon

Biron

Interact with Biron API, for reverse ETL and more

Actions2

Nexus → Query Nexus

AI-generated

Summary

Execute a NexusQL (SQL-like) query against a specified Biron Nexus workspace to extract qualified data.

Inputs

  • Workspace (required) — The Biron Nexus workspace identifier to query against, e.g. 'birondemo_prod'.
  • NexusQL Request (required) — The NexusQL query string to run, formulated in a SQL-like syntax to extract data from the workspace.

Output shape

A list of JSON objects representing rows returned by the query.

The output corresponds to the parsed rows from the NexusQL query response. Each output item is paired with the input item index. If the backend connection fails or a CAN signal is received, an error is thrown, unless continue on fail is enabled.

Examples

Example 1: Querying a Biron Nexus workspace to retrieve metric data for a specific date range.

Set 'Workspace' to your targeted Biron Nexus workspace name and provide the NexusQL query under 'NexusQL Request'. The node returns the query results as an array of JSON objects, each representing a row of data retrieved from the workspace.

Links

Discussion