Overview
This node integrates with the Fireberry API to perform various data operations on Fireberry objects. It supports creating, updating, deleting, and querying records within Fireberry's data model. The node is useful for automating workflows that involve managing Fireberry data, such as syncing records, batch processing updates, or retrieving filtered datasets.
Common scenarios include:
- Querying Fireberry objects with complex filters using either a visual query builder or advanced query syntax.
- Creating single or multiple new records in Fireberry.
- Updating or deleting existing records individually or in batches.
- Sorting and limiting query results to tailor data retrieval.
Practical example: A user can automate fetching customer records from Fireberry that meet certain criteria (e.g., customers with recent activity), process them in n8n, and update their status or create related records automatically.
Properties
| Name | Meaning |
|---|---|
| Operation | The action to perform on Fireberry data. Options: Create, Create Batch, Delete, Delete Batch, Query, Update, Update Batch. |
| Object Type | The Fireberry object type to operate on. Select from available object types or specify an ID via expression. |
| Object Type Selected | Hidden boolean indicating if an object type has been selected (true/false). |
| Fields Names or IDs | For queries: fields to return in the result set. Choose from list or specify IDs via expression. |
| Query Type | Method to build the query: Visual Query Builder or Advanced Query (direct Fireberry query syntax). |
| Query | For advanced queries: the raw Fireberry query string. |
| Flattened Query Builder | For visual query building: a collection of field conditions and logical operators to construct a flattened query. |
| Sort By Name or ID | Field to sort query results by. |
| Sort Type | Sort order: Ascending or Descending. |
| Record Limit | Maximum number of records to return in a query. Empty means no limit (all records). |
| Show Real Value | Whether to show real values instead of only IDs for dropdown and lookup fields in query results. |
| Fields (Create) | Fields and their values to set when creating a record. Supports selecting dropdown values or entering text values. |
| Records (Create Batch) | JSON array of records to create in batch mode. Each record is an object with field names as keys. |
| Record ID (Update/Delete) | ID of the record to update or delete. |
| Fields (Update) | Fields and their values to update in a record. Supports dropdown value selection or text input. |
| Records (Update Batch) | JSON array of records to update in batch mode. Each item includes an id and a record object with field-value pairs. |
| Record IDs (Delete Batch) | JSON array of record IDs to delete in batch mode. |
Output
The node outputs an array of JSON objects representing the results of the performed operation:
- For query operations, the output contains the retrieved records with requested fields, optionally showing real values for dropdowns/lookups.
- For create, update, and delete operations, the output confirms success and may include the affected record IDs or details.
- For batch operations, the output includes arrays of results corresponding to each processed record.
- If errors occur and "Continue On Fail" is enabled, error details are included per item.
The node does not output binary data.
Dependencies
- Requires connection to the Fireberry API via an API key credential configured in n8n.
- 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
- Unsupported Operation Error: If an unsupported operation is selected, the node throws an error specifying the invalid operation name. Ensure the operation parameter is correctly set.
- Missing Object Type: Many operations require a valid object type selection. Omitting this will cause failures.
- Invalid Record IDs: Update and delete operations require valid record IDs; incorrect or missing IDs will cause errors.
- Query Syntax Errors: When using advanced query strings, syntax mistakes can lead to API errors. Validate query syntax carefully.
- Dropdown Value Selection: For fields with dropdown values, ensure "Use Dropdown Values" is enabled and a valid dropdown option is selected to avoid mismatches.
- API Authentication Issues: Verify that the API key credential is correctly configured and has sufficient permissions.
- Enable "Continue On Fail" to allow partial processing when some items fail, capturing error messages per item.
Links and References
- Fireberry API Documentation (example placeholder)
- n8n Expressions Documentation
- n8n Node Development Guide