Create a Transactions Report

POST

/v2.01/:ClientId/reports/transactions

POST

/v2.01/:ClientId/reports/transactions

$ curl -X POST https://api.sandbox.mangopay.com/v2.01/ClientId/reports/transactions \
>      -H "Authorization: Bearer <token>" \
>      -H "Content-Type: application/json" \
>      -d '{
>   "body": {
>     "Tag": "Created using Mangopay API Postman Collection",
>     "DownloadFormat": "CSV",
>     "CallbackURL": null,
>     "Sort": "CreationDate:ASC",
>     "Preview": false,
>     "Filters": {
>       "BeforeDate": 1658317644,
>       "AfterDate": 1655725644,
>       "Type": [],
>       "ResultCode": [],
>       "Status": [],
>       "Nature": [],
>       "WalletId": null,
>       "AuthorId": null,
>       "MinDebitedFundsAmount": null,
>       "MinDebitedFundsCurrency": null,
>       "MaxDebitedFundsAmount": null,
>       "MaxDebitedFundsCurrency": null,
>       "MinFeesAmount": null,
>       "MinFeesCurrency": null,
>       "MaxFeesAmount": null,
>       "MaxFeesCurrency": null
>     },
>     "Columns": [
>       "Id",
>       "Tag",
>       "CreationDate",
>       "ExecutionDate",
>       "AuthorId",
>       "CreditedUserId",
>       "DebitedFundsAmount",
>       "DebitedFundsCurrency",
>       "CreditedFundsAmount",
>       "CreditedFundsCurrency",
>       "FeesAmount",
>       "FeesCurrency",
>       "Status",
>       "ResultCode",
>       "ResultMessage",
>       "Type",
>       "Nature",
>       "CreditedWalletId",
>       "DebitedWalletId"
>     ]
>   }
> }'

1 {
2   "Id": "report_m_01JFA0JQQJ1X6W6VT6042SASTC",
3   "CreationDate": 1734429204,
4   "Tag": "Created using Mangopay API Postman Collection",
5   "ReportDate": null,
6   "Status": "PENDING",
7   "DownloadFormat": "CSV",
8   "DownloadURL": null,
9   "CallbackURL": null,
10   "ReportType": "TRANSACTIONS",
11   "Sort": "CreationDate:ASC",
12   "Preview": false,
13   "Filters": {
14     "BeforeDate": 1658317644,
15     "AfterDate": 1655725644,
16     "Type": [],
17     "ResultCode": [],
18     "Status": [],
19     "Nature": [],
20     "WalletId": null,
21     "AuthorId": null,
22     "MinDebitedFundsAmount": null,
23     "MinDebitedFundsCurrency": null,
24     "MaxDebitedFundsAmount": null,
25     "MaxDebitedFundsCurrency": null,
26     "MinFeesAmount": null,
27     "MinFeesCurrency": null,
28     "MaxFeesAmount": null,
29     "MaxFeesCurrency": null
30   },
31   "Columns": [
32     "Id",
33     "Tag",
34     "CreationDate",
35     "ExecutionDate",
36     "AuthorId",
37     "CreditedUserId",
38     "DebitedFundsAmount",
39     "DebitedFundsCurrency",
40     "CreditedFundsAmount",
41     "CreditedFundsCurrency",
42     "FeesAmount",
43     "FeesCurrency",
44     "Status",
45     "ResultCode",
46     "ResultMessage",
47     "Type",
48     "Nature",
49     "CreditedWalletId",
50     "DebitedWalletId"
51   ],
52   "ResultCode": null,
53   "ResultMessage": null
54 }

Note – Report expiration date

A report expires after 24 hours (i.e., you can no longer download it after this period). You can still generate a new report with the same filters and information easily.

Note – BeforeDate value restriction

To ensure that data provided on each report are up-to-date, the BeforeDate parameter cannot be greater than the report creation date minus 5 minutes. If it is, BeforeDate will be automatically set according to this constraint.

Generate a legacy Transactions Report

<Note icon="fa-regular fa-circle-info"> **Note – Report expiration date** A report expires after 24 hours (i.e., you can no longer download it after this period). You can still generate a new report with the same filters and information easily. </Note> <Note icon="fa-regular fa-circle-info"> **Note – `BeforeDate` value restriction** To ensure that data provided on each report are up-to-date, the `BeforeDate` parameter cannot be greater than the report creation date minus 5 minutes. If it is, `BeforeDate` will be automatically set according to this constraint. </Note> Generate a legacy Transactions Report

Authentication

AuthorizationBearer

Bearer authentication of the form Bearer <token>, where token is your auth token.

If your platform is using a proxy to take SCA-triggering action on behalf of users, you also need to integrate mTLS authentication and use the api-mtls base URL.

Bearer authentication of the form `Bearer <token>`, where token is your auth token. If your platform is using a [proxy](/guides/sca/proxy-management) to take SCA-triggering action on behalf of users, you also need to integrate [mTLS authentication](/guides/sca/platform) and use the `api-mtls` base URL.

Path parameters

ClientIdstringRequired

Platform's API account identifier, associated with the API key.

Request

This endpoint expects an object.

TagstringOptional

Max. length: 255 characters

Custom data that you can add to this object.

DownloadFormatstringOptional

Possible values: CSV

The format of the report file.

CallbackURLstringOptional

Max. length: 255 characters

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

SortstringOptional

Possible values: CreationDate:ASC, CreationDate:DESC

Default value: CreationDate:ASC

The sort direction based on transaction 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

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

The information to be included in the report.

Response

Success

Idstring

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

The unique identifier of the object.

CreationDateinteger

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

Tagstring

Max. length: 255 characters

Custom data that you can add to this object.

ReportDateinteger or null

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

Statusstring

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

DownloadFormatstring

Returned values: CSV

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

DownloadURLstring or null

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

CallbackURLstring

Max. length: 255 characters

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

ReportTypestring

Returned values: TRANSACTIONS, WALLETS

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

Sortstring

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

Previewboolean

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

Filtersobject

The filtering parameters to optimize the report.

Columnslist of strings

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

The information to be included in the report.

ResultCodestring

The code indicating the result of the operation. This information is mostly used to handle errors or for filtering purposes.

ResultMessagestring

The explanation of the result code.

Errors

400

Bad Request Error