Overview
This node allows querying records from Fireberry, a data platform, using either a visual query builder or an advanced query syntax. It is useful for retrieving specific data objects with fine-grained filtering, sorting, and field selection capabilities.
Typical use cases include:
- Fetching filtered datasets based on complex conditions without writing raw queries.
- Retrieving only selected fields to optimize data transfer.
- Sorting and limiting results for pagination or summary views.
- Using advanced query strings for users familiar with Fireberry's query language.
For example, you can visually build a query to find all records where "status" equals "active" and "createdDate" is after a certain date, or write an advanced query string like ((status = active) and (createdDate > 2023-01-01)).
Properties
| Name | Meaning |
|---|---|
| Object Type Name or ID | The Fireberry object type to query. Choose from a list or specify an ID via expression. |
| Fields Names or IDs | List of fields to return in the query result. Select from available fields or specify IDs via expression. |
| Query Type | Method to create the query: either "Visual Query Builder" (build query with UI) or "Advanced Query" (write Fireberry query string directly). |
| Query | Fireberry query string used when "Advanced Query" is selected. Example: ((field1 = value1) and (field2 is-not-null)). |
| Flattened Query Builder | Collection of query items for building a flattened visual query with field conditions and logical operators (AND/OR). Includes support for field name, operator, value, dropdown values, and grouping logic. |
| Sort By Name or ID | Field to sort the query results by. Choose from available fields or specify an ID via expression. |
| Sort Type | Sort order: Ascending or Descending. |
| Record Limit | Maximum number of records to return. Leave empty to return all matching records. |
| Show Real Value | Whether to show real values instead of only IDs for dropdown and lookup fields. |
Query Builder Operators Supported
- Equality and inequality (
=,!=) - Comparison (
<,<=,>,>=) - Containment (
contain,not-contain) - Null checks (
is-null,is-not-null) - String start checks (
start-with,not-start-with)
Output
The node outputs JSON data representing the queried records from Fireberry. Each item corresponds to a record with fields as keys and their respective values.
If dropdown or lookup fields are included and "Show Real Value" is enabled, the output will contain human-readable values instead of just internal IDs.
No binary data output is produced by this node.
Dependencies
- Requires an API key credential for authenticating with the Fireberry API.
- Depends on Fireberry service availability and correct configuration of API credentials in n8n.
- Uses internal methods to load options dynamically for object types, fields, and dropdown values.
Troubleshooting
Common issues:
- Invalid or missing API credentials will cause authentication failures.
- Selecting an invalid object type or field may result in errors or empty results.
- Incorrectly formatted advanced query strings can cause query parsing errors.
- Exceeding record limits or requesting too many fields may impact performance.
Error messages:
"The operation \"query\" is not supported!"— indicates an unsupported operation was requested; ensure "Query" is selected.- Errors related to query syntax usually indicate malformed advanced query strings; verify syntax against Fireberry documentation.
- Network or authentication errors suggest checking API key validity and network connectivity.
Links and References
- Fireberry API Documentation
- n8n Expressions Documentation
- Fireberry Query Syntax Guide (hypothetical link for query language reference)