Actions99
- Group Accounts Actions
- Group Account Codes Actions
- Accounts Actions
- Expenses Actions
- Purchase Orders Actions
- Get A List Of Purchase Orders
- Create A New Purchase Order
- Get A Purchase Order
- Update A Purchase Order
- Open A Purchase Order
- Get A List Of Purchase Orders Items For A Specific Purchase Order
- Create A Purchase Order Item
- Get A Purchase Order Item
- Update A Purchase Order Item
- Delete A Purchase Order Item
- Get A List Of Goods Received Notes For A Specific Purchase Order
- Create A Goods Received Note
- Attach A File To A Goods Received Note
- Delete A Goods Received Note
- Cards Actions
- Suppliers Actions
- Fund Accounts Actions
- Expense Categories Actions
- Tax Rates Actions
- Amortizations Actions
- Account Teams Actions
- Account Codes Actions
- External Teams Actions
- Custom Fields Actions
- Get Custom Fields
- Create A New Custom Field
- Get Custom Field
- Update Custom Field
- Delete A Custom Field And All Its Values
- Get Custom Field Values
- Create A Custom Field Value
- Delete Custom Field Values
- Get A Custom Field Value
- Update A Custom Field Value
- Delete A Custom Field Value
- Get Managers For A Specific Custom Field Value
- Adds Managers For A Specific Custom Field Value
- Replaces Managers For A Specific Custom Field Value
- Removes Managers For A Specific Custom Field Value
- Webhook Subscriptions Actions
- Group Teams Actions
Overview
This node operation retrieves the bank statement for a specific fund account within a financial system. It allows users to query detailed transaction records or statements associated with a particular fund account, filtered and sorted according to user-defined criteria. This is useful in scenarios where you need to audit transactions, reconcile accounts, or generate reports on fund account activities.
For example, a finance team could use this node to fetch all bank statement entries for a given fund account over a certain date range, ordered by transaction date, to verify payments and receipts.
Properties
| Name | Meaning |
|---|---|
| Account Id | Identifier of the account to which the fund account belongs. |
| Fund Account Id | Identifier of the specific fund account whose bank statement is being requested. |
| Filter | A JSON-stringified and URL-encoded filter expression object that defines criteria to narrow down the bank statement results. It conforms to a schema allowing complex filtering such as by date ranges or other attributes. |
| Skip | Number of objects (bank statement entries) to skip from the beginning of the result set, useful for pagination. |
| Take | Maximum number of bank statement objects to return, controlling the size of the result set. |
| Order By | A JSON-stringified and URL-encoded sort expression object defining how to order the returned bank statement entries, e.g., by date ascending or descending. |
Output
The output contains a JSON array of bank statement entries corresponding to the specified fund account. Each entry typically includes details such as transaction dates, amounts, descriptions, and other relevant banking information. The structure follows the API's bank statement schema.
If the node supports binary data output (not indicated here), it would represent downloadable bank statement files or attachments; however, based on the provided code and properties, the output is purely JSON data representing the bank statement records.
Dependencies
- Requires an API key credential or similar authentication token configured in n8n to access the external financial service API.
- The node depends on the external API endpoint that provides fund account bank statements.
- Proper base URL configuration for the API must be set in the credentials or node settings.
Troubleshooting
Common issues:
- Invalid or missing
Account IdorFund Account Idwill cause the API request to fail. - Malformed JSON in the
FilterorOrder Byfields can lead to errors; ensure these are correctly stringified and URL-encoded. - Pagination parameters (
SkipandTake) set incorrectly might result in empty responses or incomplete data. - Network or authentication errors if API credentials are not properly configured.
- Invalid or missing
Error messages:
- "Unauthorized" or "Authentication failed": Check that the API key or authentication token is valid and correctly set up.
- "Invalid filter format": Verify the JSON structure of the filter parameter.
- "Resource not found": Confirm that the provided account and fund account IDs exist and are correct.
Links and References
- Refer to the external API documentation for the fund account bank statement endpoint for detailed schema and examples.
- n8n documentation on using JSON and URL encoding in node parameters.
- General best practices for API authentication and error handling in n8n workflows.