Skip to main content

Transactions report (CSV)

Overview

You can build integrations to automatically deliver reports to counterparties via FTP or other protocols. This page includes a downloadable CSV report template as well as information on how to make generated reports accessible to the FA Connector microservice that connects FA with external systems.

Import the template in the jsreport UI. Once the template is imported, you can generate the report from FA Back (for more information, see Generate reports for portfoliosin FA User guide).

Transactions_report_CSV.png

Highlights

This sample includes the following:

  • a GraphQL query to fetch transactions for selected portfolios over a selected time period

  • JavaScript logic to merge the transactions over multiple portfolios and sort them prior to rendering

  • a Handlebars CSV template that addresses issues related to special characters:

    • double quotation marks around certain fields to handle strings containing CSV delimiter characters

    • triple curly brackets around certain fields to prevent Handlebar's HTML-escaping with HTML-reserved characters such as & and =

Files

sample-transactionReportCSV.jsrexport

Making generated reports accessible to FA Connector

To deliver report files automatically using integrations, you need to make them available to the FA Connector microservice. You can do this by setting the Folder name to outbound (or outbound/[report_folder_name]) in the Report window. The generated report(s) will now be routed to the back-writable/reports-outbound folder that is accessible to FA Connector.

To learn how to set up a Camel route to send files via FTP, see the File integrationssection.