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_TRANSACTIONS report 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_GENERATED and REPORT_FAILED, which replace the legacy system based on a callback URL for each report.
  • Transitional status – The Reporting service also introduces a new transitional Status value, GENERATING, which indicates that the report is being generated and no longer awaiting processing (PENDING). The GENERATING value 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.

Read more about reports

Attributes

IdstringOptional

Max length: 128 characters (see data formats for details)

The unique identifier of the object.

CreationDateintegerOptional

Unix timestamp (UTC) of the date and time the object was created.

TagstringOptional

Max. length: 255 characters

Custom data that you can add to this object.

ReportDateinteger or nullOptional

Unix timestamp (UTC) of the date and time the report was generated.

StatusstringOptional

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).
DownloadFormatstringOptional

Returned values: CSV

The format in which the report is going to be downloaded.

DownloadURLstring or nullOptional

The URL at which the report file can be downloaded when the Status is GENERATED.

CallbackURLstringOptional

Max. length: 255 characters

The URL to which the notification indicating that the report is ready to be downloaded will be sent.

ReportTypestringOptional

Returned values: TRANSACTIONS, WALLETS

The type of the report, indicating whether it lists transactions or wallets.

SortstringOptional
The sorting direction of the CreationDate column. By default, the generated report is sorted by ascending creation date.
PreviewbooleanOptional

Whether the report is limited to the first 10 lines (and therefore quicker to generate).

FiltersobjectOptional
The filtering parameters to optimize the report.
Columnslist of stringsOptional

Returned values: The Columns listed in the Reports article, which differ according to the report type.

The information to be included in the report.

ResultCodelist of stringsOptional
The transaction result codes to be taken into account.
ResultMessagestringOptional
The explanation of the result code.