Actions26
- Collections Actions
- Records Actions
- Fields Actions
- Chats Actions
- Files Actions
- User Contacts Actions
- Triggers Actions
Overview
This node interacts with the Cogfy Tables API to perform calculations on specific records within a collection. The "Calculate Records" operation allows users to specify a collection, select particular records by their IDs, and define a field for which some calculation will be performed. This is useful in scenarios where you need to aggregate or compute values dynamically based on selected records, such as summing sales figures, averaging scores, or applying custom formulas on data fields.
Practical examples:
- Calculating the total sales amount from a subset of transaction records.
- Computing the average rating from selected customer feedback entries.
- Applying a custom formula to update a calculated field across multiple records.
Properties
| Name | Meaning |
|---|---|
| Collection Id | The identifier of the collection containing the records to be calculated. |
| Field Id | The ID of the specific field within the records on which the calculation will be done. |
| Record Ids | A JSON array containing the IDs of the records that should be included in the calculation. |
Output
The node outputs JSON data representing the result of the calculation performed on the specified records and field. The exact structure depends on the API response but generally includes the calculated value(s) related to the requested field and records.
No binary data output is indicated.
Dependencies
- Requires an API key credential for authenticating with the Cogfy Tables API.
- The base URL for the API must be configured in the node credentials.
- Uses the
@amonlibanio/n8n-openapi-nodepackage internally to build request properties from the OpenAPI specification.
Troubleshooting
- Invalid Collection Id or Field Id: If these identifiers are incorrect or do not exist, the API will likely return an error. Verify the IDs before running the node.
- Malformed Record Ids JSON: The
Record Idsproperty expects a valid JSON array string. Invalid JSON will cause parsing errors. Ensure the input is correctly formatted. - Authentication Errors: Missing or invalid API credentials will prevent successful requests. Confirm that the API key and base URL are correctly set.
- Empty Results: If no records match the provided IDs or if the field has no calculable data, the output may be empty or null.