The Report object
Description
Mangopay’s Reporting Service replaces the legacy reports endpoints.
The Reporting Service enables your platform to download large amounts of data in CSV format for accounting or analysis purposes.
Read about the reporting feature and how to generate a report in the guide.
The type of report to generate is specified in the ReportType. Each ReportType has different available data Columns and Filters.
Report types useful for all platforms:
USER_WALLET_TRANSACTIONS– All successful transactions crediting or debiting user wallets: pay-ins, transfers, conversions, and payouts, as well as refunds of all types and repudiations (from chargebacks).COLLECTED_FEES– Detail of transactions crediting or debiting the fees wallet: successful transactions of all types (pay-ins, transfers, refunds, payouts, etc.) that have a positive or negative fees amount.
Report types useful for platforms using Echo, Mangopay’s solution for integrations working with third-party PSPs:
ECHO_INTENT– Summary of all intents declared during the selected period, detailing the total funds expected to enter the platform’s technical wallets.ECHO_INTENT_ACTION– Summary of all operations related to intents processed during the selected period, detailing the expected money movements to be escrowed — including payments, refunds, refund reversals, and chargebacks.ECHO_SETTLEMENT– Summary of all settlement files uploaded during the selected period to initiate the reconciliation process, confirming the funds expected on the techncial wallet.ECHO_SPLIT– Summary of all splits related to intents during the selected period, detailing the transfer of funds to the declared destination.
Differences with legacy reports
- Report coverage – The
USER_WALLET_TRANSACTIONSreport provides the same data as the legacy Transactions report. A report serving the same purpose as the legacy Wallets report is planned in future. Any new types of reports developed in future will only be added to the Reporting Service. - Webhook-based notification – The Reporting Service introduces two event types for webhook notifications,
REPORT_GENERATEDandREPORT_FAILED, which replace the legacy system based on a callback URL for each report. - Transitional status – The Reporting service also introduces a new transitional
Statusvalue,GENERATING, which indicates that the report is being generated and no longer awaiting processing (PENDING). TheGENERATINGvalue may be particularly useful when the report contains large volumes of data. - Historical data availability – The Reporting Service can return data from January 1 of the previous calendar year (N-1) through to the present (N). The data availability period may vary for future report types.
- Expiry – The Reporting Service reports can be downloaded during 31 days, at which point they expire. A new report with the same data can be generated. The expiry date may vary for future report types.
- Dashboard features – The Reporting Service underpins the reporting features of the Mangopay Dashboard. In the Dashboard, you can generate and manage all reports, and schedule them for regular download.
Attributes
Max length: 128 characters (see data formats for details)
The unique identifier of the object.
Unix timestamp (UTC) of the date and time the object was created.
Max. length: 255 characters
Custom data that you can add to this object.
Unix timestamp (UTC) of the date and time the report was generated.
Returned values: PENDING, READY_FOR_DOWNLOAD, FAILED, EXPIRED
The status of the report:
PENDING– The report is being generated.READY_FOR_DOWNLOAD– The report has been created, and can be downloaded.FAILED– The report cannot be generated.EXPIRED– The report was created, but is no longer available for download (it can be re-run to be downloaded again with fresh data).
Returned values: CSV
The format in which the report is going to be downloaded.
The URL at which the report file can be downloaded when the Status is GENERATED.
Max. length: 255 characters
The URL to which the notification indicating that the report is ready to be downloaded will be sent.
Returned values: TRANSACTIONS, WALLETS
The type of the report, indicating whether it lists transactions or wallets.
Whether the report is limited to the first 10 lines (and therefore quicker to generate).
Returned values: The Columns listed in the Reports article, which differ according to the report type.
The information to be included in the report.