Overview
This node enables querying records from Fireberry, a data platform that supports complex object types and flexible queries. It is designed to retrieve data by specifying an object type and applying filters through either a visual query builder or an advanced query syntax.
Common scenarios include:
- Fetching specific records from Fireberry based on field conditions.
- Building complex queries with logical operators (AND/OR) and grouping.
- Sorting and limiting the number of returned records.
- Selecting specific fields to optimize data retrieval.
Practical example: You want to get all customer records where the "status" field is "active" and the "lastPurchaseDate" is within the last 30 days, sorted by the most recent purchase date, returning only the customer's name and email fields.
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 | The fields to return in the query results. Select multiple fields or specify IDs via expression. |
| Query Type | Method to create the query: either "Visual Query Builder" for building queries with a UI or "Advanced Query" to write raw Fireberry query strings. |
| Query | The raw Fireberry query string used when "Advanced Query" is selected. Example: ((field1 = value1) and (field2 is-not-null)). |
| Flattened Query Builder | A collection of query items for the visual builder mode, including field conditions and logical group separators (AND/OR). Each condition specifies a field, operator, and value or dropdown selection. |
| 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. This affects how field values are presented in the output. |
Details on Flattened Query Builder Items
- Item Type: Either a "Field Condition" (e.g., Field = Value) or a "Logic Group Separator" (AND/OR grouping).
- Field Name or ID: The field to apply the condition on.
- Operator: Comparison operators such as
=,!=,<,>,contain,is-null, etc. - Use Dropdown Values: For dropdown fields, whether to select from predefined dropdown options.
- Value / Dropdown Value: The value to compare against, either free text or selected dropdown option.
- Join With: Logical operator ("AND" or "OR") to join this condition with the next one.
- Logic Operator: For group separators, defines how grouped conditions combine ("AND" or "OR").
Output
The node outputs JSON data representing the queried records from Fireberry. Each item corresponds to a record and contains the requested fields with their values.
- If "Show Real Value" is enabled, dropdown and lookup fields will display their actual values rather than just internal IDs.
- The output does not include binary data.
Example output structure (simplified):
[
{
"field1": "value1",
"field2": "value2",
...
},
...
]
Dependencies
- Requires an API key credential for authenticating with the Fireberry API.
- Depends on Fireberry's REST API endpoints to fetch objects, fields, dropdown values, and execute queries.
- Uses internal methods to load options dynamically for object types, fields, and dropdown values.
- No additional external dependencies beyond the Fireberry API and n8n environment.
Troubleshooting
- Empty Results: Ensure the object type and fields are correctly specified. Verify the query conditions match existing records.
- Invalid Query Syntax: When using the advanced query mode, syntax errors in the Fireberry query string can cause failures. Validate the query string format carefully.
- Dropdown Value Issues: If dropdown values do not appear or cannot be selected, check that the object type and field support dropdowns and that the "Use Dropdown Values" option is enabled.
- API Authentication Errors: Confirm that the API key credential is valid and has sufficient permissions.
- Unsupported Operation Error: Occurs if an operation other than those implemented (query, create, update, delete, batch variants) is specified.